Back
Query.orderAsc() with null values last
I'm sorting documents based on their due dates in ascending order. When I use the Query.orderAsc("dueDate") method, it rightly places documents with a null "dueDate" at the beginning. However, this creates a challenge for my pagination. I'm exploring whether there's a way or a workaround to arrange documents with null "dueDates" at the end of the list instead. Any suggestions or options for achieving this?
TL;DR
The user wants to sort documents based on their due dates in ascending order, but documents with null due dates are placed at the beginning, causing a challenge for pagination. They are looking for a way or workaround to arrange documents with null due dates at the end of the list instead.
You could filter out null valued records, and put them at the end? Not a very elegant solution, but it does the job
@ideclon That's how I am doing it currently. I hoped there was a more elegant solution. Thanks for your help anyways!!
