Where

The where parameter specifies the filter condition for the result returned by the query. It filters and searches for values in fields to reduce or increase the results retrieved by Optimizely Graph.

where: [{filter_condition}]

The filter_condition is defined like this:

predicate: {
      filter_operators: expression
}

Definitions

• {filter_condition} – Defines the conditions to be met for the result to be returned. There is no limit to the number of predicates that can be included in a filter_condition.
• predicate – A field name.
• filter_operators – Matching functions (called "operators") that operate specifically on string, number, date, and Boolean values, and operator options like boost and synonyms that work together with the operators.
• expression – A string, numeric, enumerated, or Boolean value.

📘

Note

Optimizely supports using _modified extend argument to query content. Whenever content is synced to the service, that content would be marked with _modified extend field equal now().

Examples

The following examples show how to use some common filter conditions in the where clause.

Where with eq operators

{
  BiographyPage(where: {
    Name: {
         eq: "Alan Turing"
     }
  }, locale: [en]) {
    Name
    Language {
      Name
      DisplayName
    }
  }
}

Query with dates

Querying for date values is flexible. You can query for exact date values indexed in the ISO 8601 standard.

{
  BiographyPage(where: { Born: { eq: "1983-11-14T00:00:00Z" } }) {
    items {
      Name
      Born
    }
    total
  }
}

You can write this date query in a different format, but then you need to specify the time zone UTC, or else the date value is converted to a date value from the local system, resulting in no matches.

{
  BiographyPage(where: { Born: { eq: "11/14/1983 00:00:00 AM UTC" } }) {
    items {
      Name
      Born
    }
    total
  }
}

The power of the date queries is that you can query for results between time ranges, with an optional time. This query returns results where the value for Born is equal or greater than "1947-07-30".

{
  BiographyPage(where: { Born: { gte: "1947-07-30" } }) {
    items {
      Name
      Born
    }
    total
  }
}

Where with multiple filter conditions

{ 
  BiographyPage(where: {
      Name: {
        eq: "Alan Turing"
      }
      Language: {
        DisplayName: {
          eq: "English"
        }
      }
  }, locale: [en]) {
    Name
    Language {
      Name
      DisplayName
    }
  }
}

📘

Note

The AND operator is the default logical operator that applies to the group of multiple filtered conditions, so the above query can be understood like this:

C#

if (Name == "Alan Turing" AND Language.DisplayName == "English")

See Logical connectors for information about logical operators AND, OR, and NOT.

Where with _modified extend date argument.

The _modified field contains the date time when content was created, updated, or deleted in the service. The value in _modify will not be the same as the created or saved value on the content.

The _modified field can be used to accomplish a delta import of content from the service, for example, "give me content that was modified after (gt) 2023-09-13T04:36:14Z". You can use filtering by _modify field with cursor to accomplish the delta import of content from the service.

{ 
  BiographyPage(where: {
      _modified: {
        gte: "2021-09-13T04:36:14Z"
      }
  }, locale: [en]) {
    Name
    Language {
      Name
      DisplayName
    }
  }
}