To add filters (selection criteria) to a query:

1. Start the iQ tool and log in (if necessary). (See Starting the iQ Tool.)
2. Select the query you want to add the column to in the 'Your Queries' folder. That query's parameters will be displayed in the Current Query data group. *If the query is in the 'Queries shared with you' folder, it was created someone else and you must first make a copy of it in your Personal Queries folder before you can alter it. See Copying and Altering a Preexisting iQ for instructions on how to do this.
3. Locate the 'Find' section.
4. Click the add button above the grid of the Find section. The Select Query Path window will appear.
5. Find the field your filter is to be based on among the folders and fields displayed in the Properties data tree. You may have to open several folders and subfolders to find the field you are looking for. While you are doing this, a path to the field listing each of the folders and subfolders will be constructed in the Query Path data area. (See The Application Data Structure.)
6. Once you have found the field you want, click on it.

7. Select a comparison type from the Compare drop-down field in the Match to Value data group that describes how values in the field should be compared with the value(s) you enter as a test for each record's inclusion in the query. (See Ways of Comparing Data in the iQ Tool for an explanation of the options available in the Compare drop-down field.

   

8. Enter a value (or values if applicable) in the Value field(s) in the Match to Value data group to which the data in the specified field for each record is to be compared for inclusion in the query.
9. Click the Save button to add the filter to the query criteria list.
10. Add any other filters you want to apply to the query by repeating steps 4 through 9.
11. When you have added all of the filters you need, click on the Close button. Clicking on the Close button will not add any filters to the query. Make sure that you have clicked the Add button for all filters you want to apply before clicking Close.
12. If you are using more than one filter, select the appropriate relationship between the filters by selecting 'All' or 'Any' above the grid.