3 replies

How to implement pagination with join and filtering

Given that I have these 2 tables that describes a 1-to-many relationship: "a user can be member of 1 or many groups"

defineSchema({
   groups: defineTable({
      group_name: v.string(),
   }),
   members: defineTable({
      group_id: v.id("groups),
      user_id: v.id("users") 
   })
})

defineSchema({
   groups: defineTable({
      group_name: v.string(),
   }),
   members: defineTable({
      group_id: v.id("groups),
      user_id: v.id("users") 
   })
})

What would be the convex way to implement the following paginatedpaginated query: get groups of user A (each page has 10 items)get groups of user A (each page has 10 items). This is (a naive) equivalent SQLSQL query:

SELECT G.* FROM groups G
JOIN members M ON G._id = M.group_id
WHERE M.user_id = 'A'
LIMIT 10 OFFSET __page_offset__

SELECT G.* FROM groups G
JOIN members M ON G._id = M.group_id
WHERE M.user_id = 'A'
LIMIT 10 OFFSET __page_offset__

Convex Community•2y ago•

3 replies

noob saibot

How to implement pagination with join and filtering

Given that I have these 2 tables that describes a 1-to-many relationship: "a user can be member of 1 or many groups"

defineSchema({
   groups: defineTable({
      group_name: v.string(),
   }),
   members: defineTable({
      group_id: v.id("groups),
      user_id: v.id("users") 
   })
})

defineSchema({
   groups: defineTable({
      group_name: v.string(),
   }),
   members: defineTable({
      group_id: v.id("groups),
      user_id: v.id("users") 
   })
})

SELECT G.* FROM groups G
JOIN members M ON G._id = M.group_id
WHERE M.user_id = 'A'
LIMIT 10 OFFSET __page_offset__

SELECT G.* FROM groups G
JOIN members M ON G._id = M.group_id
WHERE M.user_id = 'A'
LIMIT 10 OFFSET __page_offset__

Continue the conversation

Join the Discord to ask follow-up questions and connect with the community

Convex Community

Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.

15,960 Members

Join

How to implement pagination with join and filtering

How to implement pagination with join and filtering

Continue the conversation

Convex Community

Continue the conversation

Convex Community

Similar Threads