Answer

[FDM] How to filter custom array properties in a GraphQL query

Forum|Forum|2 years ago
August 9, 2023
4 replies
99 views

+6

Lucas Carvalho de Sousa
Seasoned

I have some views with simple array properties (arrays of primitives) and others with arrays of relationships to views (edges).

I can filter the simple arrays with the “containsAll” or “containsAny” methods.

But there seems to not be a filter avaiable for the edges in the Graphql API.

How can I filter by these properties via the GraphQL API?

Best answer by mattmurph9

We currently don’t support filtering on properties of related nodes from a 1:many relationship. But we do support filtering on properties that are related in a 1:1 relationship.

M

mattmurph9
Practitioner
Answer
Forum|Forum|2 years ago
August 11, 2023

We currently don’t support filtering on properties of related nodes from a 1:many relationship. But we do support filtering on properties that are related in a 1:1 relationship.

Like

M

mattmurph9
Practitioner
Forum|Forum|2 years ago
August 11, 2023

Though if you instead query for the related type (say Role from your above types), and add a 1:1 relation back to the ‘parent’ (User in this case), you can then filter on properties of the User and Role. So the Role type and query would become

type Role {
  ...
  user: User
}


{
  listRole(filter: { and: [ { ...some filter on properties of Role }, { user: { ...some filter on properties of User } } ] }) {
    items {
      externalId
      roleName
      user {
        externalId
      }
    }
  }
}