FQL is a query language that allows you to retrieve, filter and project data from any data source containing FHIR Resources. It brings the power of three existing languages together: SQL, JSON and FhirPath. It allows you to create tables and is useful for gaining insight and perform quality control.
<MedicationStatement xmlns="http://hl7.org/fhir"> <id value="335945" /> <meta> <versionId value="1" /> <lastUpdated value="2017-11-14T07:59:06.910-05:00" /> </meta> <contained> <Observation> <id value="1" /> <identifier> <use value="official" /> <system value="http://www.bmc.nl/zorgportal/identifiers/observations" /> <value value="6323" /> </identifier> <status value="final" /> <code> <coding> <system value="http://loinc.org" /> <code value="15074-8" /> <display value="Glucose [Moles/volume] in Blood" /> </coding> </code> <valueQuantity> <value value="74.0" /> </valueQuantity> </Observation> </contained> <extension url="https://fhirtest.uhn.ca/baseDstu3/MedicationStatement#bloodglucose"> <valueReference> <reference value="#1" /> </valueReference> </extension> <status value="active" /> <medicationReference> <reference value="Medication/335912" /> </medicationReference> <effectiveDateTime value="2017-11-14T13:59:00+01:00" /> <subject> <reference value="Patient/334159" /> </subject> <taken value="y" /> <note> <text value="asdf" /> </note> <dosage> <doseQuantity> <value value="19.0" /> </doseQuantity> </dosage> </MedicationStatement>