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:
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.
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?
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:
Hope this helps someone.
Glad you figured it out, thanks for posting the solution!
If your main question got answered then please mark the answer using the button!
2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com