graphql - how to filter a nested list

Question

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?

Answer 1

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
      }
    }
  }
}