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.
<Composition xmlns="http://hl7.org/fhir"> <id value="0256d428-5aea-11e6-8b77-86f30ca893d3" /> <meta> <profile value="https://fhir.nhs.uk/StructureDefinition/gpconnect-carerecord-composition-1" /> </meta> <text> <status value="generated" /> --- We have skipped the narrative for better readability of the resource --- </text> <extension url="https://fhir.nhs.uk/StructureDefinition/Extension-GPC-CareSettingType-1"> <valueCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="700232004" /> <display value="general medical service (qualifier value)" /> </coding> <text value="general medical service (qualifier value)" /> </valueCodeableConcept> </extension> <date value="2015-07-11T10:11:15+00:00" /> <type> <coding> <system value="http://snomed.info/sct" /> <code value="425173008" /> <display value="record extract (record artifact)" /> </coding> <text value="record extract (record artifact)" /> </type> <title value="Patient Care Record" /> <status value="final" /> <confidentiality value="V" /> <subject> <reference value="Patient/31686b67-9f20-4644-9a54-193d2f91de57" /> <display value="TAYLOR, Sally (Mrs)" /> </subject> <author> <reference value="Device/c4c8d038-913a-490c-9682-47047f4155fb" /> <display value="EMIS AA 1001-C 8.15-04" /> </author> <custodian> <reference value="Organization/79600119-ebaf-4362-bb89-d473a33b1675" /> <display value="Wood Town GP practice" /> </custodian> <section> <title value="Medications" /> <code> <coding> <system value="https://fhir.nhs.uk/gpconnect-record-section-1" /> <code value="MED" /> <display value="Medications" /> </coding> <text value="Medications" /> </code> <text> <status value="generated" /> <div xmlns="http://www.w3.org/1999/xhtml"><table width="100%" border="1"><thead><tr><td colspan="6"><p><b>Medications</b>: </p></td></tr></thead><tbody align="left"><tr><td style="width:20%"><b>Name</b></td><td style="width:10%"><b>Dose</b></td><td style="width:20%"><b>Medication Frequency</b></td><td style="width:10%"><b>Route</b></td><td style="width:20%"><b>Medication Recommendations</b></td><td style="width:20%"><b>Date Prescribed</b></td></tr><tr><td style="width:20%">Naproxen 250mg tablets</td><td style="width:10%">250mg</td><td style="width:20%">One daily</td><td style="width:10%">oral</td><td style="width:20%">continue</td><td style="width:20%">1-Feb-2015</td></tr><tr><td style="width:20%">Aspirin 75mg e/c tablet</td><td style="width:10%">75mg</td><td style="width:20%">One daily</td><td style="width:10%">oral</td><td style="width:20%">continue</td><td style="width:20%">14-Feb-2015</td></tr><tr><td style="width:20%">Naproxen 250mg tablets</td><td style="width:10%">250mg</td><td style="width:20%">One tablet three times daily</td><td style="width:10%">oral</td><td style="width:20%">continue</td><td style="width:20%">1-Sep-2014</td></tr></tbody></table><br /></div> </text> </section> </Composition>