FlufiusF
Convex Community•4d ago•
1 reply
Flufius

Querying a table with filtering + sorting by different fields

❔Advice
Hi, I have a table with 
startDate
 and 
endDate
 columns, and I need to filter by 
endDate
 to be greater than now, then sort the result by 
startDate
, and I need it paginated. An index like 
by_endDate_startDate
 allows filtering by 
endDate
, but then the sorting will be also done by 
endDate
, that is if I apply pagination. I can sort manually in JS if I retrieve all filtered data, but then I can't apply pagination to that.
Data will be added with timestamps in the future, which then will expire. In other words I'll have a lot of "expired" rows with both timestamps in the past, and I need to display a smaller part with timestamps in the future.
Can I implement it in Convex in a good enough way? Any advice would be appreciated.
Was this page helpful?