Specialized Administration > Analyzing System and Business Information > Reports and Queries > Query Builder > Select or Constrain (Query Builder) > Adding and Editing Report Items > Operators (Select or Constrain)
  
Operators (Select or Constrain)
The available operators for a report item are determined by the data type of that report item.
Operator
String
Number
Date
Enumeration
Boolean
equals
X
X (default)
X
X (default)
X (default)
not
X
X
X
X
X
like
X (default)
not like
X
in
X
X
not in
X
X
>
X
X
X
>=
X
X
X
<
X
X
X
<=
X
X
X
null
X
X
X
X
X
not null
X
X
X
X
X
between
X (default)
yesterday
X
last week
X
last month
X
last quarter
X
last year
X
today
X
this week
X
this month
X
this quarter
X
this year
X
tomorrow
X
next week
X
next month
X
next quarter
X
next year
X