Operator Name

Operator 

Example

Equal To a Single Value

:

symbol:"PCAAS00"
 assessDate:"2020-12-31"

Equal To a List of Values

IN

symbol IN ("PCAAS00","PCAAT00")

Greater Than

> 

assessDate>"2020-12-31"

Greater Than or Equal To

>=

assessDate>="2020-12-31"

Less Than

< 

assessDate<"2020-12-31"

Less Than or Equal To

<=

assessDate<="2020-12-31"

Not Equal To a Single Value

!:

symbol!:"PCAAS00"
 assessDate_date!:"2020-12-31"

Not Equal To a List of Values

NOT IN

symbol NOT IN ("PCAAS00","PCAAT00")

Logical AND

AND

assessDate>="2021-01-01" AND assessDate<="2021-01-31"

Logical OR

OR

symbol:"PCAAS00" OR symbol:"PCAAT00"

Data Type

Value Syntax

Example

Date

"YYYY-MM-DD"

"2020-12-31"

DateTime

"YYYY-MM-
 DDTHH:MM:SS"

"2020-12-31T00:00:00"

String, Array

"Insert Text"

"TYAAB00"
 "2020-12-31"