Database Exchange > Runtime interface > Filtering data

Filtering data

Filtering the data enables you to extract particular pieces of information.

To filter the data:

  1. Select an active cell within the column you would like the filter to be applied to. If you do not select a cell, the filtering will be applied to the first column by default.
  2. Click the Filter button.
  3. Select the Operator radio button corresponding to the condition you want to filter by e.g. = (equals), < (less than), >= (greater than or equal to)
  4. In the Value field, type the value you are filtering for.
  5. Click OK to apply the filter and close the dialog (or Cancel to close the dialog without filtering).
  6. Only the rows satisfying the entered filter parameters should now display in the table.
  7. Once a filter has been applied, you can reload the original source table by clicking on the Filter button again and selecting Clear. If an applied filter didn't call up any matching entries, you can repopulate the original table by simply clicking on the Filter button.

NOTE: When selecting a column to be filtered, do not use the column heading field. The column headings are used to sort a table in ascending or descending order, they cannot be used to select active cells.