Criteria Builder

Asc

Ascending order

-

-

-

Desc

Descending order

-

-

-

Between

Subset of data between value 1 and value 2.

Database attribute

String

String

Contains

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

Database attribute

String

-

Distinct

Select a single instance.

Database attribute

-

-

Eq

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

Database attribute

String

-

Ge

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

Database attribute

String

-

Gt

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

Database attribute

String

-

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.

Database attribute

String

String

In

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

Database attribute

String

Comma-separated list of strings

Iplike

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

Database attribute

String

-

IsNull

Select data where the defined attribute is null.

Database attribute

-

-

IsNotNull

Select data where the defined attribute is not null.

Database attribute

-

-

Le

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

Database attribute

String

-

Lt

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

Database attribute

String

-

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

-

Limit

Limit the result set to a given number.

-

Integer

-

Ne

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

Database attribute

String

-

Not

Unknown difference between Ne.

-

-

-

OrderBy

Order the result set using the defined attribute.

Database attribute

-

-