Sorting empty at 'end' of list not before '1' in descending list.

[walshy]

Howdy all!

is it possible to order a list 1-100 with empty being at the bottom of the list rather than before 1. I need to have the list order with the 'empty' value at the bottom not the top of the list but still keep descending order. 

I have a filter on the list 

u_performance_statusIN2,3^u_order_2ISEMPTY^u_order_3ISEMPTY^u_order_4ISEMPTY

I dont want to have to force an insert of 99 or something into the u_order_xxx field to have the unchosen item to be at the bottom of the list. 

When the end user hits 'set order' header the list either goes 4-3-2-1 empty... or empty empty empty..... 1-2-3-4

I need it to go 1-2-3-4 empty...

Any ideas if this question even makes sense. ha.

thanks!

[SaiRaviKiran Ak]

Below links could help you out:

Sort order control

Controlling the sort sequence used to display lists

[bernyalvarado]

Hi Walshy,

Unfortunately I don't think there's a way to do what you're asking without getting hacky and inserting a big number like 9999 and then displaying it as space or white font when it's been observed by an end user.  

Perhaps, you may want to explore how your end users are using your list. It could be worth to have 2 list views available from their navigation window. 1- for the ordered list filtering out the empty ones and 2- for the list of the empty ones that need to be changed to something by the end users.

Perhaps the UX is even better taking that approach.

Thanks,

Berny

[walshy · Accepted solution]

I ended up making the field I wanted to filter into an integer, it was a string, and changed the data going into the table. 

Thus I removed the empty issue, and the fields listed 1- 15 properly not 1, 10, 11, 12, 2, 3 etc. 

Thanks!