3 replies

combine list query results in one

I have

conversations

conversations

that are linked to an

account

account

  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

all

conversations

conversations

of an

account

account

.

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

accounts

accounts

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

conversations

conversations

of multiple

accounts

accounts

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

and

ordered by time)

- without making

times more queries to return one single page.