Working with filters
Filters allow users to have advanced control over data display. The filters button brings a filters page as shown below.
For example, if we wish to find all customers from France, Germany or Mexico, whose contact names begin with A, M or P, the filters would look like this:
If a filter begins with 'And' it means the condition must be fulfilled, and if it begins with 'Or' then the condition is optional. You can use % (percentage sign) and _ (underscore) in comparison values when the comparison operator is 'Like' or 'Not Like'. % means any number of characters and _ means any single character.
There are several comparison operators available for filters, the following figure shows them all.
To apply filters to the table view after specifying them, simply click the "APPLY FILTERS" button.