noob saibot
noob saibot•2w ago

offset-based pagination with filtering

How can I implement an offset-based pagination with filter? User would like to fetch paginated data but have a away to limit the data by status. Here is what I've implemented so far. First the 2 tables and the aggregation: 
// tables
campaigns: {
  id,
  name, 
}
campaign_members: {
  id,
  user_id, 
  campaign_id,
  status: active, paused, completed, exited...etc
}
// aggregate
export const campaign_members_aggregate = new TableAggregate<{
  Key: number;
  Namespace: Id<"campaigns"> | undefined;
  DataModel: DataModel;
  TableName: "campaign_members";
}>(components.campaign_members_agg, {
  namespace: doc => doc.campaign_id,
  sortKey: doc => doc._creationTime,
});
// tables
campaigns: {
  id,
  name, 
}
campaign_members: {
  id,
  user_id, 
  campaign_id,
  status: active, paused, completed, exited...etc
}
// aggregate
export const campaign_members_aggregate = new TableAggregate<{
  Key: number;
  Namespace: Id<"campaigns"> | undefined;
  DataModel: DataModel;
  TableName: "campaign_members";
}>(components.campaign_members_agg, {
  namespace: doc => doc.campaign_id,
  sortKey: doc => doc._creationTime,
});
Then the paginated query which is passed the offset and an optional status argument: 
export const members_of_campaign = query({
 args: {
  campaign_id: v.id("campaigns"),
  offset: v.number(),  
  status: // optional status passed from client UI
 },
 handler: async (ctx, { campaign_id, offset, status }) => {
   // what's the approach to further filter by status
   const {} = await aggregate.at(ctx, offset, { namespace: campaign_id } )
 } 
})
export const members_of_campaign = query({
 args: {
  campaign_id: v.id("campaigns"),
  offset: v.number(),  
  status: // optional status passed from client UI
 },
 handler: async (ctx, { campaign_id, offset, status }) => {
   // what's the approach to further filter by status
   const {} = await aggregate.at(ctx, offset, { namespace: campaign_id } )
 } 
})
3 Replies
Convex Bot
Convex Bot•2w ago
Thanks for posting in <#1088161997662724167>. Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets. - Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.) - Use search.convex.dev to search Docs, Stack, and Discord all at once. - Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI. - Avoid tagging staff unless specifically instructed. Thank you!
noob saibot
noob saibotOP•2w ago
Do I perhaps conclude that this feature is not possible in convex?
jamwt
jamwt•2w ago

Did you find this page helpful?