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.
<DocumentReference xmlns="http://hl7.org/fhir"> <id value="core-examples-DocumentReference-example" /> <meta> <versionId value="1" /> <lastUpdated value="2016-09-08T11:58:21.35+00:00" /> </meta> <text> <status value="generated" /> --- We have skipped the narrative for better readability of the resource --- </text> <contained> <Practitioner> <id value="a2" /> <name> <family value="Smitty" /> <given value="Gerald" /> </name> <practitionerRole> <managingOrganization> <display value="Cleveland Clinic" /> </managingOrganization> <role> <text value="Attending" /> </role> <specialty> <text value="Orthopedic" /> </specialty> </practitionerRole> </Practitioner> </contained> <masterIdentifier> <system value="urn:ietf:rfc:3986" /> <value value="urn:oid:1.3.6.1.4.1.21367.2005.3.7" /> </masterIdentifier> <identifier> <system value="urn:ietf:rfc:3986" /> <value value="urn:oid:1.3.6.1.4.1.21367.2005.3.7.1234" /> </identifier> <subject> <reference value="Patient/xcda" /> </subject> <type> <coding> <system value="http://loinc.org/" /> <code value="34108-1" /> <display value="Outpatient Note" /> </coding> </type> <class> <coding> <system value="http://ihe.net/xds/connectathon/classCodes" /> <code value="History and Physical" /> <display value="History and Physical" /> </coding> </class> <author> <reference value="Practitioner/xcda1" /> </author> <author> <reference value="#a2" /> </author> <custodian> <reference value="Organization/organization-example" /> </custodian> <authenticator> <reference value="Organization/organization-example" /> </authenticator> <created value="2005-12-24T09:35:00+11:00" /> <indexed value="2005-12-24T09:43:41+11:00" /> <status value="current" /> <docStatus> <coding> <system value="http://hl7.org/fhir/composition-status" /> <code value="preliminary" /> <display value="preliminary" /> </coding> </docStatus> <relatesTo> <code value="appends" /> <target> <reference value="DocumentReference/example" /> </target> </relatesTo> <description value="Physical" /> <securityLabel> <coding> <system value="http://hl7.org/fhir/v3/Confidentiality" /> <code value="V" /> <display value="very restricted" /> </coding> </securityLabel> <content> <attachment> <contentType value="application/hl7-v3+xml" /> <language value="en-US" /> <url value="http://example.org/xds/mhd/Binary/07a6483f-732b-461e-86b6-edb665c45510" /> <size value="3654" /> <hash value="2jmj7l5rSw0yVb/vlWAYkK/YBwk=" /> </attachment> <format> <system value="urn:oid:1.3.6.1.4.1.19376.1.2.3" /> <code value="urn:ihe:pcc:handp:2008" /> <display value="History and Physical Specification" /> </format> </content> <context> <encounter> <reference value="Encounter/xcda" /> </encounter> <event> <coding> <system value="http://ihe.net/xds/connectathon/eventCodes" /> <code value="T-D8200" /> <display value="Arm" /> </coding> </event> <period> <start value="2004-12-23T08:00:00+11:00" /> <end value="2004-12-23T08:01:00+11:00" /> </period> <facilityType> <coding> <system value="http://www.ihe.net/xds/connectathon/healthcareFacilityTypeCodes" /> <code value="Outpatient" /> <display value="Outpatient" /> </coding> </facilityType> <practiceSetting> <coding> <system value="http://www.ihe.net/xds/connectathon/practiceSettingCodes" /> <code value="General Medicine" /> <display value="General Medicine" /> </coding> </practiceSetting> <sourcePatientInfo> <reference value="Patient/xcda" /> </sourcePatientInfo> <related> <identifier> <system value="urn:ietf:rfc:3986" /> <value value="urn:oid:1.3.6.1.4.1.21367.2005.3.7.2345" /> </identifier> <ref> <reference value="Patient/xcda" /> </ref> </related> </context> </DocumentReference>