Criteria Builder

Generic attributes

Asc

Ascending order

None

None

Desc

Descending order

None

None

Not

Unknown difference between Ne.

None

None

Database attributes

Between

Subset of data between value 1 and value 2.

String

String

Contains

A text string to compare against a database attribute. Any data containing the defined text string is selected.

String

None

Distinct

Select a single instance.

None

None

Eq

Select data where the defined attribute equals (==) a given text string.

String

None

Ge

Select data where the defined attribute is greater than or equal to (>=) a given text value.

String

None

Gt

Select data where the defined attribute is greater than (>) a given text value.

String

None

Ilike

Select data where the defined attribute is like a given text value. This option is similar to the SQL ilike function, and is not case sensitive.

String

String

In

Select data where the defined attribute matches any value in a list. The text value must be a comma-separated list of options.

String

Comma-separated list of strings

Iplike

Select data where the defined attribute matches a given IPLIKE expression.

String

None

IsNull

Select data where the defined attribute is null.

None

None

IsNotNull

Select data where the defined attribute is not null.

None

None

Le

Select data where the defined attribute is less than or equal to (<=) a given text value.

String

None

Lt

Select data where the defined attribute is less than (<) a given text value.

String

None

Like

Select data where the defined attribute is like a given text value. This option is similar to the SQL like function, and is case-sensitive.

Database attribute

String

None

Limit

Limit the result set to a given number.

None

Integer

None

Ne

Select data where the defined attribute does not equal (!=) a given text value.

String

None

OrderBy

Order the result set using the defined attribute.