Skip to content

Add/Edit Filter

When you add or edit filters, you see the following information:

Column

This control lists all the columns of the current table. The current table is either the main table for the data view or the table selected in the tree view in the upper half of this tab page. You can create filters for the main or parent tables. The names of the columns are, by default, sorted in alphabetical order. You can change this via a configuration setting.

Mode

This control lists the possible compare modes for the filters. They are:

  • EQ
  • NE
  • GT
  • LT
  • GE
  • LE
  • Contains
  • Matches

The option Matches supports the use of the usual wildcard characters (* and ?).

Value

This control can be used to enter the value to compare to. Make sure that you enter a correct type value.

The value can also be a reference to a table.column in the same table. With this, you can make a filter based on the value in another column. For example:

customer.purchases eq customer.credit_limit