offset-based pagination with filtering

// 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,
});

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 } )
 } 
})