Quick Reference Guide
- 18 Sep 2024
- 2 Minutes to read
- Print
- DarkLight
Quick Reference Guide
- Updated on 18 Sep 2024
- 2 Minutes to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
For a more complete list of report parameters and help, see the Query Syntax guide.
Vocabulary
Query: A request for information from the database.
Report: A script that runs several queries built upon the results of the previous query. It is possible to use the information retrieved from the queries for more complex functions, such as analytics.
Results: The response from the database after executing a query or report.
Boolean Expressions
The examples included are very simple queries. Know that it is possible to string as many terms together as needed to narrow the search.
| Name | Examples | Comments |
|---|---|---|
| Parentheses | ()expression (expression) | Putting both parentheses at the beginning of the Boolean expression is the same as surrounding the expression in parentheses, but they must be present for the query to function as a Boolean expression. |
| Operators | ()diabetes AND kidneys ()IN(head, shoulders, knees, toes) | The operators include: NOT, OR, AND, IN (for large OR expressions), FOR (for multiple OR terms using fields or symbols). Use all capitals for the operators. |
| Fields | s.indexed_field:"term" | Preface the indexed field name with the proper notation; most, if not all, of our fields are s. (string), d. (date), n. (number), or h. (hierarchy). Use a colon after the field and quotes if you are searching for phrases. |
| Facility | ()s.sending_facility:"Hospital" ()h.sending_facility:"Hospital" | The difference between the two examples to the left is that that first (s.) is a keyword search in the field while the second (h.) is an exact search and will only find those that contain the value only. |
| Numbers | ()n.patient_age:[10 TO 25] ()n.heart_rate:[100 TO *] | Use {} (exclude boundary), [] (include boundary), * (a wildcard that will include anything before or after the number provided), or any combination. |
| Dates | ()d.patient_date_of_birth:[20020601 TO 20021231] ()d.patient_date_of_birth:[-3mo TO TODAY] | Use the date time format yyyymmddhhmmss. Not all elements have to be used, but they must be used in order and they must start with the year. You can use relative dates instead of exact dates. Use {} (exclude boundary), [] (include boundary), * (a wildcard that will include anything before or after the date provided), or any combination. |
| Sets | ()SET:xyz_infirmary ()FILTER(PatientIDN:SET:__ABC_Pediatrics__) | SET must be in all capitals and must be followed by a colon. FILTER is only required with sets if you are using QuickTable fields. You can also see Set Query Syntax for more help. |
| FILTER | ()FILTER(year:1934 AND score:98) | Used with QuickTable fields. Contains a Boolean expression. Follow the FILTER keyword with the Boolean expression surrounded by parentheses. |
| Symbols | ()FOR(snomed.s.p.patient.<labs.acl>):IN(<snomed.diabetes_codes>) | Prior to using symbols, a symbol map must be set up through the Admin: Symbols. Designate symbols by enclosing them in angle brackets (<>). Symbol names contain two parts—a category and a variable name—and are separated by a period. |
Was this article helpful?