Filter

If your database is large, unfiltered data can produce long reports that are not easy to read. The method of filtering data here is very simple:

  • Drag and drop a data field you want to use as a filter from the data field list into the filter view.
  • Adjust field specific settings accordingly.

Every data field type has a set of comparison elements, e.g. "equals", "greater than", "less than" ... By selecting an comparison element, the interface changes accordingly to reflect the input value that may be needed to create a valid filter. The comparison elements are based upon mathematical comparison methods - with an descriptive icon and text.

You can add as many data fields to filter on as you want. Different data fields will be connected by an AND, multiple same elements will be connected by OR. e.g:

  • you add the following fields: number1=10, number2=20, string3="a", string4="b"
    • results in: (number1=10 AND number2=20 AND string3="a" AND string4=="b")
  • you add the following fields: number1=10, number1=20, string4="a", string4="b"
    • results in: ( (number1=10 OR number1=20) AND (string4="a" OR string4="b") )