Filter Operator Types

Includes any record that has a value that matches the specified filter values.

Includes any record with a value within a specified hierarchical global values list value. This operator considers the entire hierarchy below the value specified as a match.

For example, if using a values list for Location that has 3 levels (Country > State/Province > City) and you want to find all records in Missouri, Contains Inclusive United States > Missouri returns the following results:

• United States, Missouri
• United States, Missouri, Kansas City
• United States, Missouri, St. Louis
• United States, Missouri, Columbia

Includes any record that does not have a value that matches the specified filter values.

Includes any record that does not have a value within a specified hierarchical global values list value, and also excludes the entire hierarchy below the value specified.

For example, Does Not Contain Inclusive United States > Missouri returns any selection at the Country, State, City level not under Missouri.

Includes records with values that exactly match to the specified filter values. For Date fields, date and time values can be included in the filter.

Includes only the records with values that do not match the specified filter values. For Date fields, date and time values can be included in the filter.

Includes only records of the current interval. Available intervals include:

• Minutes
• Hours
• Days
• Months
• Quarters
• Years

Includes records based on the selected interval previous to the current interval. Available intervals include:

• Minutes
• Hours
• Days
• Months
• Quarters
• Years

This filter does not include records of the current interval. For example, if you filter "Last" "3" "Days", the results include the previous 3 days, but do not include the current day. To include the current day, add another filter condition to the search criteria that includes the "Current" "Day".

Includes records based on the selected interval after the current interval. Available intervals include:

• Minutes
• Hours
• Days
• Months
• Quarters
• Years

This filter does not include records of the current interval. For example, if you filter "Next" "3" "Days", the results include the next 3 days, but do not include the current day. To include the current day, add another filter condition to the search criteria that includes the "Current" "Day".

Includes only records with values greater than the specified static filter value. For example, when the Field to Evaluate is a date, and the Operator is Greater Than, the Value is a specific calendar date.

For Date fields, date and time values can be included in the filter.

Includes only records with values less than the specified static filter value. For Date fields, date and time values can be included in the filter.

Includes only records with values within the specified date range, or date and time range, including the date and time selected.

Includes only records with values within the specified time range. Dates can also be specified to further filter the search. Search results include the selected times and dates.

Includes records of all dates after the current day, but does not include the current day.

Includes records of all dates before the current day, but does not include the current day.

Includes only records with values greater than the specified dynamic field value.

For example, when the Field to Evaluate is a date, and the Operator is Field Value Greater Than, the Value is a specific field in the record, such as Last Self-Assessment Date.

Includes records with values less than the specified dynamic field value.

For example, when the Field to Evaluate is a date, and the Operator is Field Value Less Than, the Value is a specific field in the record, such as Next Self-Assessment Date.

Includes records in a range defined by 2 specified field values.

For example, if the Field to Evaluate is Annual Loss Expectancy, the Field Value Between operator allows you to choose a range between 2 values.

Note: Specified field values must be the same type, for example, date to date or integer to integer.

Includes records that match the specified field value in the current record.

For example, if the Field to Evaluate is a location, the Field Value Match operator allows you to return only results that match 1 of a list of specific locations.

Includes records that do not match the specified field value in the current record.

For example, if the Field to Evaluate is a location, the Field Value Does Not Match operator allows you to return results that exclude 1 of a list of specific locations.

Includes records where any of the values in the Field to Evaluate are also selected in the Value field(s).

For example, if the fields on both sides of the operator are values list fields using a category list, the report returns any records where the Category field of the related application (Field To Evaluate) contains at least 1 of the values specified in the Value field of the current record.

Includes records where any of the values in the Field to Evaluate are not also selected in the Value field(s).

For example, if the fields on both sides of the operator are values list fields using a Risk Category list, the report returns any records where the Category field of the related application (Field To Evaluate) does not contain any the values specified in the Value field of the current record.

Includes any record with a value within a specified hierarchical values list that is found within the current record. This operator allows you to consider the entire hierarchy below the value specified as a match.

Includes any record that does not have a value within a specified hierarchical values list that is found within the current record and also excludes the entire hierarchy below the value specified.

For Filter By Record ID - Filter By Record ID is applied against the current record displaying the report object.

For Cross-reference or Related Record, the filter only returns records where the cross-reference or related record field's only selection is the current record displaying the report object.

For example, use this filter to create a report that shows all Risk By Risk Category for each business process where its parent Business Unit is the current Business Unit being viewed.

Includes any record with values that do not equal a specified value found in the current record.

For example, use this filter to create a report that shows all Risks By Risk Category for each Business Process that also shows a breakdown for all other Business Units other than the current Business Unit viewed.

Includes records that have at least the current record selected in the specified reference field or are filtered by record ID.

Includes records that do not have at least the current record selected in the specified reference field or are filtered by record ID.

Includes records that match a specified level of a hierarchical values list. The number of operators available is based on the number of levels in the list.

For example, if you use a values list for Location that has 3 levels (Country, State/Province, City) and you want to find all records in Missouri even when a city within Missouri is selected, Field Value Contains Depth 2 returns records with the following selections:

• United States, Missouri
• United States, Missouri, Kansas City
• United States, Missouri, St. Louis
• United Stated, Missouri, Columbia