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.
<Patient xmlns="http://hl7.org/fhir"> <id value="2922" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/pcr-patient-response|2.0.0" /> <security> <system value="http://hl7.org/fhir/v3/Confidentiality" /> <code value="N" /> <display value="normal" /> </security> </meta> <identifier> <type> <coding> <system value="http://hl7.org/fhir/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="2922" /> </identifier> <identifier> <type> <coding> <system value="http://hl7.org/fhir/v2/0203" /> <code value="MR" /> </coding> <text value="Wait Time Information System" /> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-example-uri" /> <value value="FULL_PROFILE_LEN2" /> </identifier> <identifier> <type> <coding> <system value="http://hl7.org/fhir/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://hl7.org/fhir/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> <identifier> <type> <coding> <system value="http://hl7.org/fhir/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="1806194838" /> </identifier> <name> <use value="official" /> <family value="Maggageman" /> <given value="Maggager" /> <given value="Maggage car"> <extension url="http://hl7.org/fhir/StructureDefinition/iso21090-EN-qualifier"> <valueCode value="MID" /> </extension> </given> <prefix value="III" /> <suffix value="Jr" /> <suffix value="DDS"> <extension url="http://hl7.org/fhir/StructureDefinition/iso21090-EN-qualifier"> <valueCode value="AC" /> </extension> </suffix> </name> <name> <use value="usual" /> <family value="Magel" /> <given value="Magful" /> <given value="Maggage"> <extension url="http://hl7.org/fhir/StructureDefinition/iso21090-EN-qualifier"> <valueCode value="MID" /> </extension> </given> <prefix value="III" /> <suffix value="Jr" /> <suffix value="DDS"> <extension url="http://hl7.org/fhir/StructureDefinition/iso21090-EN-qualifier"> <valueCode value="AC" /> </extension> </suffix> </name> <telecom> <system value="phone" /> <value value="+20-980-500-1141 ext.1418" /> <use value="home" /> </telecom> <telecom> <system value="phone" /> <value value="+20-612-400-1139 ext.1688" /> <use value="mobile" /> </telecom> <telecom> <system value="phone" /> <value value="+20-754-100-1142 ext.781" /> <use value="work" /> </telecom> <telecom> <system value="phone" /> <value value="+20-313-500-1140 ext.1799" /> <use value="temp" /> </telecom> <telecom> <system value="email" /> <value value="Lagdad.beef burrito@wshome.com" /> <use value="home" /> </telecom> <telecom> <system value="email" /> <value value="Lagel.beef cattle@wshome.com" /> <use value="work" /> </telecom> <gender value="female" /> <birthDate value="1968-01-01" /> <deceasedDateTime value="2013-02-01" /> <address> <use value="home" /> <type value="physical" /> <line value="HomeAd HomeAddress.stName" /> <city value="Nobleton" /> <state value="ON" /> <postalCode value="K4A0K5" /> <country value="CAN" /> </address> <address> <use value="home" /> <type value="postal" /> <line value="Mailin MailingAddress.stName" /> <city value="Nobleton" /> <state value="ON" /> <postalCode value="K4A0K7" /> <country value="CAN" /> </address> <address> <use value="temp" /> <type value="physical" /> <line value="Tempor TemporaryHome.stName" /> <city value="Nobleton" /> <state value="ON" /> <postalCode value="K4A0K8" /> <country value="CAN" /> </address> <address> <use value="temp" /> <type value="postal" /> <line value="Tempor TemporaryMailing.stName" /> <city value="Nobleton" /> <state value="ON" /> <postalCode value="K4A0K9" /> <country value="CAN" /> </address> <multipleBirthInteger value="6" /> <contact> <relationship> <coding> <system value="http://hl7.org/fhir/v2/0131" /> <code value="C" /> <display value="Emergency Contact" /> </coding> </relationship> <telecom> <system value="phone" /> <value value="+20-905-300-1138 ext.1677" /> </telecom> </contact> <communication> <language> <coding> <system value="urn:ietf:bcp:47" /> <code value="fr" /> <display value="French" /> </coding> </language> <preferred value="true" /> </communication> </Patient>