When you apply the advanced filter to a selected view,
You can create and apply the advanced filters as follows:
Design the filter by using the specially provided graphical filter builder, then apply the filter.
Directly specify the SQL WHERE clause for filtering the data, then apply the filter (recommended for advanced SQL users only).
(Filter Applied)' ending displayed both on the tab above the grid and in the status bar (for details, see Menus and Toolbars).
NOTE: If you have limited the number of records to retrieve (for details, see Applying advanced preferences: Limiting the number of records to retrieve), it is recommended that you use the Advanced Filter.