Querying a table with filtering + sorting by different fields
❔Advice
Hi, I have a table with
Data to the table will be added with timestamps in the future, and then as the times goes the entities will "expire". In other words, I'll have a lot of "expired" rows with both timestamps in the past, and I need to display them on one page, and a smaller dataset with timestamps in the future.
Can I implement it in Convex in a good enough way? Any advice would be appreciated.
startDatestartDate and endDateendDate columns, and I need to filter by endDateendDate to be greater than now, then sort the result by startDatestartDate, and I need it paginated. An index like by_endDate_startDateby_endDate_startDate allows filtering by endDateendDate, but then the sorting will be also done by endDateendDate, 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 to the table will be added with timestamps in the future, and then as the times goes the entities will "expire". In other words, I'll have a lot of "expired" rows with both timestamps in the past, and I need to display them on one page, and a smaller dataset with timestamps in the future.
Can I implement it in Convex in a good enough way? Any advice would be appreciated.
