Paginate many to many edge (ents)

[sharp dust]

Hello, I don't get how to paginate a many to many query on convex-ents:

const result = username === ""
      ? await ctx.table("organizations").getX(organizationId).edge("users")
      : await ctx
        .table("users")
        .search("search_username", (q) => q.search("username", username).eq("organizationId", organizationId))
        .paginate(paginationOpts);
    return result;
````

My problem is on this line :

```await ctx.table("organizations").getX(organizationId).edge("users")`````

[sharp dust]

For now I've done this as workaround:

await ctx.table("users").filter(q => q.eq(q.field("organizationId"), organizationId)).paginate(paginationOpts)`````

But I had to add an organizationId field, and not use the edge

[bright totem]

It's not supported currently, I filed https://github.com/xixixao/convex-ents/issues/25 for it.

You could hand roll it via ctx.db (you need to paginate the edge table).

[sharp dust]

Ok no problem, any thought on this workaround ?

await ctx.table("users").filter(q => q.eq(q.field("organizationId"), organizationId)).paginate(paginationOpts)

Thank you

[bright totem]

paginate is supported on 1:many edges, so since you wanted the end to be optional, another work around would be to a create a "sentinel" group, to which you assign all the users who don't have a group.

For your workaround: Use an index

[sharp dust]

Yes ok thank you 🙏🏾