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.

Did this answer your question?