graphql - how to filter a nested list

user_3428422 0
Viewed 1309

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?

hotchocolate graphql
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
      }
    }
  }
}
user_71888520 
companies(
  where:{
    company: {
      offices: {
        some: {IsActive: {eq: true}}
      }
    }
  }
)

If filter is boolean then query doesn't work if Offices has IsActive bool field

user_153763500
Related