Criteria Builder

The Criteria Builder is a generic component used to filter dashlet information. Some dashlets use this component in certain situations to filter the displayed information. It is possible to combine multiple criteria to display a subset of information in a given dashlet.

Configuration options

Restriction Description Property Value 1 Value 2

Asc

Ascending order

None

None

None

Desc

Descending order

None

None

None

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

None

Distinct

Select a single instance.

Database attribute

None

None

Eq

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

Database attribute

String

None

Ge

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

Database attribute

String

None

Gt

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

Database attribute

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.

Database attribute

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.

Database attribute

String

Comma-separated list of strings

Iplike

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

Database attribute

String

None

IsNull

Select data where the defined attribute is null.

Database attribute

None

None

IsNotNull

Select data where the defined attribute is not null.

Database attribute

None

None

Le

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

Database attribute

String

None

Lt

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

Database attribute

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.

Database attribute

String

None

Not

Unknown difference between Ne.

None

None

None

OrderBy

Order the result set using the defined attribute.

Database attribute

None

None

For date values, you can specify absolute value using ISO formatting (2019-06-20T20:45:15.123-05:00). Specify relative times by +seconds and -seconds.