The Query Tool panel is where queries are constructed and run.
These items may be dragged into Query Groups to construct queries.
Icons | Names | Description |
---|---|---|
Terms | Terms (also called concepts) are the words or phrases that make up vocabularies. Terms are the basic query items. | |
Term Groups | Related terms are grouped into hierarchies. When a term group is used in a query, all terms in the group are searched for. | |
Modifiers | Modifiers are descriptors that can be attached to terms to make small changes to them. For example, a Diagnosis concept may be additionally described by Modifiers "Principal Diagnosis" or "Secondary diagnosis." | |
Modifier Groups | Groups of Modifiers, similar to Term Groups. | |
/ | Previous Queries | Previous Queries are queries that have been run before and are stored in the 'Previous Queries' panel. |
Individual Patients | If selected when running a query, a query can return a Patient Set,which is a set of patient numbers that satisfy the query criteria. The Patient Set is stored with the query in the Previous Queries panel. The Patient Set can be expanded, and individual subjects dragged into query groups to be used in a new query. | |
Patient Sets | If selected when running a query, a query can return a Patient Set, which is a set of patient numbers that satisfy the query criteria. The Patient Set is stored with the query in the Previous Queries panel and can be dragged into query groups to be used in a new query. | |
Encounter Sets | If selected when running a query, a query can return an Encounter Set, which is a set of encounter numbers that satisfy the query criteria. The Encounter Set is stored with the query in the Previous Queries panel and can be dragged into query groups to be used in a new query. |
i2b2 items are combined using Boolean operators AND and OR.
Items within each Group are first ORed together. The Groups are then ANDed together.
Example 1 (AND): This query finds patients with Acute Myocardial Infarction AND Angina Pectoris.
Example 2 (OR): This query finds patients with Acute Myocardial Infarction OR Angina Pectoris.
Example 3 (AND of ORs): This query finds patients with (Acute Myocardial Infarction OR Angina Pectoris) AND who are male.
*Note that the OR expression in the parentheses is evaluated first.
Constraints are used to narrow down the search criteria to a particular time frame, number of occurrences or a specific value or range of values. In i2b2, there are several types of constraints that can be defined in the Query Tool view.
Users can define the number of times an item must occur for each subject.
A new window will open
Click on the drop-down arrow to display a list of numbers.
Select a number from the list.
Click on the OK button.
Occurs > 0x will now be underlined to indicate a constraint has been set and the 0 will be replaced with the selected number.
Old Notes below (to be deleted):
(e.g. "Find patients who have a systolic blood pressure reading greater than 130 mm Hg")