1. Advanced filters

fmPreferences - Advanced Filters Management

Advanced filters are column filters that can be applied to basically any column of the current page (table). It allows you to show and hide rows (filter) based on cell content.

Data filtration can be executed in any table on the base of filter factors. Required factors are specified in the column title drop-down.

If you select Custom option filter window will appear. It creates a filter statement that will be applied. You can choose this option even if some filter is already established. In this case you'll see this filter's stricture.

There are several values for the data filtration you can select, all listed in a column title droop-down with the check-boxes. Filtration is applied as soon as you mark a box.

If filter for any column is established, then it will be reflected in a special panel that appears at the bottom of the page.

There is a check-box that allows you to disable current filtration, thus show all products. However it does not close Advanced Filter panel.

If you press

it will do both: cancel filtration and close panel.

If you click on Customize button you'll see Filter Builder form with current filter structure. You can make any changes here: add, edit or remove filter parameters.