AVEVA™ Contract Risk Management - Company Portal

Filter operators for personal and standard views

Save PDF

Filter operators for personal and standard views

Save PDF

Last UpdatedDec 27, 2023
2 minute read

Filter operator types

Operator	Column data type	Definition
Begins With	Text	Returns data that begins with the text entered in the Value field.
Contains	Text	Returns data that contains the text entered in the Value field.
Ends With	Text	Returns data that ends with the text entered in the Value field.
Is Equal To	Numeric / Text	Returns data that matches the value entered in the Value field.
Is Not Equal To	Numeric / Text	Returns data that does NOT match the value entered in the Value field.
Is Greater Than	Numeric / Text	Returns numeric data that is greater than the value entered in the Value field. Returns dates later than the date entered in the Value field.
Is Greater Than or Equal To	Numeric / Text	Returns numeric data that is greater than or matches the value entered in the Value field. Returns dates later than or on the same date as that entered in the Value field.
Is Less Than	Numeric / Text	Returns numeric data that is less than the value entered in the Value field. Returns dates prior to the date entered in the Value field.
Is Less than or Equal to	Numeric / Text	Returns numeric data that is less than or matches the value entered in the Value field. Returns dates prior to or on the same date as that entered in the Value field.
(Is Equal To) Actual Date	Date	Returns data with dates that match the date entered in the Value field.
(Is Equal To) Date Range	Date	Select a date range option from the Value drop-down list to return dates within the selected range.
(Is Not Equal To) Actual Date	Date	Returns dates excluding the date entered in the Value field.
(Is Not Equal To) Date Range	Date	Select a date range option from the Value drop-down list to return dates outside of the selected range.

Filter operators example

Column label	Operator	Value
Budget	Is Greater Than	1,000,000

This view will display all contracts with budgets greater than $1,000,000.

Multiple filter conditions

You can sort data on multiple conditions by adding filters.

Select AND or OR to display another filter:

AND - display results if both conditions are true

OR - display results if either condition is true

Multiple filter conditions example

Column label	Operator	Value
Budget	Is Greater Than	1,000,000
Budget	Is Less Than	1,500,000

This view will display all contracts with budgets of between $1,000,000 and $1,500,000.

Filter groups

You can add another filter group to further refine your data.

Click Add Group to display a second filter group.

Filter groups example

Column label	Operator	Value
Filter Group 1
Budget	Is Greater Than	1,000,000
Budget	Is Less Than	1,500,000
Filter Group 2
Contract Approvers	Begins With	B

This view will display all contracts with budgets of between $1,000,000 and $1,500,000 AND have contract approvers whose names begin with the letter B.

AVEVA™ Contract Risk Management - Company Portal