Advanced Filter is a powerful filter for data views that allows you to see only what you want to see, reducing the number of records and making your views faster. When you apply the advanced filter to a view, Alloy Navigator Express refers to the database and retrieves only data that matches the filtering criteria.
You can create and apply the advanced filters as follows:
Advanced Filter: Design Mode- design a filter by using the intuitive, easy-to-use graphical Filter Builder
Advanced Filter: SQL mode - directly specify a SQL WHERE clause to create a filter, then apply the filter. Using the SQL mode requires some knowledge of SQL.
(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.