I am currently trying to filter a nested list based on a given id, but don't understand the syntax required. Although I have altered the entities and properties, this is what I am attempting
{
companies{
company{
id,
name,
offices(where:{officeId: {eq: 2}}){
officeId,
address,
}
}
}
}
In the returned data, I would like ALL companies and their offices where the office id is equal to 2. Is this possible and how would I do this?
2 Answers
This way you filter the offices inside all companies Try this
{
companies(where:{company: {offices: {some: {officeId: {eq: 2}}}}}){
company {
id
name
offices {
officeId
address
}
}
}
}
companies(
where:{
company: {
offices: {
some: {IsActive: {eq: true}}
}
}
}
)
If filter is boolean then query doesn't work if Offices has IsActive bool field
