Cooking with CQL Examples

This page provides an index to the examples developed as part of the Cooking with CQL Series of Webinars in reverse chronological order. Cooking with CQL examples are collected from various sources including participant submissions. Please feel free to submit examples to ecqi@lantanagroup.com.

Examples for earlier sessions are on companion pages:

Cooking with CQL Examples - Sessions 51-100
Cooking with CQL Examples - Sessions 1-50 (sessions 21-50)
Archived Cooking with CQL Sessions 2016 and 2017 (sessions 1-20)

Existing links to a specific session on this page still resolve: each session anchor is preserved on its row in the index below, which links to the full entry on the companion page.

Session Index

Session	Date	Topics
102	2026-07-23	Refactoring QI-Core measures to use US Quality Core; Common CQL Artifacts for FHIR (US-Based)
101	2026-06-25	Intervals for all time; leap years; encounter diagnosis prevalence period; electronically transmitted prescription; condition verification status; ObservationCancelled; negation patterns
100	2026-04-23	Cohort definitions in quality measurement; ballot reminders
99	2026-03-26	Using US Common in measures; US Realm Connectathon; CQL US ballot reminder
98	2026-02-26	CQL US Common ballot review; Liquid template updates; implications of null predicate testing
97	2026-01-22	Pregnancy, imaging, mammography, and Claim/ExplanationOfBenefit patterns; QDM support; IG Publisher support for measure processing
96	2025-12-04	Age and value-based stratifiers; timing best practices; patient age calculation, allergy, and observation patterns
95	2025-09-25	CQL R2 ballot results; CT scan representation; CQL US review; Connectathon 40 report
94	2025-07-24	CQL R2 ballot review; measure narrative review; Reference.type caveat; timezone testing; estimated denominator measures
93	2025-06-26	CAUTI rates and standardized infection ratios (SIR)
92	2025-05-22	Derived model info support; US Core 7.0.0 and QI-Core 7.0.0; FHIRCommon, USCoreCommon, QICoreCommon
91	2025-04-24	CQL 2.0 feature review; CQL Cheat Sheet; Common CQL Assets for FHIR (US-Based) ballot
90	2025-03-27	CQL errata publication; claim diagnosis and principal procedure; QI-Core 6 change review
89	2025-01-23	QI-Core 6 uplift: CQL uplift, test case uplift, MADiE measure creation from QI-Core 4
88	2024-12-12	Activity extent; negation in FHIR; claim diagnosis; Using CQL With FHIR ballot
87	2024-10-24	Identifying acute kidney injury (CMS-832); CQL errata update
86	2024-09-19	Deep dive on stratifiers (principal diagnosis, gender, age group)
85	2024-07-25	Equality, equivalence, and nulls; consecutive SpO2 readings; terminology in CQL; medication daily dose
84	2024-06-27	Deep dive on sub-queries; allergy/intolerance category filter; aggregates with empty lists; aggregate clause
83	2024-05-30	Medication ordered and doNotPerform; Condition bodySite; primary code paths; overlaps before; quantity comparison
82	2024-04-25	Test on ART; HIV assay decision logic; HIV measure (tests vs. patients tested)
81	2024-03-28	Aggregate functions in CQL
80	2024-02-22	US Commons IG review; Using CQL With FHIR IG review; CQL next steps
79	2024-01-25	FHIRHelpers walkthrough; recently submitted issues (CQLIT-421/422/423)
78	2023-11-30	PC-07 numerator reporting; CMS1218 postoperative respiratory failure occurrence issue
77	2023-09-28	VS Code CQL plugin user guide
76	2023-07-27	Direct-reference-code encounters; MedicationRequest with Medication references
75	2023-06-22	Deep dive: intervals and lists
74	2023-05-25	Fluent functions; US Core tests in CQL
73	2023-04-27	Troubleshooting CQL expressions
72	2023-03-23	Deep dive: queries (retrieves, clauses, sub-clauses, singletons)
71	2023-02-23	Deep dive: operators and functions; UCUM units
70	2023-01-26	Authoring patterns by resource type
69	2022-12-01	Building shareable CQL: colorectal cancer screening example
68	2022-10-27	Deep dive on types, values, and choices
67	2022-09-29	Negation in QI-Core
66	2022-07-28	QI-Core profile elements and patterns
65	2022-06-23	CQL authoring using the VS Code plugin
64	2022-05-26	Shared library translations from the AU 2022 QDM publication
63	2022-04-28	Beginning CQL
62	2022-03-24	Community acquired pneumonia severity scores (CURB-65 and CRB-65)
61	2022-02-24	Aggregates, grouping, and having
60	2022-01-27	CQL errata review; QI-Core authoring review
59	2021-12-02	Cumulative medication duration in FHIR
58	2021-10-28	Shared CQL library repository concept; fluent functions
57	2021-09-16	Age calculations in QDM and FHIR; cumulative medication duration in QDM; UCUM best practice
56	2021-07-29	FHIR references; open source tooling stack; Library/$evaluate and $cql operations
55	2021-06-24	Blood pressure; age calculation; immunization not done
54	2021-05-27	Cumulative medication duration in FHIR; patterns and practices; stratification
53	2021-04-22	TSH testing monitoring; expand interval; resolving and tracing FHIR references; CQL exercises
52	2021-03-24	TSH testing every 8 weeks; bleeding events; composite measures with mixed-basis components
51	2021-02-25	Cumulative medication duration in FHIR; calculating months; week or wk?
50	2021-01-21	Collapse with null ending boundary; medication coverage; falls per 1000 patient days; QDM 5.6 entities
49	2020-12-03	Cumulative medication duration; Connectathon 26 review
48	2020-10-29	Lab tests every six weeks redux; QDM timings; interval boundary access
47	2020-10-01	Lab tests every six weeks; inpatient stay 48 hours or more; composite measure calculation
46	2020-07-30	QDM organization attributes; `with` vs. `from`; CQL timing phrases
45	2020-06-25	Coalesce review; high risk medications; advanced illness; troponin measure followup
44	2020-05-28	CQL basics and resources; query return types; collapse and expand; troponin continuous variable measure
43	2020-04-23	Encounters per day; FHIR, CQL, and QI-Core
42	2020-02-27	QI-Core usage patterns
41	2020-01-16	Medications not documented; choice-element timing; condition prevalence period; blood pressure components
40	2019-12-06	CMS826 pressure injury redux; bladder cancer measure; measure observation calculation; `is` vs. `as`
39	2019-10-24	CMS130 colorectal cancer screening (QDM and FHIR); EXM9 exclusive breast milk feeding
38	2019-09-26	Using FHIR to specify eCQMs
37	2019-07-25	Medications present on admission; representing SQL joins in CQL; QDM-to-FHIR side-by-side
36	2019-06-27	Nested definitions; hospitalization with observation; QDM vs. CQL timing phrases; pressure injury measure
35	2019-05-23	Multi-source query examples; QDM 5.5 timing attributes
34	2019-04-25	Issue tracker examples: multi-source queries, equal vs. equivalent, durations, multiple encounters
33	2019-03-28	QDM 5.5 change review; CQL 1.4 ballot review; negation rationale; related context retrieves
32	2019-02-28	Common patterns: age calculation, most recent lab result, comparing and sequential events, determining coverage
31	2019-01-31	Singleton results; lowest most recent blood pressure; same or after semantics; default temporal precision; coalesce; glucocorticoid dosage
30	2018-12-06	Hypoglycemia risk; anti-MRSA antibiotics; positive depression screening; ACO38 risk standardized readmission rates
29	2018-10-25	Terminology usage and VSAC; hospitalization admission source; age calculation; Boolean naming conventions
28	2018-09-27	Continuous variable ratio measure; blood transfusion; averaged blood pressures; conception date; user-defined functions
27	2018-07-26	Observation status and its impact on hospitalization functions
26	2018-06-28	Stratification; supplemental data; risk adjustment variables; common error messages
25	2018-05-31	Calculation differences between QDM logic and CQL; negation redux; QDM 5.4 changes
24	2018-04-26	Overlaps operator; claim query in FHIR; regional anesthesia; contraceptive provision; radiology report
23	2018-03-29	QDM specific occurrences in CQL; CMS105 walkthrough
22	2018-02-22	Encounter diagnoses; ED encounters; consecutive heart rates; allergy to eggs; smoking cessation
21	2018-01-18	2nd Tylenol administration during an encounter; NCQA vaccination example; opioid MME calculation
20 and earlier	2016-04-28 to 2017-11-30	Archived Cooking with CQL sessions, 2016 and 2017