Convex CommunityCCConvex Community
Powered by
zidZ
Convex Community•3y ago•
2 replies
zid

multiple pagination queries in a single function

i imagine this to be uncommon scenario, but came across a situation where having the ability to setup 2 pagination queries inside a single function wouldve been great.

my scenario is that i have 2 tables,
threads
threads
and
comments
comments
, where they each have a
status
status
property that can hold the following values
hidden
hidden
and
visible
visible
.

What id like to be able to do is fetch all the hidden threads and comments, and return a single list
[...threads, ...comments]
[...threads, ...comments]
.

Another way to handle this is to create a dedicated table
hiddenPosts
hiddenPosts
for example, but feels like more of a workaround.

Currently, I'm using two separate pagination queries, then using a useEffect to concatenate/spread them into a single result using local state.

Curious if this will ever be supported?
Convex Community banner
Convex CommunityJoin
Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.
15,010Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements
Recent Announcements
james

Hi @everyone with everything going on today I forgot to post on discord about our EU launch! We have a region in Dublin now! You can start using it immediately, even for folks on the free plan. https://news.convex.dev/we-finally-got-our-eu-visa/ Stay tuned for more regions but also stay tuned for more infra improvements where we improve latency for teams no matter where their servers are located. Just at the tip of the iceberg re all the optimizations we have lined up.

james · 2d ago

Wayne

Hi @everyone happy Monday. Components Authoring [Challenge](https://www.convex.dev/components/challenge) updates! Meet the second batch of community-approved components **Firecrawl Scrape **- Scrape any URL and get clean markdown, HTML, screenshots, or structured JSON - with durable caching and reactive queries. https://www.convex.dev/components/firecrawl-scrape Built by: Gitmaxd **Durable Agents **- A Convex component for building durable AI agents with an async tool loop. https://www.convex.dev/components/durable-agents Built by: Siegfried **Convex Debouncer** - A server-side debouncing component for debouncing expensive operations like LLM calls, metrics computation, or any heavy processing that should only run after a period of inactivity. https://www.convex.dev/components/debouncer Built by: Ilya **DatabaseChat **- A Convex component for adding natural language database queries to your app. https://www.convex.dev/components/database-chat Built by: Nick **Transloadit** - A Convex component for creating Transloadit Assemblies, handling resumable uploads with status, and persisting status/results in Convex. https://www.convex.dev/components/transloadit Built by: Kvz **Loops** - A Convex component for integrating with Loops.so email marketing platform. https://www.convex.dev/components/loops Built by: Bobby The [challenge](https://www.convex.dev/components/challenge) is now ongoing, so keep building, and we'll keep rewarding. Thanks, everyone!

Wayne · 2w ago

Liz C

Hi everyone! Have you ever wanted to get your hands on some convex swag? Well you're in luck! We just launched our Convex swag store. Check it out here ---> https://store.convex.dev/

Liz C · 3w ago

Similar Threads

Multiple queries suggestion
unsphereUunsphere / support-community
3y ago
Too many reads in a single function execution (Mutation)
noob saibotNnoob saibot / support-community
9mo ago
Too many bytes read in a single function execution in migration
CabalDAOCCabalDAO / support-community
16mo ago
Too many reads in a single function execution (limit: 4096)
girayGgiray / support-community
11mo ago