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="0256dcfc-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="Allergies and Sensitivities" /> <code> <coding> <system value="https://fhir.nhs.uk/gpconnect-record-section-1" /> <code value="ALL" /> <display value="Allergies and Sensitivities" /> </coding> <text value="Allergies and Sensitivities" /> </code> <text> <status value="generated" /> <div xmlns="http://www.w3.org/1999/xhtml"><table width="100%" border="1"><thead><tr><td colspan="5"><p><b>Allergies and Sensitivities</b>: </p></td></tr></thead><tbody align="left"><tr><td style="width:20%"><b>Allergy</b></td><td style="width:20%"><b>Manifestation</b></td><td style="width:20%"><b>Severity</b></td><td style="width:20%"><b>Onset</b></td><td style="width:20%"><b>Last Occurence</b></td></tr><tr><td style="width:20%">Allergy to penicillin</td><td style="width:20%">Difficulty breathing</td><td style="width:20%">Moderate</td><td style="width:20%">10-Jan-2015</td><td style="width:20%">10-Jan-2015</td></tr></tbody></table><br /></div> </text> </section> </Composition>