Submitted by David_H on 2016/08/10 22:00
I use a Sort Order column so that I can set a manual sort order for certain grids.  Unfortunately it doesn't work very well because when sorting ascending it always places blanks in the sort column at the top.  So using X below to represent a blank, it sorts like this:
 
X
X
X
1
2
 
But at least for me the whole point of using a manual sort order is I want to have a few important items always show up at the top.  If the user wanted blanks to show up at the top they wouldn't be using a sort order at all, I'd think?  So the only way to achieve what's desired is to give every single item in the grid some sort value, even if unneeded.  Which is a PITA.  Would you consider making blanks sort at the bottom?
 
Thanks

Comments

As a work-around you can use an Auto-Assign from your SortField(e.g.testSortingTextField) to another dummy Yes/No field (e.g. testSortingBool)  to be checked if there is content in the SortField.
 
Auto-Assign for the SortField: A: [testSortingBool]=-1 | E: [testSortingBool]=0
 
Then you can sort at the same time in the "Source Items Sort", first by Dummy Field, second by SortField: testSortingBool, testSortingTextField
 
Of course the testSortingBool may be hidden or even removed from the Grid, so you wouldn't lose anything visually.