Filter Builder Operators
An Operator is a Filter Builder component that determines how a collection of Records is displayed as the result of an applied filter. Typical Operators include ‘And’ and ‘Or’.
For example:
…where ‘Status’ Equals [Active] AND ‘Record Type’ Equals Risk
In the Filter Builder, the above example is structured like this:
And Status Equals [Active] Record Type Equals [Risk]
Available Operators
And Status Equals [Active] Record Type Equals [Risk]
‘And’ returns only Records that are both ‘Active’ Status and ‘Risk’ Record Type.
Or Status Equals [Active] Record Type Equals [Risk]
‘Or’ returns Records that:
are both ‘Active’ Status and ‘Risk’ Record Type, and
either ‘Active’ Status or ‘Risk’ Record Type.
Not And Status Equals [Active] Record Type Equals [Risk]
‘Not And’ returns those Records that:
are either ‘Active’ Status or ‘Risk’ Record Type (but not both), and
neither ‘Active’ Status nor ‘Risk’ Record Type.
Not Or Status Equals [Active] Record Type Equals [Risk]
‘Not Or’ returns only those Records that are neither ‘Active’ Status nor ‘Risk’ Record Type.