This topic lists describes the supported data and time period filters.
The filter types listed in the following tables are available for defining KPIs and for customizing instances and human tasks.
Filter type | Explanation |
---|---|
Numerical | Create a filter that has a numerical value (counter,
decimal, stopwatch, or integer) such as cost, credit amount, or number
of employees. Select the numeric value range by using one of these
logical operators: equals, lessThan, lessThanOrEquals, greaterThan,
greaterThanOrEquals, notEquals, In, notIn, isNull, isNotNull; then
enter the required value. For example, Credit amount
equals 1000. Note: To include all instances that have
"timeMetric" equal to the time value when filtering instances on the
dashboard, avoid equals, notEquals, In, and notIn operators. Use a
range query instead.
For example, if you want to query for all
instances with time metric value equal to "13:40:25", use the following
filters:
"timeMetric" "greaterThan" "13:40:25" AND "timeMetric" "lessThan" "13:40:26" The timestamp stored in the database is the exact time that an event happened with a precision of 1 millisecond. However in the dashboard, the millisecond portion of the timestamp is not displayed. The instance filters do not allow millisecond portion of a timestamp. As a result, the time filters and the actual values in the database do not always match with the exception when the timestamp in the database has "000" as the millisecond portion. |
Duration | Create a filter that has a time-duration value (days, hours, minutes, or seconds), such as elapsed time duration, working time duration, or process-cycle time duration. Select the duration range by using one of these logical operators: equals, lessThan, lessThanOrEquals, greaterThan, greaterThanOrEquals, notEquals, In, notIn, isNull, isNotNull; then enter the required duration values. For example, aWorking time duration greaterThanOrEquals 0d 8h 0m 0s. |
Boolean | Filter by a business measure that has a Boolean value (true or false), such as credit approved, vacation balance full, or order completed. Select one of the following operators: equals, notEquals, isNull, isNotNull; Select the required value for the business measure, either True or False. For example, Credit Approved equals True. |
String | Filter by a business measure that has a text value, such as first name, last name, address, or state. Select one of the following operators: equals, lessThan, lessThanOrEquals, greaterThan, greaterThanOrEquals, notEquals, In, notIn, isNull, isNotNull, like, notLike; then type the required text. % can be used with the like operator, as a wildcard. For example, Customer name equals John or Order state equals Completed or . |
Time period | Explanation |
---|---|
Sliding | Create a filter that uses a sliding interval to view data over a period of years, months, days, hours, minutes, that moves continuously. For example, if you set the sliding interval for two months, you will see the data of the metric from two months ago up to the current time. Your current time is based on your time stamp and not from midnight to midnight. |
Last completed period or Current period | Create a filter that uses a repeating time period to view data of a specific length, which can be a year, a quarter, a month, or a day. You must also select whether to evaluate data for the last completed full period or for the period in progress. If you set the repeating period to monthly and you select the last full period, then the metric will always show the value based on the last complete month. For example, if you are in March, the last complete month was February. When April starts, the metric is no longer based on the data from February but is based on the data from March. At all times, the metric is evaluated based on a full month of data. Alternatively, if you select the period in progress, the metric is evaluated based on the current month. If you are in March, the metric is evaluated based on the March data so far. When April starts, the metric is no longer based on the data from March but on the April data. |
Fixed | Create a filter that uses a fixed time period to view data of a single time period. You specify a start date and an end date, such as January 1, 2007 to January 31, 2007. |