Specifying operators for filter conditions

When defining simple or complex conditions within the Filter Builder, you use operators to define comparisons.

About this task

The list of available operators includes:
  • Equal To
  • Not Equal To
  • Greater Than
  • Less Than
  • Greater Than Or Equal To
  • Less Than Or Equal To
  • Like
  • Not Like
  • In
  • Not In

All of these operators, apart from In and Not In, are used to make a comparison to a single value.

The Like and Not Like operators accept regular expressions if required, and perform a substring comparison.