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"> <entry> <resource> <Practitioner> <id value="43c77ece-0653-4f4b-b29f-f7e6ae397cb8" /> <identifier> <system value="http://mef.gov.it/cf" /> </identifier> <practitionerRole> <managingOrganization> <reference value="Organization/85996edf-3a1f-49cf-a5b2-0c6262be273a" /> </managingOrganization> <specialty> <coding> <system value="http://mef.gov.it/ts/tipo_medico" /> <code value="01" /> </coding> </specialty> </practitionerRole> </Practitioner> </resource> </entry> <entry> <resource> <Organization> <id value="85996edf-3a1f-49cf-a5b2-0c6262be273a" /> <identifier> <system value="http://salute.gov.it/ausl" /> <value value="080114" /> </identifier> </Organization> </resource> </entry> <entry> <resource> <Organization> <id value="6d3db1db-f90f-4707-b9f1-83163c0a2007" /> <identifier> <system value="http://salute.gov.it/ausl" /> <value value="080105" /> </identifier> </Organization> </resource> </entry> <entry> <resource> <Organization> <id value="94c2e2f8-7c90-421c-9a9f-8efdd789d50d" /> <identifier> <system value="http://salute.gov.it/ausl" /> <value value="080104" /> </identifier> </Organization> </resource> </entry> <entry> <resource> <Order> <contained> <Patient> <id value="1" /> <extension url="http://progetto-sole.it/fhir/assistito/dati_istat_nascita"> <extension url="http://progetto-sole.it/fhir/istat_comune"> <valueCoding> <system value="http://istat.it/comune" /> <code value="036023" /> <display value="MODENA" /> </valueCoding> </extension> <extension url="http://progetto-sole.it/fhir/istat_nazione"> <valueCoding> <system value="http://istat.it/nazione" /> <code value="100" /> </valueCoding> </extension> </extension> <extension url="http://progetto-sole.it/fhir/assistito/cittadinanza"> <extension url="http://progetto-sole.it/fhir/istat_nazione"> <valueCoding> <system value="http://istat.it/nazione" /> <code value="100" /> <display value="ITALIA" /> </valueCoding> </extension> </extension> <identifier> <system value="http://mef.gov.it/cf" /> <value value="SSSMNN75B01F257L" /> </identifier> <identifier> <system value="http://salute.regione.emilia-romagna.it/codice_sanitario" /> <value value="D078045" /> </identifier> <name> <family value="ASSISTITOPROVA" /> <given value="MODENA UNO" /> </name> <gender value="male" /> <birthDate value="1975-02-01" /> <address> <extension url="http://progetto-sole.it/fhir/istat_comune"> <valueCoding> <system value="http://istat.it/comune" /> <code value="036023" /> </valueCoding> </extension> <extension url="http://progetto-sole.it/fhir/istat_nazione"> <valueCoding> <system value="http://istat.it/nazione" /> <code value="100" /> </valueCoding> </extension> <use value="home" /> <line value="VIA RESIDENZA, 14" /> <city value="MODENA" /> <district value="MO" /> <postalCode value="41121" /> </address> <address> <extension url="http://progetto-sole.it/fhir/istat_comune"> <valueCoding> <system value="http://istat.it/comune" /> <code value="037006" /> </valueCoding> </extension> <extension url="http://progetto-sole.it/fhir/istat_nazione"> <valueCoding> <system value="http://istat.it/nazione" /> <code value="100" /> </valueCoding> </extension> <use value="temp" /> <line value="VIA DOMICILIO, 1" /> <city value="BOLOGNA" /> <district value="BO" /> <postalCode value="40125" /> </address> <contact> <telecom> <system value="email" /> <value value="modenauno@gmail.com" /> </telecom> <telecom> <system value="phone" /> <value value="3351358726" /> </telecom> </contact> <careProvider> <reference value="Organization/6d3db1db-f90f-4707-b9f1-83163c0a2007" /> </careProvider> <managingOrganization> <reference value="Organization/94c2e2f8-7c90-421c-9a9f-8efdd789d50d" /> </managingOrganization> </Patient> </contained> <contained> <DiagnosticOrder> <id value="orderDiagnosticOrder" /> <status value="proposed" /> <item> <code> <extension url="http://progetto-sole.it/fhir/progressivo_prestazione"> <valueInteger value="1" /> </extension> <coding> <system value="http://salute.regione.emilia-romagna.it/codifica_primaria_prestazione" /> <code value="0647.054" /> <display value="RX GOMITO dx" /> </coding> <coding> <system value="http://salute.regione.emilia-romagna.it/codifica_secondaria_prestazione" /> <code value="88.22" /> </coding> </code> </item> <item> <code> <extension url="http://progetto-sole.it/fhir/progressivo_prestazione"> <valueInteger value="2" /> </extension> <coding> <system value="http://salute.regione.emilia-romagna.it/codifica_primaria_prestazione" /> <code value="0650.001" /> <display value="RX BACINO" /> </coding> <coding> <system value="http://salute.regione.emilia-romagna.it/codifica_secondaria_prestazione" /> <code value="88.26" /> </coding> </code> </item> </DiagnosticOrder> </contained> <extension url="http://progetto-sole.it/fhir/posizione_ticket"> <valueCoding> <system value="http://salute.regione.emilia-romagna.it/posizione_ticket" /> <code value="04" /> </valueCoding> </extension> <extension url="http://progetto-sole.it/fhir/modulistica_prescrittiva"> <valueCoding> <system value="http://salute.regione.emilia-romagna.it/modulistica_prescrittiva" /> <code value="1" /> </valueCoding> </extension> <extension url="http://progetto-sole.it/fhir/regime_erogazione"> <valueCoding> <system value="http://salute.regione.emilia-romagna.it/regime_erogazione" /> <code value="01" /> </valueCoding> </extension> <identifier> <system value="http://mef.gov.it/ricetta" /> <value value="080A03001716551" /> </identifier> <identifier> <system value="http://progetto-sole.it/ricetta" /> <value value="114X201902061521" /> </identifier> <identifier> <system value="http://mef.gov.it/ricetta/cod_auth" /> <value value="060220191522036860000022825985" /> </identifier> <date value="2019-01-02" /> <subject> <reference value="#1" /> </subject> <source> <reference value="Practitioner/43c77ece-0653-4f4b-b29f-f7e6ae397cb8" /> </source> <reasonCodeableConcept> <coding> <system value="http://salute.gov.it/ICD9CM" /> <code value="592.0" /> <display value="QUESITO" /> </coding> </reasonCodeableConcept> <when> <code> <coding> <system value="http://mef.gov.it/ricetta/priorita" /> <code value="01" /> </coding> </code> </when> <detail> <reference value="#orderDiagnosticOrder" /> </detail> </Order> </resource> </entry> <entry> <resource> <Organization> <identifier> <system value="http://salute.gov.it/ausl" /> <value value="080105" /> </identifier> </Organization> </resource> </entry> <entry> <resource> <Parameters> <parameter> <name value="data_da" /> <valueDate value="2019-03-30" /> </parameter> <parameter> <name value="data_a" /> <valueDate value="2019-04-08" /> </parameter> </Parameters> </resource> </entry> <entry> <resource> <Practitioner> <identifier> <system value="http://salute.regione.emilia-romagna.it/operatore/username" /> <value value="operatore.prova.dxc" /> </identifier> <name> <family value="OPERATORE PROVA" /> <given value="MODENA UNO" /> </name> <practitionerRole> <managingOrganization> <reference value="Organization/6d3db1db-f90f-4707-b9f1-83163c0a2007" /> </managingOrganization> <role> <coding> <system value="http://salute.regione.emilia-romagna.it/operatore/ruolo" /> <display value="RUOLO TEST 2" /> </coding> </role> </practitionerRole> </Practitioner> </resource> </entry> </Bundle>