Query Operators

The following are the valid options for the ["operator"] parameter of a query statement.

  • "~" - A key’s contents contains the ‘value’. Synonyms: ":","is in","contains"
  • "!~" - A key’s contents does not contain the ‘value’. Synonyms: "!:","is not in","does not contain"
  • "="- A key’s contents is equal to the ‘value’. Synonyms: "equal to","equals","is"
  • "!=" - A key’s contents is not equal to the ‘value’. Synonyms: "<>","not equal to","does not equal","is not"
  • "[" - A key’s contents begins with the ‘value’. Synonyms: "starts with","begins with"
  • "]" - A key’s contents ends with the ‘value’. Synonyms: "finishes with","ends with"
  • ">" - A key’s contents are greater than the ‘value’ (non-numeric contents are ignored). Synonyms: "gt","greater than"
  • "<" - A key’s contents are less than the ‘value’ (non-numeric contents are ignored). Synonyms: "lt","less than"
  • ">=" - A key’s contents are greater than or equal to the ‘value’ (non-numeric contents are ignored). Synonyms: "ge","greater than or equal to"
  • "<=" - A key’s contents are less than or equal to the ‘value’ (non-numeric contents are ignored). Synonyms: "le","less than or equal to"
  • "date>" - A key's contents are later than than the datetime of the 'value' (non-dateitems contents are ignored).
  • "date<" - A key's contents are earlier than the datetime of the 'value' (non-dateitems contents are ignored).
  • "date<=" - A key's contents are earlier or the same as the datetime of the 'value' (non-dateitems contents are ignored).
  • "date>=" - A key's contents are later or the same as the datetime of the 'value' (non-dateitems contents are ignored).
  • "date=" - A key's contents are equal to the datetime of the 'value' (non-dateitems contents are ignored).
  • "date!=" - A key's contents are not equal to the datetime of the 'value' (non-dateitems contents are ignored).
  • "regex" - A key’s contents matches the ‘value’ regular expression. Synonyms: "matchText"
  • "filter" - A key's contents match the 'value' filter.