Problem
In Fee Management, I cannot sort the datagrid by Description.
If I filter any other column, I cannot sort of Description. But if I filter on Description, I can sort on that column. The only problem is that I want to filter Description based on 'Greater than or equal to '' ', but apparently you cannot do that.
Solution
That datagrid is a 'Search first' datagrid which requires the initial sorting to be done on the server side so only the columns that are indexed are able to be sorted. After filtering for the first time though it should then allow you to sort that column as it is sorting on the UI side at that point.
No blank is considered 'not filtered' as there wasn't really any other way to skip filtering (as filtering is pretty intensive). Basically 'blank', '0', '0.00' or '$0.00' are all considered 'No Filtering' values.
So you effectively can't sort on Description because it is not indexed. We had to do that because we didn't want any runaway queries with bad by statements for non-indexed fields.