1.1 Basic Query
You can find patients by placing a health condition (term) on a 'Query Tool' group panel.
[How to]
- Find a term
- Go to 'Navigate Terms' tab
- Click term folders to narrow down the concept
- If a target term is found, select the term
- Drag and drop to 'Group 1'
- Drag the selected term into 'Query Tool > Group 1'
- Run Query
- Click 'Query Tool > Run Query' → 'OK'
- Get Result
- Query running status will be displayed in 'Show Query Status' tab, which is located below 'Query Tool'
- Query result will be displayed in 'Graph Results'
- Number of patients
- Query name
- The query and its result will be stored and displayed in 'Previous Queries' tab
- You may revisit the query and result from the 'Previous Queries'
[Example]
|
---|
- Find Acute respiratory infections
- Go to 'Navigate Terms' tab
- Select Diagnosis → Respiratory system → Acute respiratory infections
- Drag and drop
- Drag the Acute respiratory infections term into 'Query Tool > Group 1'
- Run Query
- Click 'Query Tool > Run Query' → 'OK'
- Get Results
- See the 'Graph Results' tab for the query result
- You may refer the information later from the 'Previous Queries' tab
1.2 Adding an AND term
Terms in different groups have logical AND relation.
[How to]
- Find a Term
- Go to 'Navigate Terms' tab
- Click term folders to narrow down the concept
- If a target term is found, select the term
- Drag and drop to 'Group 1'
- Drag the selected term into 'Query Tool > Group 1'
- Find another Term
- Drag and drop to 'Group 2'
- Drag the selected term into 'Query Tool > Group 2'
- Run Query
- Click 'Query Tool > Run Query' → 'OK'
- Get Result
- See the 'Graph Results' tab for the query result
- You may refer the information later from the 'Previous Queries' tab
[Example]
|
---|
- Find Acute respiratory infections
- Go to 'Navigate Terms' tab
- Select Diagnosis → Respiratory system → Acute respiratory infections
- Drag and drop
- Drag the Acute respiratory infections term into 'Query Tool > Group 1'
- Find Bronchodilators
- Go to 'Navigate Terms' tab
- Select Medications → Respiratory agents → Bronchodilators
- Drag and drop
- Drag the Acute respiratory infections term into 'Query Tool > Group 2'
- Run Query
- Click 'Query Tool > Run Query' → 'OK'
- Get Results
- See the 'Graph Results' tab for the query result
- You may refer the information later from the 'Previous Queries' tab
1.3 Adding an OR term
Terms in the same group have logical OR relation.
[How to]
- Find a Term
- Go to 'Navigate Terms' tab
- Click term folders to narrow down the concept
- If a target term is found, select the term
- Drag and drop to 'Group 1'
- Drag the selected term into 'Query Tool > Group 1'
- Find another Term
- Drag and drop to 'Group 1'
- Drag the selected term into 'Query Tool > Group 1', again.
- Run Query
- Click 'Query Tool > Run Query' → 'OK'
- Get Result
- See the 'Graph Results' tab for the query result
- You may refer the information later from the 'Previous Queries' tab
[Example]
|
---|
- Find Acute respiratory infections
- Go to 'Navigate Terms' tab
- Select Diagnosis → Respiratory system → Acute respiratory infections
- Drag and drop
- Drag the Acute respiratory infections term into 'Query Tool > Group 1'
- Find Asthma
- Go to 'Navigate Terms' tab
- Select Diagnosis → Respiratory system → Chronic obstructive diseases → Asthma
- Drag and drop
- Drag the Acute respiratory infections term into 'Query Tool > Group 1', again
- Find Bronchodilators
- Go to 'Navigate Terms' tab
- Select Medications → Respiratory agents → Bronchodilators
- Drag and drop
- Drag the Acute respiratory infections term into 'Query Tool > Group 2'
- Run Query
- Click 'Query Tool > Run Query' → 'OK'
- Get Results
- See the 'Graph Results' tab for the query result
- You may refer the information later from the 'Previous Queries' tab