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="pcr-match-response-bundle-example" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-pcr-profile-Bundle|2.0.0" /> </meta> <type value="searchset" /> <total value="1" /> <link> <relation value="self" /> <url value="https://ehealthontario.ca/api/fhir/Patient/$match" /> </link> <entry> <fullUrl value="https://ehealthontario.ca/api/fhir/Patient/1752" /> <resource> <Patient> <id value="1752" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-pcr-profile-Patient|2.0.0" /> <security> <system value="http://terminology.hl7.org/CodeSystem/v3-Confidentiality" /> <code value="N" /> <display value="normal" /> </security> <tag> <system value="http://terminology.hl7.org/CodeSystem/v3-ObservationValue" /> <code value="SUBSETTED" /> <display value="subsetted" /> </tag> </meta> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="RRI" /> </coding> <text value="eHealth Ontario Enterprise Identifier" /> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-pcr-eid" /> <value value="1752" /> </identifier> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="MR" /> </coding> <text value="University Health Network" /> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-example-uri" /> <value value="1023" /> </identifier> <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="6210003809" /> </identifier> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="MR" /> </coding> <text value="University Health" /> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-example1-uri" /> <value value="1023" /> </identifier> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="JHN" /> </coding> <text value="British Columbia, Personal Health Number" /> </type> <system value="https://fhir.infoway-inforoute.ca/NamingSystem/ca-bc-patient-healthcare-id" /> <value value="567894" /> </identifier> <name> <use value="official" /> <family value="WILSON" /> <given value="WOODROW" /> <given value="SAMUEL"> <extension url="http://hl7.org/fhir/StructureDefinition/iso21090-EN-qualifier"> <valueCode value="MID" /> </extension> </given> <prefix value="Mr" /> <suffix value="JR" /> </name> <telecom> <system value="phone" /> <value value="+1-613-555-7777 ext.123" /> <use value="home" /> </telecom> <gender value="male" /> <birthDate value="1955-07-01" /> <address> <use value="home" /> <type value="physical" /> <line value="300-30 1/2 MAIN ST W" /> <line value="NEXT LINE" /> <city value="BELLEVILLE" /> <state value="ON" /> <postalCode value="K5K2T7" /> <country value="CAN" /> </address> <address> <use value="home" /> <type value="postal" /> <line value="345 Queen str W" /> <line value="unit 53" /> <city value="Toronto" /> <state value="ON" /> <postalCode value="M4H6T2" /> <country value="CAN" /> </address> </Patient> </resource> <search> <mode value="match" /> <score value="44" /> </search> </entry> </Bundle>