Experience Report for Feature Request
What you wanted to do
Provide a pre-sorted list of ids (uids) and return results with pagination by order
What you actually did
Nothing, not possible
Why that wasn’t great, with examples
We cannot do sorting and pagination all on client side because we are combining this sorted list with other filters. So our ordered list might be [0x1, 0x2, 0x5, 0x4] but another filter is not: { field: { eq: "..." } } which might exclude 0x2 and 0x5 but we don’t know that on the client side. If we were to just get all results and then order them locally, then we lose the performance of just getting the first page of results that we are displaying and potentially return thousands of results to just get the first 10 and potentially very quickly a user changes a filter and we would need to fetch ALL results again.
Any external references to support your case
Basically we are trying to adhoc some search ranking and before in a rdbms we used a ranking field that we created within the query and gave score values and then sorted by those scores, since we cannot ad an field in the query to give scores to with filters then we are trying to work around that.