Advanced Filter Editor

Users should have a working knowledge of SQL (Structured Query Language) before attempting to use Advanced filters. For most users, the Build A Filter is sufficient.

Select a Basic filter from the filter list.
Click the Edit button.
In the Filter Builder, click the Advanced button. The following warning appears:
Click Continue. The Advanced Filter Editor opens.
Modify the filter as needed.
Click Save As. The following pop-up appears:
Enter a name for the filter.
Click Save.

Enter a SQL statement into the text box, starting with the table from which to select records. The statement will always include Select * from at the beginning.
- Use the Select Table Name drop-down to select a table related to the desired module.
- Use the Select Column Name drop-down to select a field from that table. Doing so will insert tablename.fieldname into the SQL statement.
- Use the Select Reserved Word drop-down to insert a reserved word into the SQL statement.
To save the filter, click Save As.
Note: Filters saved from the Advanced tab will be saved as Advanced filters. Advanced filters cannot be edited using the Basic Filter Builder.
To immediately run the filter, click Run.

Count	Displays the number of records found by the filter currently being created/edited.
Save As	Stores the filter for future use while setting the name of the filter.
Run	Executes the filter.