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.
How To Use the Column Filter Function
Select a column to filter.
Click on the column's Filter button. The following pop-up appears:
Click the drop-down and select the desired filter operator.
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.
After a filter criteria is defined for a column, its filter icon is highlighted in orange. Click the orange filter icon to display the current filter settings.
