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!