FPagination, sorting and filtering
We're going through a migration to convex and one of our features has cards. We've filters for cards based on different values like owner, priority, dates, etc.
Users can sort by priority so that highest priority cards are available on top, then medium, low, etc. Users can also sort by creation date, due date, etc etc.
And lastly (the issue) we perform pagination, meaning that in the first page there may not be a high priority card but in the next page there are high priority cards available.
There are currently thousands of cards, meaning we can't perform a "collect all then sort then paginate" that won't work.
Is there any alternative to this?
Users can sort by priority so that highest priority cards are available on top, then medium, low, etc. Users can also sort by creation date, due date, etc etc.
And lastly (the issue) we perform pagination, meaning that in the first page there may not be a high priority card but in the next page there are high priority cards available.
There are currently thousands of cards, meaning we can't perform a "collect all then sort then paginate" that won't work.
Is there any alternative to this?
