Using advanced grid filters

Filtering records is a common way to further refine the list of records in the grid after we have ran a query. AppGrid provides two ways to filter records, using column filters and using our advanced filter builder.

When using column filters, the grid will logically AND the results if more than one column filter has been defined. Often, that is what we need and so we are good.

However, sometimes we want to create a more flexible and powerful way to define multi-column filters. That is where the AppGrid advanced filter functionality comes to play. AppGrid allows you to create advanced filters that contain AND/OR logic and where filter conditions can be grouped together.

To apply an advanced filter, select it from the filter selector. Notice that the filter indicator in the grid toolbar will turn orange, indicating that an advanced filter has been applied. You can also look in the grid status row to see the number of records that are filtered. AppGrid will also display the filter expression just below the column names. You can edit the expression or click the Builder button to edit the expression graphically.

Using the filter builder allows creating the filter expression graphically. Notice that you can add a filter expression or a group, which allows creation of advanced filter logic.

When you are done, click the Apply button. The grid will apply the filter expression.

To save the filter, click the Save Filter button in the grid toolbar and provide a name. The new filter will now be available in the advanced filter selector.

To clear an applied filter, click the Clear Filter button in the grid toolbar.

To delete a saved filter, click the Delete Filter button in the grid toolbar.