SHRINE User Guide

Contents Basics Requirements Data Steward SHRINE Data Results Menus and Options Main Menu and Options Terms View Query Tool View Query Status View Previous Queries View Accessing SHRINE Registering Logging In to SHRINE Submitting a Query Topic Request Constructing a Query Working with Query Results [ SHRINE Help Main Menu ] | ## 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. If you do not have an approved Query Topic, you must request a new topic approval from the Data Steward. 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. You cannot type a query name directly into this field. Group columns – 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 a Topic 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 monitors query activities. If you select query terms that do not apply logically to your topic, the steward can suspend your access to SHRINE, and a review of your activities is 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 from the SHRINE system by clicking this button. The Data Steward 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. New Group button – To add additional groups of terms to your query, click this button. Group page controls – If you add groups to the default of three, you can navigate to additional groups by using these page controls.