SHRINE Help Site » 1. User Guide

1.2.3 Query Tool View

The Query Tool enables you to create complicated queries by using a simple user interface.

Note: You cannot run a query until you select a topic from the pulldown field labeled "------ Select an Approved Query Topic ------". (If you do not have an approved Query Topic, you must request a new topic approval through the Data Steward application. Your approved topic will then appear in the aforementioned pulldown field.)

Construct your query by using these fields and functions:

  • Query Name – When you click Run Query, SHRINE prompts you to enter a name for that query instance before you can run the process. The default name is a string constructed from your term selections and the time at which you run the query.
  • Group columns (Group 1, Group 2, etc.) – Query groups represent a set of patients defined by the terms within the group and any constraints applied to that group.
    Terms within a group operate as OR logic, while terms between groups operate as AND logic. For example, from the Terms view drag demographic terms of 35 years old and 36 years old to one group to select patients either 35 or 36 years old. Or drag a diagnosis term of Asthma to one group, a demographic age term of 35 years old to a second group, and a demographic gender term of Male to a third group to select patients diagnosed with asthma who are 35-year old males.
    When a group contains multiple terms, the query first runs with a single term from each group, and then runs with any additional terms. For example, if you drag a diagnosis of Asthma to Group 1 and then drag demographic terms of 10-17 years old and 0-9 years old to Group 2, the query first processes diagnosis of asthma and demographics of 10-17 years old. Another query process runs diagnosis of asthma and demographics of 0-9 years old. The two results sets then are added together to return the final query results.
  • Select an Approved Query Topic from the pull-down list – Before you can run a query, you must select the Query Topic to which this query relates. The Topics list contains all your Data Steward-approved topics.
    The Data Steward administrator monitors query activities. If you select query terms that do not apply logically to your topic, the administrator can suspend your access to SHRINE, and a review of your activities will be required.
  • Info button – When a Query Topic is selected, click Info to view the description of that topic as it was provided to the Data Steward.
  • Request New Topic button – Access the Data Steward application from the SHRINE system by clicking this button. The application opens in a new window.
    Note: To run a query that does not conform to any of your approved Topics, you must request a new topic from the Data Steward and receive approval before you can perform the query.
  • Run Query button – When you complete construction of your query using the terms, constraints, and options available, click Run Query to start the query process.
    You can run additional queries by retaining the existing terms in the Query Tool fields, and then adding new criteria to the query. Be careful not to run the same query multiple times.
  • New Query button – Click this button to clear all Query Tool fields and start a new query.
  • Print Query button – Click this button to open a printable view of your query and its results. When the new window opens displaying the query information, press Ctrl+P (on a PC) or Command+P (on a Mac) to invoke the Print dialog, and proceed as usual.
  • New Group button – To add additional groups of terms to your query, click this button.
  • Group page controls – If you add groups to the three default groups displayed in the tool, you can navigate to your additional groups by using these page controls.