Buy Now
Sign in

Order by column ASC with NULL at bottom

ctrlmedia , April 18 2017
Answered
C
ctrlmedia
Hi,
I can see there are many ways to make a column with numbers for example (1, 4, 2, null, 3, 6, null, 5) to order like:
(1,2,3,4,5,6, null,null)

using

ORDER BY -column DESC

ISNULL(column), column ASC;

but I am not sure how to enter any of this in to the Order By box within connectivity v6?

Thanks in advance for any help.
Kind Regards
C
ctrlmedia
Hi,
I am still stuck with this if anyone out there has any ideas, how can I order my rows with null at the end within the order by box?
(1,2,3,4,5,6, null,null)

Thanks.
C
ctrlmedia
For anyone needing the answer to this I think I have worked a way out - may be not the best way but it works for me.

In "Fields to Retrieve" add ISNULL(model.field) and then check "this is an extra fields list" beneath.

In "Order Fields" add:

ISNULL(model.field)/ASC
model.field/ASC



Hope this helps someone.
Regards
admin
Glad you figured it out, thanks for posting the solution!

Best regards,
Max
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!