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 Build A Filter.

locate tool

 

How To Use the Column Filter Function

  1. Select a Column's Filter filter. The following pop-up appears:

    filter_column

  2. Click the drop-down and select the desired filter operator. The default is Contains.
  3. Depending on your filter operator choice, another field may appear. 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.
  4. After a filter criteria is defined for a column, its filter icon is highlighted in orange. Click the filter icon to display the current filter settings.