Querying existing / missing values

There are two ways of querying missing values:

By filter

The exists- and notExists-filters is the recommended and most efficient way of query for missing values

{
  "start": 0,
  "count": 2,
  "filters": {
    "exists": {
      "field": "publish.from"
    }
  }
}
{
  "start": 0,
  "count": 2,
  "filters": {
    "notExists": {
      "field": "publish.from"
    }
  }
}

See the exists-filter and notExists-filter

By query

This method is not as efficient as using a filter, but if you need to do this within a query-expression, you could use the “LIKE” function with an all-expression:

  • Exists:

    myValue LIKE "*"
    
  • Not-exists:

    publish.first NOT LIKE "*"