Page Comparison

=

==

Compare field with a value. You can use both "=" and "==". These and other operators can be used with most field types.

{reference} = "1223-82"
{id} = 10234

Use double quotes with strings.

Inside a string literal, a double quote is written as two consecutive double quotes:

{reference} = "Reference ""123"""

>, <

>=, <=

To compare numeric field values and dates.

{count} >= 100

!=

<>

AND

&&

Boolean "and" to combine conditions.

{count} >= 100 && {count} < 1000
{count} >= 100 AND {count} < 1000

OR

||

!=

Not equal.

{count} != 100
{reference} != "alpha"

( )

Brackets can be used to combine multiple conditions:

({count} == 100 OR {count} == 101) AND {status} == 10

!

NOT

Negation:

(NOT {count} == 100) OR {count} == 101
 
is equal to:
{count} != 100 OR {count} == 101

Evaluates y if x is true, evaluates z if x is false.

{count} >= ({status} = 1 ? 100 : 1000)

Literal to evaluate if a field is null or not:

{deadline} == nullNOTnull
NOT {deadline} == null

Numeric operators.

({words} * {document} > 1000)

.StartsWith

.EndsWith

.Contains

Various operators to search string fields by prefix, suffix or infix.

Use NOT to negate.

{reference}.StartsWith("123")
{reference}.EndsWith("123")
{reference}.Contains("123")
NOT {reference}.Contains("123")

To query by string length:

{reference}.Length < 10

You can use the DateTime object to compare dates.

To compare a date:

{deadline} >= DateTime(2007, 1, 1)

Or with hours, minutes and seconds:

{deadline} < DateTime(2007, 1, 1, 10, 30, 0)