To edit an existing query:

  1. Click on the Query UPDBL button on the upper right side of the window or click on the Query UPDBL button in the lower right corner of the window. The Saved Queries window open.

queryupdblbuttons

  1. Find the query you wish to edit in the Saved Queries list and click on it. See The Saved Queries Window for a description of the organization of the Saved Queries list and how to find a specific query in the list.
  2. Click on the Load button on the right side of the Saved Queries window. The Cohort Builder window will open, listing the criteria for the selected query.

loadbutton

  1. Make any necessary changes to the query that affect the criteria used to select the cohort. Your changes will automatically be saved. See The Cohort Builder Window and The Add Criteria Window for more detailed descriptions of how to make specific changes. Some basic steps to making changes follow:

    • To add additional sets of criteria, click on the AND or OR button (whichever applies) to open the Add Criteria window and enter the criteria there.

andorbuttonscohortbuilder

- To remove criteria, select the criteria in the list on the Cohort Builder and click on the Remove Criteria button.

removecriteriabutton

- To change the logic structure of the query, drag the criteria in the list to change the order of criteria and/or change the appropriate ALL/ANY drop-down fields until the logic structure is organized correctly.

anyalldropdownselection

- You may not edit any of the sets of criteria in the Cohort Builder list. In order to change any of these criteria, you will need to delete the version that needs to change and add the correct version from scratch.
  1. Once all the appropriate changes have been made to the cohort criteria, click on the button marked Select and Run Aggregation to access the query's aggregation settings.

runaggregationbutton

  1. Make any changes to the list of fields for aggregation in the Format Results grid. Your changes will be automatically saved. See The Totals Window and The Select Grouping Criteria For Results Window for more detailed descriptions of how to make specific changes. Some basic steps to making changes follow:
  • To add a field for aggregation, click on the + button above the Format Results grid and select the field on the Select Grouping Criteria For Results window.
  • To remove a field from the aggregation list, click on that field in the list so that it is highlighted, then click on the button above the Format Results grid.
  • To move a field in the list (change the order) select that field in the list and click on the up or down arrow next to the list as appropriate.

Once you have made any necessary changes to the aggregation settings, your query should be complete. From here you can:

  • Click on the Run Query button to see aggregation totals for the query — see Running a Previously Created Query. The totals will appear in the lower area of the window — it may take some time for the query to run.
  • Click on the Examine Relationships button to analyze the results of the query using the Relationships tool — see Examining Relationships Within a Query Cohort.

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