Ahmed
CCConvex Community
•Created by Ahmed on 12/14/2024 in #support-community
Help with search in join table
Hi there, thanks for your answer! The key requirements are:
- The search should allow finding workspaces by their name
- Results should be paginated
- The search results should include workspaces where the user is either a member without being the owner OR is the owner depending on an argument passed to the query.
While we don't anticipate users being part of hundreds of workspaces, the system should be built to handle that possibility if it occurs and we have exactly the same functionality involving other tables.
We're also using aggregate instead of collect like convex suggests for large data.
7 replies