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
|