GraphQL filter_query OR Operator

[christoph-sachs]

Hey guys,

based on the documentation of filter queries (https://www.storyblok.com/docs/api/content-delivery/v2/filter-queries) I tried to get a GraphQL filter_query with an OR operator but playground just returns "Internal Server Error"

The Idea is to get a query to get entries with fieldA = "x" OR fieldB = "y"

  SampleItems(filter_query: {
    _or: [
      {fieldA: {in: "X"}},
      {fieldB: {in: "Y"}}
      ]
    }, per_page: 10)
  {
    items {
      content {
        fieldA,
        fieldB
      }
      slug
      full_slug
    }
    total
  }
}

[conorheffron]

@christoph-sachs

I recently set up an order by filter using GraphQL & Java backend for resolving sorted query results.

This may be the issue where you need to resolve the new query mapping on the backend, the GraphQL client side changes may not be enough.

There would need to be a custom OR filter setup which is not listed on the storyblok documentation here for API V2. There needs to be client side filter with custom backend implementation for the filter values and or operator.

Custom Filter Implementation

• Please see the code changes (GraphQL client side & backend) & issue information here
• See sample queries below with orderBy filter, field argument in [founded, name], and parameter/setting [ASC, DESC].

More on GraphQL Client Side / Schema Changes

Sort by charity name in descending order

query MyQuery {
  donateItems(orderBy:  {
     name: DESC
  }) {
    donate
    founded
    name
  }
}

Sort by charity name in ascending order

query MyQuery {
  donateItems(orderBy:  {
     name: ASC
  }) {
    donate
    founded
    name
  }
}

Sort by year founded in descending order

query MyQuery {
  donateItems(orderBy:  {
     founded: DESC
  }) {
    donate
    founded
    name
  }
}

Note: GraphQL input & enum

type DonateItem {
    donate: String!
    link: String!
    img: String!
    alt: String!
    name: String!
    overview: String!
    founded: Int!
    phone: String!
}

input DonateItemOrder {
    name: SortingOrder
    founded: SortingOrder
}

enum SortingOrder {
    ASC
    DESC
}

type Query {
    donateItems(orderBy: DonateItemOrder): [DonateItem]!
}

I hope this helps, example uses enum values instead of string literals for filter (the main difference from your original ask).

Custom filters are normally treated as arguments to a query.

• Official GraphQL Doc