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

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

Asc

Ascending order

None

Desc

Descending order

None

Between

Subset of data between value 1 and value 2.

Database attribute

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

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

Database attribute

String

None

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

Database attribute

String

None

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

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

IsNotNull

Select data where the defined attribute is not null.

Database attribute

None

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

Database attribute

String

None

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

Database attribute

String

None

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

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

Database attribute

String

None

Not

Unknown difference between Ne.

None

OrderBy

Order the result set using the defined attribute.

Database attribute

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.