To add columns 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 on the right side of the window. *If the query is in the 'Queries shared with you' folder, it was created by someone else and you must first make a copy of it in the 'Your Queries' folder before you can alter it. See Copying and Altering a Preexisting iQ for instructions on how to do this.

3. Find the 'Display' section.

4. Click the add button above the display section. The Add Report Column window will appear.

5. Find the field with the data you would like displayed in the column among the folders and fields displayed in the Properties data tree.You may have to open several folders and subfolders (by clicking the green play icon 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 on the right side of the window. (See The Application Data Structure.)

6. Once you have found the field you want, click on it to open the Select Report Column window. Click Save to save the report column and close the window. Click Save & Add Another to keep adding additional report columns.

Clicking on the Close button will not add any columns to the query. Make sure that you have clicked the Add button for all columns you want to add before clicking Close.

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