The available filter operators are different depending on the data type of the field. You can filter any field using the Empty or Not Empty operation. These filter records based on whether the field contains a value.
The following sections contain more information on the other available operators for each data type.
Alphanumeric (string entry in a text box)
The following operators are available for alphanumeric fields that are a string entry in a text box such as Account Number or Badge:
- Contains
- Does Not Contain
- Starts With
- Ends With
Alphanumeric (selection from a list)
The following operators are available for alphanumeric fields that involve selection from a list such as Department or Employee:
- Equal To
- Not Equal To
- Includes
- Excludes
- In
- Not In
Date/Time
With date/time fields, earlier dates are considered “less than” the specified date, and later dates are considered “greater than” the specified date. The following operators are available for date/time fields such as Hire Date or Business Date:
- Equal To
- Not Equal To
- Greater Than
- Great Than or Equal To
- Less Than or Equal To
- Within
Some topics support filtering on relative date values for past and future dates. A relative date value is a date or a date range that is relative to the day the report is being run, such as Yesterday, Last Complete Week, Next N Complete Days Including Today.
Note: For topic-level parameters, relative dates are only available for some topics. If the report you’re configuring is based on a relative date topic, choose WITHIN in the Operator column, and then select one of the relative dates. Alternatively, select BETWEEN to enter a from and to date, and AS OF DATE to enter a specific date as of which to generate records.
You can select the following relative date values along with the WITHIN operator:
- Today
- Yesterday
- Last 30 Days Including Today
- Last 60 Days Including Today
- Last 90 Days Including Today
- This Calendar Week
- Last Complete Calendar Week
- This Calendar Month
- Last Complete Calendar Month
- Calendar Month to Date
- This Calendar Quarter
- Last Complete Calendar Quarter
- Calendar Quarter to Date
- This Calendar Year
- Last Complete Calendar Year
- Calendar Year to Date
- Last N Days Including Today
- Last N Complete Weeks
- Last N Complete Months
- Last N Complete Quarters
- Last N Complete Years
- This Fiscal Week
- Last Complete Fiscal Week
- This Fiscal Month
- Last Complete Fiscal Month
- Fiscal Month to Date
- This Fiscal Quarter
- Last Complete Fiscal Quarter
- Fiscal Quarter to Date
- This Fiscal Year
- Last Complete Fiscal Year
- Fiscal Year to Date
You can select the following future relative date values along with the WITHIN operator:
- Tomorrow
- Next 30 Days Including Today
- Next 60 Days Including Today
- Next 90 Days Including Today
- Next Complete Calendar Week
- Next Complete Calendar Month
- Next Complete Calendar Quarter
- Next Complete Calendar Year
- Next N Complete Days Including Today
- Next N Complete Weeks
- Next N Complete Months
- Next N Complete Quarters
- Next N Complete Years
- Next Complete Fiscal Week
- Next Complete Fiscal Month
- Next Complete Fiscal Quarter
- Next Complete Fiscal Year
Numeric
The following operators are available for numeric fields such as Rate or Hours:
- Equal To
- Not Equal To
- Greater Than
- Less Than
- Greater Than or Equal To
- Between
- Not Between
Boolean
The following operators are available for Boolean (yes/no or true/false) fields such as Is Primary:
- Equal To
- Not Equal To
For Boolean filters, specify True to filter on checkboxes that are selected, or False to filter on checkboxes that are cleared.