Criteria Builder

The Criteria Builder is a generic component to filter dashlet information. Some dashlets use this component in certain use cases 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

-

-

-

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

-

-

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