Reporting > Native reporting system > How to edit or add a report > GUI editor > Select <class> Where dialog > Boolean symbols
  
Boolean symbols
Operator
Description
=
Equal to
<
Less than
>
Greater than
>=
Greater than or equal to
<=
Less than or equal to
< >
Not equal to
starts with
Filter definitions with properties that start with a letter or number
like
Filter definitions with properties that are like (but not exactly the same) as a certain value. This is best seen with * wildcards.
For example, the following query find all entities that have a ‘t’ in the middle of their name: Customer, Overseas Customer but not Room:
Type = "Entity" and "Name" like "*t*"
is NULL
Filter definitions with properties that are empty
is not NULL
Filter definitions with properties that are not empty or has a value
Parent topic
Select <class> Where dialog