3 replies

combine list query results in one

I have

conversations

conversations

conversations

conversations that are linked to an

account

account

account

account:

  conversations: defineTable({
    account_id: v.id("connected_accounts"),
    name: v.string(),
    ...
  })

  conversations: defineTable({
    account_id: v.id("connected_accounts"),
    name: v.string(),
    ...
  })

  conversations: defineTable({
    account_id: v.id("connected_accounts"),
    name: v.string(),
    ...
  })

  conversations: defineTable({
    account_id: v.id("connected_accounts"),
    name: v.string(),
    ...
  })

and a paginated query to

list

list

list

list all

conversations

conversations

conversations

conversations of an

account

account

account

account.

But I also want to be able to see predefined groups of

accounts

accounts

accounts

accounts at the same time.
Is there an optimized way to view the combined

conversations

conversations

conversations

conversations of multiple

accounts

accounts

accounts

accounts in one paginated query. (ex: having a query that combine the conversations of account

A

A and

B

B ordered by time)

- without making

n

n times more queries to return one single page.