Ability to sort keeping null values at bottom of column.


I have a list of values with nulls included (ie, [‘1’,‘4’,‘7’,’’,‘2’,‘3’,’’,‘5’]). Is it possible for the sort order to be set up to keep the null/empty strings at the bottom in both directions of the sort?



Ascending: [‘1’,‘2’,‘3’,‘4’,‘5’,‘7’,’’,’’]



Descending: [‘7’,‘5’,‘4’,‘3’,‘2’,‘1’,’’,’’]



In this case, the null values indicate that the test represented by the column wasn’t performed so they should always be at the end.

It can be done with custom sorting routine. Please find more information here dhtmlx.com/dhxdocs/doku.php?id=d … id:sorting