Criteria Builder

The Criteria Builder is a generic component to filter information of a dashlet. Some dashlets use this component to filter the shown information on a dashlet for certain use case. It is possible to combine multiple Criteria to display just a subset of information in a given dashlet.

Table 1. Generic Criteria Builder configuration possibilities
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

Select all data which contains a given text string in a given database attribute.

database attribute

String

-

Distinct

Select a single instance.

database attribute

-

-

Eq

database attribute

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

String

-

Ge

Select data where attribute is greater equals than (>=) a given text value.

database attribute

String

-

Gt

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

database attribute

String

-

Ilike

unknown

database attribute

String

-

In

unknown

database attribute

String

-

Iplike

Select data where attribute matches an given IPLIKE expression.

database attribute

String

-

IsNull

Select data where attribute is null

database attribute

-

-

IsNotNull

Select data where attribute is not null.

database attribute

-

-

IsNotNull

Select data where attribute is not null.

database attribute

-

-

Le

Select data where attribute is less equals than (⇐) a given text value.

database attribute

String

-

Lt

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

database attribute

String

-

Le

Select data where attribute is less equals than (⇐) a given text value.

database attribute

String

-

Like

Select data where attribute is like a given text value similar to SQL like.

database attribute

String

-

Limit

Limit the result set by a given number

-

Integer

-

Ne

Select data where attribute is not equals (!=) a given text value

database attribute

String

-

Not

Unknown difference between Ne

database attribute

String

-

OrderBy

Order the result set by a given attribute.

database attribute

-

-
For date values, absolute value can be specified in ISO format, e.g., 2019-06-20T20:45:15.123-05:00. Relative times can be specified by +seconds and -seconds.