This section describes the process of adding items to the query tool, "AND" / "OR" operators and setting constraints.
| Quick Links |
In order to create your query, you will need to define what information will be retrieved from the databases. Selected items from other i2b2 Web Client views can be dragged and dropped (copied) into the Query Tool view. Below is a list of the various items that can be dragged and dropped in to the Query Tool as you create your query:
A new query can be created from one that has already been run by dragging the previous query from Previous Query and Workplace views.
A patient set can be can be used in a query by dragging the patient set from Previous Query and Workplace views . When you run the query it will use the patient set to query against.
An encounter set () can be used in a query by dragging the patient set from Previous Query and Workplace views. When you run the query it will use the encounter set to query against.
There are two operators, known as SQL Logical Operators, which are necessary when running a query that has more than one item. These operators provide a way to specify exactly what you want to retrieve. The operators are the 'AND' and 'OR' operators.
IMPORTANT: The query tool knows which operator to use based on the panels used when defining the query. It is important to verify you are setting up your query correctly as each operator will return different results. |
The AND operator returns a record if both the first condition and the second conditions are true. The query tool uses the AND operator when concepts are listed in different panels.
Example:
WHAT: Return only those patients who have Acute Myocardial Infarction AND Angina Pectoris.
HOW: In the query tool add the concept Acute Myocardial Infarction to Group 1 and then add the concept Angina Pectoris to Group 2.
RESULT: The population is limited by requiring the patients fulfill both requirements.
The OR operator returns a record if either the first condition or the second conditions are true.
The query tool uses the OR operator when concepts are listed in different panels.
Example:
WHAT: Return only those patients who have Acute Myocardial Infarction OR Angina Pectoris.
HOW: In the query tool add both concepts Acute Myocardial Infarction and Angina Pectoris to Group 1.
RESULT: The population is broadened to include all patients who fit either one of those criteria.
Concepts can be added to the Query Tool view by simply dragging the concept from one of the following views.
Navigate Terms view
Find Terms view
Workplace view
The Navigate Terms view contains a hierarchical display of all the items that can be used to search the database.
NOTE: How the items are grouped and displayed is dependent on how the database is setup. |
In the Navigate Terms view, expand the folder(s) that contains the concept or grouping of concepts you want to add.
Highlight the concept or folder () by clicking on its name.
While holding the left mouse button down, drag the item over to the Query Tool view
Drop the item into the panel labeled Group 1.
The item will now display in the panel for Group 1.
The Find Terms view provides a way to search for a particular concept.
NOTE: For detailed information on how to search for terms, please click on the Find Terms section. |
In the Find Terms view, search for the item(s) you want to add.
Highlight the concept or folder by clicking on its name.
While holding the left mouse button down, drag the item over to the Query Tool view
Drop the item into the panel labeled Group 1.
The item will now display in the panel for Group 1.