Solved

How to filter null values of FDM view's inherent property in GraphQL

  • 13 June 2023
  • 3 replies
  • 118 views
M
Rank
Userlevel 1

Hi Team,

In GraphQL there is no (known) option to filter null values of FDM View’s direct properties which refer to another view(s).

For example: Consider the snapshot of the views.

Here if we want to filter all MyTypeWrapper instances which has ‘myType’ property as null.

How could it be achieved using GraphQL?

-Mohit

icon

Best answer by Jason Dressel 18 July 2023, 22:52

View original

3 replies

Dilini Fernando
Rank
Userlevel 4
Badge +2

Hi @Mohit Shakaly,

I have created a Support ticket, then our team can follow up and help you. 

Best regards,
Dilini

J
Rank
Userlevel 4
Badge

@Mohit Shakaly
myType is a directRelation.  It’s type is defined by a (space, externalId) tuple. 

Apologies for the very delayed reply.   I’m using the null of the externalId as a measure of ‘null’ with respect to the direct relation.

# Based on the following model derived from the Actor/Movie example:


type PersonType @view(space: "test", version: "1") {
    typename: String!
}

interface Person @view(space: "test", version: "1") {
    typename: PersonType
    name: String!
    age: Int
}

#populate your Actors with 'actor' as the PersonType, do not populate the Directors with any typename

# using the following graphQL query, you'll get just 'Director' Persons
query MyQuery {
  listPerson(filter: {typename: {externalId: {isNull: true}}}) {
    items {
      name
      typename {
        typename
      }
    }
  }
}

 

 

fyi @Dilini Fernando 

M
Rank
Userlevel 1

Thanks @Jason Dressel.

Reply


Terms & ConditionsCookie Settings