Is there any support for nested queries? Say I wan...
# orm-helps
Sam Jackson
05/24/2018, 4:54 PMIs there any support for nested queries? Say I wanted to do something like getting all posts from my own friends:
Copy code
posts {
id
author {
id
friends (
where: {
id: myID
}
) {
id
}
}
}Sam Jackson
05/24/2018, 4:56 PMThe alternative is to retrieve my
friendsgetPostsByAuthorl
lawjolla
05/24/2018, 4:59 PMI've used nested arguments. Are you getting errors?
s
Sam Jackson
05/24/2018, 5:00 PMNo, I was just seeing if that was doable.
Sam Jackson
05/24/2018, 5:00 PMI'm assuming you didn't get errors 😄
l
lawjolla
05/24/2018, 5:00 PMI always get errors. 🙂
😂 3
lawjolla
05/24/2018, 5:01 PMIt can take a little bit of stitching to get it set up between your application and Prisma, but it'll work
lawjolla
05/24/2018, 5:02 PMI have a similar query where I get the total cost of a product, e.g.
Copy code
deal {
...
amount
salesTaxRate(state: "CA") { rate }
}s
Sam Jackson
05/24/2018, 5:03 PMCool. Thank you!
💯 1
Sam Jackson
05/24/2018, 6:15 PMI hope you don't mind if I follow up on this, but this similar query is returning a 400 error. Playground isn't catching any syntax errors.
Copy code
query getTopLevelPostsForUser($id: ID!) {
getTopLevelPostsForUser{
id
author(where:{
id:$id
}) {
id
}
}
}l
lawjolla
05/24/2018, 8:49 PMSorry, just saw this! What does the error say? Since you're using the Prisma generated syntax, make sure you have the author type properly imported.