Criteria Builder
The criteria builder is a generic component used to filter dashlet information in an operator board. Some dashlets use this component in certain situations to filter displayed information.
You can combine multiple criteria to display a subset of information in a given dashlet.
Configuration options
Restriction | Description | Value 1 | Value 2 |
---|---|---|---|
Generic attributes |
|||
Asc |
Ascending order |
None |
None |
Desc |
Descending order |
None |
None |
Not |
Unknown difference between |
None |
None |
Database attributes |
|||
Between |
Subset of data between value 1 and value 2. |
String |
String |
Contains |
A text string to compare against a database attribute. Any data containing the defined text string is selected. |
String |
None |
Distinct |
Select a single instance. |
None |
None |
Eq |
Select data where the defined attribute equals ( |
String |
None |
Ge |
Select data where the defined attribute is greater than or equal to ( |
String |
None |
Gt |
Select data where the defined attribute is greater than ( |
String |
None |
Ilike |
Select data where the defined attribute is like a given text value.
This option is similar to the SQL |
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. |
String |
Comma-separated list of strings |
Iplike |
Select data where the defined attribute matches a given |
String |
None |
IsNull |
Select data where the defined attribute is |
None |
None |
IsNotNull |
Select data where the defined attribute is not |
None |
None |
Le |
Select data where the defined attribute is less than or equal to ( |
String |
None |
Lt |
Select data where the defined attribute is less than ( |
String |
None |
Like |
Select data where the defined attribute is like a given text value.
This option is similar to the SQL |
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 ( |
String |
None |
OrderBy |
Order the result set using the defined attribute. |
For date values, you can specify an absolute value using ISO formatting (for example, 2019-06-20T20:45:15.123-05:00 ).
Specify relative times using +seconds and -seconds .
|