I know similar questions have been posted: Sorting Question! Empty fields
But it seems more of a fundamental issue with sorting a DB. When I sort a RG on a random field, descending or ascending, the empty fields always show at the bottom. This is not great when going through reports an definitely not good for my task list that gets sorted on date.
I know there is a workaround, but it requires additional programming making that particular RG even slower to load.
Is this a simple fix from a db perspective? I think it should be standard.