Specify the filter criteria

Basic procedure

  1. Select an operator (AND / OR).
  2. Select a property from the list.
    The properties that are available are the properties of the type that has been set as visible in the Preferences panel.
  3. Select one of the available operators.
    The data type influences the set of operators that apply to the field. If you select another property, the set of operators is updated according to the new type.
  4. Operators String data format Others
    = X X
    < X X
    X X
    > X X
    X X
    like X  
    contains X  
    is null X X
    is not null X X
  5. Specify a value using either of the following:
    • Enter a value.
    • In the Results panel, select a cell and drag-and-drop the value into the field.
  6. Click:
    • Add to display a new condition and repeat steps 2 to 4 as many times as necessary.
    • to remove the current condition.
      When there is only one condition left, this action only reinitializes the fields of the condition block.
  7. Click Apply.
    If conditions are:
    • valid, the selected lines are displayed in the Results panel.
    • not valid, the field is focused and an error message is displayed in a tool tip when clicking on the field.
    If no conditions were specified, the Filter panel is closed.

Advanced procedure

  1. Select an operator (AND / OR).
  2. Drag-and-drop a cell from the Results panel.
    A condition block is displayed in the Filter panel with Property Name, Operator (set to "=") and Value.
  3. Modify fields as required.
  4. Repeat steps 2 and 3 as many times as necessary.
  5. Click to remove the current condition.
    When there is only one condition left, this action only reinitializes the fields of the condition block.
  6. Click Apply.
    If conditions are:
    • valid, the selected lines are displayed in the Results panel.
    • not valid, the field is focused and an error message is displayed in a tool tip when clicking on the field.
  7. If no conditions were specified, the Filter panel is closed.

Related Links