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.
<NutritionOrder xmlns="http://hl7.org/fhir"> <id value="core-examples-NutritionOrder-example3" /> <meta> <versionId value="1" /> <lastUpdated value="2016-09-08T11:58:26.6+00:00" /> </meta> <text> <status value="generated" /> --- We have skipped the narrative for better readability of the resource --- </text> <patient> <reference value="Patient/example" /> <display value="Peter Chalmers" /> </patient> <orderer> <reference value="Practitioner/example" /> <display value="Dr Adam Careful" /> </orderer> <identifier> <system value="http://goodhealthhospital.org/nutrition-orders" /> <value value="123" /> </identifier> <encounter> <reference value="Encounter/example" /> <display value="Inpatient" /> </encounter> <dateTime value="2014-09-17" /> <status value="active" /> <allergyIntolerance> <reference value="AllergyIntolerance/example" /> <display value="Cashew Nuts" /> </allergyIntolerance> <foodPreferenceModifier> <coding> <system value="http://hl7.org/fhir/diet" /> <code value="dairy-free" /> </coding> </foodPreferenceModifier> <excludeFoodModifier> <coding> <system value="http://snomed.info/sct" /> <version value="20140730" /> <code value="227493005" /> <display value="Cashew Nut" /> </coding> </excludeFoodModifier> <oralDiet> <type> <coding> <system value="http://snomed.info/sct" /> <code value="160670007" /> <display value="Diabetic diet" /> </coding> <coding> <system value="http://goodhealthhospital.org/diet-type-codes" /> <code value="1030" /> <display value="DD - Diabetic diet" /> </coding> <text value="DD - Diabetic diet" /> </type> <schedule> <repeat> <boundsPeriod> <start value="2015-02-10" /> </boundsPeriod> <frequency value="3" /> <period value="1" /> <periodUnits value="d" /> </repeat> </schedule> <nutrient> <modifier> <coding> <system value="http://snomed.info/sct" /> <code value="2331003" /> <display value="Carbohydrate" /> </coding> </modifier> <amount> <value value="75" /> <unit value="grams" /> <system value="http://unitsofmeasure.org/" /> <code value="g" /> </amount> </nutrient> </oralDiet> </NutritionOrder>