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="core-examples-MedicationStatement-example4" /> <meta> <versionId value="1" /> <lastUpdated value="2016-09-08T11:38:02.446+00:00" /> </meta> <text> <status value="generated" /> --- We have skipped the narrative for better readability of the resource --- </text> <patient> <reference value="Patient/example" /> </patient> <informationSource> <reference value="Patient/example" /> </informationSource> <dateAsserted value="2015-02-22" /> <status value="completed" /> <wasNotTaken value="false" /> <reasonForUseCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="65363002" /> <display value="Otitis Media" /> </coding> </reasonForUseCodeableConcept> <effectiveDateTime value="2014-01-23" /> <note value="Patient indicates they miss the occasional dose" /> <medicationReference> <reference value="Medication/MedicationExample6" /> </medicationReference> <dosage> <text value="one capsule three times daily" /> <timing> <repeat> <frequency value="3" /> <period value="1" /> <periodUnits value="d" /> </repeat> </timing> <asNeededBoolean value="false" /> <route> <coding> <system value="http://snomed.info/sct" /> <code value="260548002" /> <display value="Oral" /> </coding> </route> <quantityQuantity> <value value="1" /> </quantityQuantity> <maxDosePerPeriod> <numerator> <value value="3" /> <unit value="capsules" /> <system value="http://snomed.info/sct" /> <code value="385055001" /> </numerator> <denominator> <value value="1" /> <system value="http://unitsofmeasure.org/" /> <code value="d" /> </denominator> </maxDosePerPeriod> </dosage> </MedicationStatement>