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.
<Bundle xmlns="http://hl7.org/fhir"> <id value="search-document-response-example" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-searchset-Bundle" /> </meta> <type value="searchset" /> <total value="1" /> <entry> <fullUrl value="urn:uuid:48d7775a-8ab5-44b7-be46-8d4c9111ba11" /> <resource> <Bundle> <id value="48d7775a-8ab5-44b7-be46-8d4c9111ba11" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-document-Bundle" /> </meta> <identifier> <system value="urn:oid:2.16.840.1.113883.3.239.23.18.10" /> <value value="27074671-3" /> </identifier> <type value="document" /> <timestamp value="2025-04-01T22:12:21" /> <entry> <fullUrl value="urn:uuid:180f219f-97a8-486d-99d9-ed631fe4fc57" /> <resource> <Composition> <id value="180f219f-97a8-486d-99d9-ed631fe4fc57" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-Composition" /> </meta> <text> <status value="generated" /> <div xmlns="http://www.w3.org/1999/xhtml"><p><b>Generated Narrative with Details</b></p><p><b>id</b>: 180f219f-97a8-486d-99d9-ed631fe4fc57</p><p><b>meta</b>: </p><p><b>status</b>: final</p><p><b>type</b>: Discharge Summary from Responsible Clinician <span>(Details : {LOINC code '28655-9' = 'Physician attending Discharge summary)</span></p><p><b>encounter</b>: <a>[base]/Encounter/doc-example</a></p><p><b>date</b>: 01/02/2021 12:30:02 PM</p><p><b>author</b>: <a>Doctor Dave</a></p><p><b>title</b>: Discharge Summary</p><p><b>confidentiality</b>: N</p></div> </text> <identifier> <system value="urn:oid:2.16.840.1.113883.3.239.23.10.102.8" /> <value value="12345" /> </identifier> <status value="final" /> <type> <coding> <extension url="http://ontariohealth.ca/fhir/StructureDefinition/ext-accdr-document-code-type"> <valueCoding> <system value="http://ontariohealth.ca/fhir/CodeSystem/accdr-document-code-type" /> <code value="local" /> <display value="Local code" /> </valueCoding> </extension> <system value="urn:oid:2.16.840.1.113883.3.239.23.10.102.8" /> <code value="5_" /> <display value="DISCHARGE SUMMARY" /> </coding> <coding> <extension url="http://ontariohealth.ca/fhir/StructureDefinition/ext-accdr-document-code-type"> <valueCoding> <system value="http://ontariohealth.ca/fhir/CodeSystem/accdr-document-code-type" /> <code value="provincial" /> <display value="Provincial code" /> </valueCoding> </extension> <system value="http://loinc.org" /> <code value="18842-5" /> <display value="Discharge Summary" /> </coding> </type> <subject> <reference value="urn:uuid:efdbe1ce-1b5a-40bd-a6a1-68160ebb4c09" /> <display value="Eve Everywoman" /> </subject> <encounter> <reference value="urn:uuid:9d074a84-a021-4c9e-9ff6-02650dc7985a" /> </encounter> <date value="2025-02-01" /> <author> <reference value="urn:uuid:618fdf59-4adb-457e-bdd7-45fbec1314fa" /> </author> <title value="Discharge Summary" /> <confidentiality value="N" /> <custodian> <reference value="urn:uuid:6dda4680-6412-4c1c-aaa9-c98e587661c9" /> </custodian> <section> <title value="Reason for admission" /> <code> <coding> <system value="http://loinc.org" /> <code value="29299-5" /> <display value="Reason for visit Narrative" /> </coding> </code> <text> <status value="additional" /> <div xmlns="http://www.w3.org/1999/xhtml"> <table> <thead> <tr> <td>Details</td> <td/> </tr> </thead> <tbody> <tr> <td>Acute Asthmatic attack. Was wheezing for days prior to admission.</td> <td/> </tr> </tbody> </table> </div> </text> </section> <section> <title value="Medications on Discharge" /> <code> <coding> <system value="http://loinc.org" /> <code value="10183-2" /> <display value="Hospital discharge medications Narrative" /> </coding> </code> <text> <status value="additional" /> <div xmlns="http://www.w3.org/1999/xhtml"> <p> Medication prescription: Ventolin Inhaler <br/> Instruction: Use two sprays twice daily <br/> Additional Instruction: Shake Well </p> </div> </text> </section> <section> <title value="Known allergies" /> <code> <coding> <system value="http://loinc.org" /> <code value="48765-2" /> <display value="Allergies and adverse reactions Document" /> </coding> </code> <text> <status value="additional" /> <div xmlns="http://www.w3.org/1999/xhtml"> <table> <thead> <tr> <td>Allergen</td> <td>Reaction</td> </tr> </thead> <tbody> <tr> <td>Doxycycline</td> <td>Hives</td> </tr> </tbody> </table> </div> </text> </section> <section> <title value="Other Notes" /> <code> <coding> <system value="http://loinc.org" /> <code value="68608-9" /> <display value="Summary note" /> </coding> </code> <text> <status value="additional" /> <div xmlns="http://www.w3.org/1999/xhtml"> Other Notes </div> </text> <entry> <reference value="urn:uuid:753bd8a3-fe8f-4ab8-90fa-22db8360ede2" /> </entry> </section> </Composition> </resource> </entry> <entry> <fullUrl value="urn:uuid:753bd8a3-fe8f-4ab8-90fa-22db8360ede2" /> <resource> <Binary> <id value="753bd8a3-fe8f-4ab8-90fa-22db8360ede2" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-Binary" /> </meta> <contentType value="text/html" /> <data value="PGh0bWw+PGRpdj5UaGlzIGlzIHNvbWUgbm90ZXMgYWJvdXQgZGlzY2hhZ2Ugc3VtbWFyeTwvZGl2PjwvaHRtbD4=" /> </Binary> </resource> </entry> <entry> <fullUrl value="urn:uuid:618fdf59-4adb-457e-bdd7-45fbec1314fa" /> <resource> <PractitionerRole> <id value="618fdf59-4adb-457e-bdd7-45fbec1314fa" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-PractitionerRole" /> </meta> <practitioner> <reference value="urn:uuid:38acd262-088f-4290-8d81-1c42964949a6" /> </practitioner> <organization> <reference value="urn:uuid:6dda4680-6412-4c1c-aaa9-c98e587661c9" /> </organization> </PractitionerRole> </resource> </entry> <entry> <fullUrl value="urn:uuid:38acd262-088f-4290-8d81-1c42964949a6" /> <resource> <Practitioner> <id value="38acd262-088f-4290-8d81-1c42964949a6" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-Practitioner" /> </meta> <text> <status value="generated" /> <div xmlns="http://www.w3.org/1999/xhtml"> <p>Dr Adam Careful</p> </div> </text> <identifier> <system value="https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-license-physician" /> <value value="12345" /> </identifier> <name> <family value="Careful" /> <given value="Adam" /> <prefix value="Dr" /> </name> </Practitioner> </resource> </entry> <entry> <fullUrl value="urn:uuid:efdbe1ce-1b5a-40bd-a6a1-68160ebb4c09" /> <resource> <Patient> <id value="efdbe1ce-1b5a-40bd-a6a1-68160ebb4c09" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-Patient" /> </meta> <text> <status value="generated" /> <div xmlns="http://www.w3.org/1999/xhtml"> <h1>Eve Everywoman</h1> </div> </text> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="JHN" /> </coding> <text value="Ontario, Canada Personal Health Number" /> </type> <system value="https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-patient-hcn" /> <value value="6132001123" /> </identifier> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="MR" /> </coding> <text value="Brantford General" /> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-example1-uri" /> <value value="WSD00038991" /> </identifier> <active value="true" /> <name> <text value="Eve Everywoman" /> <family value="Everywoman1" /> <given value="Eve" /> </name> <telecom> <system value="phone" /> <value value="555-555-2003" /> <use value="work" /> </telecom> <gender value="female" /> <birthDate value="1955-01-06" /> <address> <use value="home" /> <line value="2222 Home Street" /> </address> </Patient> </resource> </entry> <entry> <fullUrl value="urn:uuid:9d074a84-a021-4c9e-9ff6-02650dc7985a" /> <resource> <Encounter> <id value="9d074a84-a021-4c9e-9ff6-02650dc7985a" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-Encounter" /> </meta> <text> <status value="generated" /> <div xmlns="http://www.w3.org/1999/xhtml"> Urgent inpatient encounter for Acute Asthmatic attack. Patient was discharged home </div> </text> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="VN" /> <display value="Visit number" /> </coding> </type> <system value="urn:oid:2.16.840.1.113883.3.239.23.42.121" /> <value value="S100" /> </identifier> <status value="finished" /> <class> <system value="http://terminology.hl7.org/CodeSystem/v3-ActCode" /> <code value="IMP" /> <display value="inpatient encounter" /> </class> <type> <coding> <system value="http://cihi.ca/fhir/CodeSystem/aac-admit-category" /> <code value="U" /> <display value="Urgent/emergent" /> </coding> </type> <subject> <reference value="urn:uuid:efdbe1ce-1b5a-40bd-a6a1-68160ebb4c09" /> </subject> <period> <start value="2025-01-28" /> <end value="2025-02-01" /> </period> </Encounter> </resource> </entry> <entry> <fullUrl value="urn:uuid:6dda4680-6412-4c1c-aaa9-c98e587661c9" /> <resource> <Organization> <id value="6dda4680-6412-4c1c-aaa9-c98e587661c9" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-accdr-profile-Organization" /> </meta> <identifier> <system value="urn:ietf:rfc:3986" /> <value value="urn:oid:2.16.840.1.113883.3.239.23.4" /> </identifier> <name value="Test Organization" /> </Organization> </resource> </entry> </Bundle> </resource> </entry> </Bundle>