Expressions in Criteria condition

Edit online

Use the Criteria condition section to define a set of expressions that are joined by And or Or operators.

You have two options to create expressions. You can use either the editor, or an SQL segment. The expression, which is written in SQL language, is seen on the Advanced condition tab. Knowledge of the database structure or SQL language is not needed to be able to explore the data featured in this tool.

How to create an expression

To create an expression:

  1. Click the Add button icon to add a criteria condition. By selecting Add group tab icon a group of criteria condition is added. This acts as a bracketed set of expressions.
  2. Use And or Or operator to join the criteria condition line. The And and Or operator can be edited by clicking the drop down arrows on the And or Or toggle.
  3. Use a list of comparison operators to compare values and other fields which you can use in criteria condition.
  4. Use the Delete tab icon to remove criteria lines which are no longer required.
  5. Disable the editing to convert the expression into natural language.
  6. Click the Edit toggle to delete or edit the lines.

Extra details for the Advanced filter tab

If you have permission, the expression can be edited to use other operands that are not available in the criteria condition section. For example, this action includes mathematical calculations between fields and the use of date functions.

Note: Some conditions cannot be translated into basic filter function. When condition cannot be converted, the message Condition is either empty or cannot be converted to a filter displays on the basic criteria condition page. Select the Advanced option to view.