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="NotifyAddAppointmentBundle" /> <type value="message" /> <timestamp value="2020-10-09T15:21:51.2112Z" /> <entry> <fullUrl value="urn:uuid:a84085db-7bc2-49fe-b965-36892d7fa344" /> <resource> <MessageHeader> <id value="a84085db-7bc2-49fe-b965-36892d7fa344" /> <eventCoding> <system value="http://fhir.infoway-inforoute.ca/io/CA-eReC/CodeSystem/message-event-code" /> <code value="notify-add-appointment" /> </eventCoding> <destination> <name value="RMS Source" /> <endpoint value="http://rmssource.org/fhir/$process-message" /> </destination> <author> <reference value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" /> <display value="April May" /> </author> <source> <name value="RMS Target" /> <software value="Software" /> <version value="1.1.0" /> <contact> <system value="email" /> <value value="tech.support@rmstarget.org" /> <rank value="1" /> </contact> <endpoint value="http://rmstarget.org/fhir/$process-message" /> </source> <reason> <text value="Booked" /> </reason> <focus> <reference value="urn:uuid:75e61024-0d19-11ed-861d-0242ac120002" /> </focus> <focus> <reference value="urn:uuid:e96979b6-0d67-11ed-861d-0272ac420003" /> </focus> </MessageHeader> </resource> </entry> <entry> <fullUrl value="urn:uuid:75e61024-0d19-11ed-861d-0242ac120002" /> <resource> <Appointment> <id value="75e61024-0d19-11ed-861d-0242ac120002" /> <status value="pending" /> <appointmentType> <text value="Surgery" /> </appointmentType> <description value="Surgery appointment pending" /> <start value="2020-10-11T09:00:00Z" /> <end value="2020-10-11T10:00:00Z" /> <created value="2020-10-10" /> <basedOn> <identifier> <system value="http://www.rmssource.org/identifiers/ServiceRequest" /> <value value="request-for-assessment" /> </identifier> </basedOn> <participant> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v3-ParticipationType" /> <code value="PART" /> </coding> </type> <actor> <reference value="urn:uuid:7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" /> <display value="Jane Doe" /> </actor> <required value="required" /> <status value="accepted" /> </participant> <participant> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v3-ParticipationType" /> <code value="PART" /> </coding> </type> <actor> <reference value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" /> <display value="April May" /> </actor> <required value="required" /> <status value="accepted" /> </participant> </Appointment> </resource> </entry> <entry> <fullUrl value="urn:uuid:e96979b6-0d67-11ed-861d-0272ac420003" /> <resource> <Task> <id value="e96979b6-0d67-11ed-861d-0272ac420003" /> <basedOn> <identifier> <system value="http://www.rmssource.org/identifiers/ServiceRequest" /> <value value="request-for-assessment" /> </identifier> </basedOn> <status value="accepted" /> <businessStatus> <coding> <system value="http://fhir.infoway-inforoute.ca/io/CA-eReC/CodeSystem/task-business-status" /> <code value="BOK" /> <display value="Booked" /> </coding> <text value="Ready for Intake" /> </businessStatus> <intent value="proposal" /> <code> <coding> <system value="http://fhir.infoway-inforoute.ca/io/CA-eReC/CodeSystem/task-code" /> <code value="manage-request" /> </coding> <text value="Request for information" /> </code> <description value="More information is needed, please provide x." /> <authoredOn value="2020-10-10T18:40:36Z" /> <lastModified value="2020-10-10T18:40:36Z" /> </Task> </resource> </entry> <entry> <fullUrl value="urn:uuid:7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" /> <resource> <Patient> <id value="7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" /> <identifier> <use value="official" /> <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="1234567890" /> </identifier> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="MR" /> </coding> <text value="The Hospital" /> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-example1-uri" /> <value value="ABC12345" /> </identifier> <active value="true" /> <name> <family value="Doe" /> <given value="Jane" /> </name> <gender value="female" /> <birthDate value="1951-02-19" /> </Patient> </resource> </entry> <entry> <fullUrl value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571d8a" /> <resource> <PractitionerRole> <id value="86fa8373-34c8-440d-9e8f-832c1a571d8a" /> <active value="true" /> <practitioner> <reference value="urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc79e" /> <display value="Dr Jack Jones" /> </practitioner> <organization> <reference value="urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc7e4" /> <display value="Primary Care Medical Clinics" /> </organization> <code> <coding> <system value="http://terminology.hl7.org/CodeSystem/practitioner-role" /> <code value="doctor" /> <display value="Doctor" /> </coding> </code> <specialty> <coding> <system value="https://fhir.infoway-inforoute.ca/CodeSystem/snomedctcaextension" /> <code value="394802001" /> <display value="General medicine" /> </coding> </specialty> <location> <reference value="urn:uuid:25470f9e-0092-4997-af53-aa3ef0f50879" /> <display value="279 Yonge St, Barrie, ON L4N 7T9" /> </location> <telecom> <system value="phone" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <telecom> <system value="fax" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="3" /> </telecom> <telecom> <system value="email" /> <value value="jack.jones@example.org" /> <use value="work" /> <rank value="2" /> </telecom> </PractitionerRole> </resource> </entry> <entry> <fullUrl value="urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc79e" /> <resource> <Practitioner> <id value="8b9f61af-55ce-4ade-9987-f40fe54cc79e" /> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="LN" /> </coding> <text value="Ontario Medical License Number" /> </type> <system value="http://infoway-inforoute.ca/fhir/NamingSystem/ca-on-license-physician" /> <value value="111789" /> </identifier> <name> <use value="official" /> <family value="Jones" /> <given value="Jack" /> </name> </Practitioner> </resource> </entry> <entry> <fullUrl value="urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc7e4" /> <resource> <Organization> <id value="334ec4c8-7932-4620-86fe-d6b33b3fc7e4" /> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/organization-type" /> <code value="prov" /> <display value="Healthcare Provider" /> </coding> </type> <name value="Primary Care Medical Clinics" /> </Organization> </resource> </entry> <entry> <fullUrl value="urn:uuid:25470f9e-0092-4997-af53-aa3ef0f50879" /> <resource> <Location> <id value="25470f9e-0092-4997-af53-aa3ef0f50879" /> <name value="Yonge Street Medical Office" /> <address> <type value="physical" /> <line value="279 Yonge St" /> <city value="Barrie" /> <state value="ON" /> <postalCode value="M5B 1N8" /> <country value="CAN" /> </address> </Location> </resource> </entry> <entry> <fullUrl value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" /> <resource> <PractitionerRole> <id value="86fa8373-34c8-440d-9e8f-832c1a571da8" /> <active value="true" /> <practitioner> <reference value="urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc7e9" /> <display value="April May" /> </practitioner> <organization> <reference value="urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc74e" /> <display value="South East LHIN" /> </organization> <telecom> <system value="phone" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <telecom> <system value="email" /> <value value="april.may@example.org" /> <use value="work" /> <rank value="2" /> </telecom> </PractitionerRole> </resource> </entry> <entry> <fullUrl value="urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc7e9" /> <resource> <Practitioner> <id value="8b9f61af-55ce-4ade-9987-f40fe54cc7e9" /> <name> <use value="official" /> <family value="May" /> <given value="April" /> </name> </Practitioner> </resource> </entry> <entry> <fullUrl value="urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc74e" /> <resource> <Organization> <id value="334ec4c8-7932-4620-86fe-d6b33b3fc74e" /> <identifier> <use value="official" /> <system value="https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-health-care-facility-id" /> <value value="4664" /> </identifier> <active value="true" /> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/organization-type" /> <code value="prov" /> <display value="Healthcare Provider" /> </coding> </type> <name value="South East LHIN" /> </Organization> </resource> </entry> </Bundle>