Column Filters

Filtering enables Lucity users to quickly extract certain records from a grid. Unlike sorting, filtering doesn't just reorder the records; it actually hides the rows or columns containing data that do not meet the filter criteria the user defines.

A filter button appears in every column header to allow users to filter the data in the grid based on that column. Users may filter the grid on multiple columns at the same time to quickly filter records, rather than using the more robust Filter Builder.

locate tool

 

How To Use the Column Filter Function

  1. Select a column to filter.
  2. Click on the column's filter button. The following pop-up appears:

    filter_column

  3. Click the drop-down and select the desired filter option.

    browse dialog

  4. A box appears below the filter option. Enter the criteria to filter on in that box and click Apply. The tool displays only the records that match the criteria for that filter AND all other filters set for other columns.
  5. After a filter criteria is defined for a column, the filter icon remains visible in that column. Hover the mouse over the icon to display the current settings.

    Note: Select the Save My Customizations tool save custom to save any filters.