Theo's Typesafe Cult•2y ago

Is there a way to call a trpc useQuery() multiple times?

I have a list of objects, and i would like to call the useQuery 1 time for every object in order to get some deta. Is there a good way to do this?

27 Replies

Pod•2y ago

The best method would probably be for you to refactor your query to take in multiple objects

Christian Lind•2y ago

this seems like such an oversight imo, might be wrong though

Pod•2y ago

Can you give a bit more detail on what you're trying to do? If you don't want to get all the data in one query the next best way is probably making a component that has the query attached

Christian Lind•2y ago

thats a smart workaround!

Pod•2y ago

👍

Christian Lind•2y ago

thanks Pod!

Pod•2y ago

np, gl!

Pod•2y ago

@Christian Lind There is also this if it makes more sense for your use case https://trpc.io/docs/reactjs/usequeries

useQueries() | tRPC

The useQueries hook can be used to fetch a variable number of queries at the same time using only one hook call.

Pod•2y ago

Which does have some nice benefits 👌

Christian Lind•2y ago

oo sweet @Pod Could i ask you one more question? Its regarding prisma and joins?

Pod•2y ago

For sure

Christian Lind•2y ago

Thanks mate! I have 2 tables, and would like to do a classic inner join between them, How could i achieve this using prisma?

Pod•2y ago

You can do something along the lines of

prisma.tableA.findMany({
  include: {
    tableB: true
  }
})

prisma.tableA.findMany({
  include: {
    tableB: true
  }
})

Christian Lind•2y ago

I have implemented it by using a query raw select * from SeenQuestions JOIN Xyz on SeenQuestions.questionId = Xyz.id where Xyz.subcategory=${input.subCategory} In that case - don't i have to add the relation in the prisma schema?

Pod•2y ago

Yes

Gaming

Programming

Is there a way to call a trpc useQuery() multiple times?