Build queries

A query is a search used to find information stored in IRIS Cascade.

1. Go to HR.

2. From the Advanced section of the menu, select Query Builder.
   

3. The Query Builder screen displays, select New Query.
   
   

4. Employee ID, First Name and Surname are selected by default.

5. Use the drop-down menu of available screens and associated fields in the navigation menu to add fields to the query:

   • From the drop-down menu, select the appropriate screen. For example, if you want to include First Name, Surname, Current Job and Current Salary in the query, select First Name and Surname on the Main screen and Current Job and Salary on the Job & Salary screen. The fields available on the selected screen are listed in the menu below its name.

   • To add a field to the Query Builder screen, select its name in the list.

6. If you need to remove any fields that have been added incorrectly, click the trash icon.

7. When you are happy with your criteria, select Run Query.

Related topics:

• Add criteria to query fields
• Create charts from queries
• Refine query criteria
• Save and publish queries and groups
• Sort, move or hide result columns