HFQL Playground

HFQL (HAPI FHIR Query Language) is a SQL-like language for querying FHIR repositories introduced by HAPI FHIR. This language allows you to access FHIR data using a simple syntax and retrieve the results in a tabular format.

This tool allows you to experiment with the HFQL syntax online. You can execute the queries against the mock data provided in FSH (FHIR Shorthand).

HFQL query

SELECT
  name[0].family AS family,
  birthDate
FROM Patient
ORDER BY birthDate1
SELECT
2
  name[0].family AS family,
3
  birthDate
4
FROM Patient
5
ORDER BY birthDate

The HFQL query to run.

Test FHIR resources (FSH instances)

Alias: $loinc = http://loinc.org

Instance: June
InstanceOf: Patient
* name.family = "Dunn"
* name.given = "June"
* gender = #female
* birthDate = "1965-01-01"

Instance: Karen
InstanceOf: Patient
* name.family = "McCarren"
* name.given = "Karen"
* gender = #female
* birthDate = "1965-01-01"

Instance: Donald
InstanceOf: Patient
* name.family = "Duck"
* name.given = "Donald"
* gender = #male
* birthDate = "1975-01-01"

Instance: JunesMammogram
InstanceOf: DiagnosticReport
* code = $loinc#24604-1 "MG Breast Diagnostic Limited Views"
* subject = Reference(Patient/June)1
Alias: $loinc = http://loinc.org
2

3
Instance: June
4
InstanceOf: Patient
5
* name.family = "Dunn"
6
* name.given = "June"
7
* gender = #female
8
* birthDate = "1965-01-01"
9

10
Instance: Karen
11
InstanceOf: Patient
12
* name.family = "McCarren"
13
* name.given = "Karen"
14
* gender = #female
15
* birthDate = "1965-01-01"
16

17
Instance: Donald
18
InstanceOf: Patient
19
* name.family = "Duck"
20
* name.given = "Donald"
21
* gender = #male
22
* birthDate = "1975-01-01"
23

24
Instance: JunesMammogram
25
InstanceOf: DiagnosticReport
26
* code = $loinc#24604-1 "MG Breast Diagnostic Limited Views"
27
* subject = Reference(Patient/June)

The FHIR resources (FSH instances) to be used for testing.

Result

Press Execute HFQL to see the result.