Creating an iQ query has several parts. The entire process will be presented here and then certain parts which require clarification will be explained more completely hereafter in their own sections. These instructions show how to create a query from scratch. If you would like to base your query on a preexisting query to save time see Copying and Altering a Preexisting IQ. To create an iQ:

1. Start the iQ tool and log in if necessary. (See Starting the iQ Tool.)

2. Click the add button in the 'Manage your saved queries' data group to add your new query to 'Your Queries' folder. The 'What would you like to query' window will open.

3. Click the appropriate to circles to select what the query will be about. The 'Crete Query' window will open. Name your query and click 'OK'.

4. Your query is added to the 'Your Queries' folder and it is selected. (It appears in the current queries window with no columns or filters selected yet.)*To close the Add Query window without adding a query to the Personal Queries folder, click the Cancel button.

5. Add the columns you want to appear in your query to the list and place them in the order you want them to appear from left to right on the 'Display' section. (See Adding Columns to a Query and Changing the Order of Columns in a Query.) *If any of the columns selected on the 'Display' section contain restricted information, the only information that will be displayed in the column when the query is run will be for those records for which you have the proper permissions for viewing this restricted information. Records included in the query which have information in these columns but for which you do not have the necessary permissions will show only the word (restricted) in place of the restricted data. The words Restricted report — data omitted from the report will also appear in red at the bottom of the iQ Results window.

6. Add filters to the query in the 'Find' section to specify which records are to be included in the query to the list that appears there. (See Adding Filters to a Query.)*If any of the fields included on the Filters tab contain restricted information, the records included in the query will be limited to only those records for which the user has the appropriate permissions to access this information. Records which normally might have been included in the query but for which you do not have the necessary permissions will not show up. The words Restricted search — rows excluded from report will also appear in red at the bottom of the iQ Results window.

7. If you want to share your query with others, check the 'Public?' option. *It is suggested that not too many similar queries are shared, since this could make it difficult to find the query you want in the 'Queries Shared with you' folder, but if your query is different enough from other shared queries, it could be useful to someone else using the system.

8. Click the Run button to run your query. The results of your query will appear in the iQ Results window. (See The iQ Results Window.)

If you click the Run button in a query without listing any columns to include in the query on the Report Columns tab, you will get an error message. Click OK. Add at least one column to the query and run the report again.

Contact Us

Research Informatics Director
Andrew Post, MD, PhD
Andrew.Post@hci.utah.edu
801-585-0600

Research Informatics Associate Director
Shirleen Hewitt, DBA
Shirleen.Hewitt@hci.utah.edu
801-585-5972

Governance

HCI Senior Director Oversight
Aik Choon Tan, PhD

Faculty Advisory Committee Chair
Aik Choon Tan, PhD

Faculty Advisory Committee Members
HCI Research Executive Committee