In this topic you learn how to add a group of criteria to the query in order to limit the query results to a list of specified values.
In this example the query will display the employees whose highest education levels are Bachelor’s Degree, Some Graduate School and Master Level Degree. To do this you will use the "in list" Condition Type.
Note: When changing the criteria of a field that has already been added to the Criteria tab, do not return to the Fields tab to add the field to the Criteria tab again. Doing so will cause an error in your search results.
Instead, edit the field that already appears in the Criteria tab by clicking the Edit button.
Click the Edit button for Highest Education Level.
Click the drop-down arrow for *Condition Type and select the in list option.
Note: The "in list" Condition Type finds data having a value that matches any one of the values in a specified list of values.
Click the Add Value button for G-Bachelor's Level Degree.
Click the Add Value button for H-Some Graduate School.
Note: To delete a value, check the box that appears in front of the value that you wish to delete under List Members and click the Delete Checked Values button.
Click the Add Value button I-Master's Level Degree.
Note: The Criteria tab now indicates HIGHEST_EDUC_LVL with the values of G, H and I.
Note: The query results are limited to employees whose highest education level is Bachelor’s Degree, Some Graduate School and Master Level Degree.
This completes Add a Group of Criteria Using In List.
Click the drop-down arrow for *Condition Type and select the in list option.
Note: The "in list" Condition Type finds data having a value that matches any one of the values in a specified list of values.