\nFollowing the validation of your login credentials, the i2b2 Query & Analysis Tool screen is displayed and available for use. The basic i2b2 workbench screen provides six primary tabbed panes for identifying, building and running cohort discovery queries. These panes are indicated in the figure below.<\/p>\n
![\"How](\"\/bu-i2b2\/files\/2016\/07\/How-to-query-636x446.jpg\")
<\/p>\n
1. Navigate Terms<\/strong> – This is where you will locate search concepts using a hierarchical folder structure. Counting Patient Populations<\/strong><\/p>\n i2b2 Query Cell queries count the number of people meeting certain criteria. Each patient may \u00a0have multiple records in the database but each person is only counted once. Criteria listed within a group are considered to have an “or” relationship and between groups is considered to be an “and” relationship. For example, in the screen shot below the query is counting the number of people who had: 1) at least one visit to Family Medicine OR<\/strong> General Medicine OR<\/strong> Geriatrics; AND<\/strong> 2) a diagnosis of essential hypertension sometime in the past; AND<\/strong> 3) at least one blood pressure measurement in the past.<\/p>\n Below is a simple example of a Query Tool Query to count the number of adult primary care patients between 2005 and 2011, who have ever had a diagnosis of essential hypertension, and who have had at least 1 blood pressure between 2005 and 2015.<\/p>\n Step 1: Add your concepts<\/strong><\/p>\n The concepts (Essential Hypertension, General Medicine, Family Medicine, Geriatrics, Blood Pressure) were dragged into their groups from the Navigate Terms tab on the left.<\/p>\n Step 2: Apply Constraints<\/strong><\/p>\n To constrain to only patients with a visit to General Medicine, Family Medicine, Geriatrics and a Blood Pressure during 2005 to 2015, apply a “From:” and “To:” date to Group 1 and Group 2.<\/p>\n Step 3: Select your Analysis Type<\/strong><\/p>\n The most commonly used Analysis Types are: It is not recommended to use the Patient List and Encounter List options \u2013 These create lists of patients or patient encounters and stores them in the database. Since queries can have many thousands of patients, the use of these options creates lists of data that are not useful and will take up unnecessary space on the server.<\/p>\n Step 4: Run your query<\/strong><\/p>\n Click Run Query to run the query and the counts will be displayed in the bottom center.<\/p>\n","protected":false},"excerpt":{"rendered":" The web-based i2b2 Query Tool is the most commonly used module by researchers. The Query Tool allows users to very quickly count the number of people with selected clinical and demographic features. Navigating the i2b2 Query & Analysis Tool Following the validation of your login credentials, the i2b2 Query & Analysis Tool screen is displayed […]<\/p>\n","protected":false},"author":11962,"featured_media":0,"parent":255,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/pages\/90"}],"collection":[{"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/users\/11962"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":23,"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/pages\/90\/revisions"}],"predecessor-version":[{"id":549,"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/pages\/90\/revisions\/549"}],"up":[{"embeddable":true,"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/pages\/255"}],"wp:attachment":[{"href":"https:\/\/sites.bu.edu\/bu-i2b2\/wp-json\/wp\/v2\/media?parent=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2. Find Terms<\/strong> \u2010 In this pane, you can find search concepts using a representative word, phrase or specific
\ncode to describe the concept.
\n3. Workplace<\/strong> – This is where you will create personal folders for storing your queries.
\n4. Previous Queries<\/strong> \u2010 This pane shows a log of previous queries for the current user.
\n5. Query Tool<\/strong> \u2010 This is your main work area where you will define and refine the criteria for your query.
\n6. Query Status<\/strong> \u2010 You will be able to monitor progress and see results in this pane.<\/p>\n
\n![\"Query](\"\/bu-i2b2\/files\/2016\/08\/Query-Tool-1-636x370.jpg\")
s<\/p>\n![\"dates\"](\"\/bu-i2b2\/files\/2016\/09\/dates-636x388.jpg\")
<\/p>\n
\nNumber of Patients
\nGender Patient Breakdown
\nRace Patient Breakdown
\nAge Patient Breakdown<\/p>\n![\"query](\"\/bu-i2b2\/files\/2016\/09\/query-dates1-636x565.jpg\")
<\/p>\n![\"YES\"](\"\/bu-i2b2\/files\/2016\/09\/YES2-636x431.jpg\")
<\/p>\n