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="esempio-ricerca-sospensione" /> <type value="searchset" /> <timestamp value="2023-01-01T10:36:03Z" /> <total value="1" /> <entry> <fullUrl value="ServiceRequest/883ffc6a-98a8-11ed-a8fc-0242ac120002" /> <resource> <ServiceRequest> <id value="883ffc6a-98a8-11ed-a8fc-0242ac120002" /> <meta> <versionId value="1" /> <lastUpdated value="2023-01-01T10:36:03Z" /> <profile value="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLServiceRequestSospensioneADI" /> </meta> <identifier> <value value="0300780000001_S000002" /> </identifier> <basedOn> <reference value="CarePlan/365db2ec-973c-11ed-a8fc-0242ac120002" /> <display value="CarePlan Progetto Individuale" /> </basedOn> <requisition> <value value="1234567890" /> </requisition> <status value="on-hold" /> <intent value="directive" /> <subject> <reference value="Patient/b7807e00-9745-11ed-a8fc-0242ac120002" /> <display value="Mario Rossi" /> </subject> <occurrencePeriod> <start value="2022-01-01" /> <end value="2023-02-01" /> </occurrencePeriod> <reasonCode> <coding> <system value="https://fhir.siss.regione.lombardia.it/ValueSet/SIAD-MotiviSospensione" /> <code value="1" /> <display value="Ricovero in ospedale" /> </coding> </reasonCode> </ServiceRequest> </resource> <search> <mode value="match" /> </search> </entry> <entry> <fullUrl value="CarePlan/365db2ec-973c-11ed-a8fc-0242ac120002" /> <resource> <CarePlan> <id value="365db2ec-973c-11ed-a8fc-0242ac120002" /> <meta> <versionId value="1" /> <lastUpdated value="2023-01-11T08:32:56.239+01:00" /> <profile value="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLCarePlanProgettoIndividuale" /> </meta> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLCarePlanVersionePAI"> <valueUnsignedInt value="1" /> </extension> <identifier> <value value="PI-2023000000001" /> </identifier> <status value="active" /> <intent value="order" /> <subject> <reference value="Patient/b7807e00-9745-11ed-a8fc-0242ac120002" /> <display value="Mario Rossi" /> </subject> <encounter> <reference value="Encounter/c559333c-974f-11ed-a8fc-0242ac120002" /> <display value="Accesso" /> </encounter> <period> <start value="2023-01-15T08:32:56.239+01:00" /> </period> <created value="2023-01-11T08:32:56.239+01:00" /> <author> <reference value="Organization/c8f77b34-974f-11ed-a8fc-0242ac120002" /> <display value="ASST DELLA BRIANZA" /> </author> <contributor> <reference value="PractitionerRole/d711fc58-974f-11ed-a8fc-0242ac120002" /> <display value="Infermiere" /> </contributor> <addresses> <reference value="Condition/e243606c-974f-11ed-a8fc-0242ac120002" /> <display value="Patologia Primaria" /> </addresses> <addresses> <reference value="Condition/e028bc4c-b134-11ed-afa1-0242ac120002" /> <display value="Patologia Secondara" /> </addresses> <supportingInfo> <reference value="Observation/bnm18194-974f-11ed-a8fc-0242ac120002" /> <display value="Esito Valutazione" /> </supportingInfo> <goal> <reference value="Goal/eaa18194-974f-11ed-a8fc-0242ac120002" /> <display value="Obiettivi Salute" /> </goal> <activity> <reference> <reference value="MedicationRequest/088c489c-9750-11ed-a8fc-0242ac120002" /> <display value="Terapia farmacologica" /> </reference> </activity> <activity> <reference> <reference value="ServiceRequest/14aec1c2-9750-11ed-a8fc-0242ac120002" /> <display value="Servizi Socio Assistenziali" /> </reference> </activity> <note> <text value="Monitorare il soddisfacimento dell'obiettivo di salute almeno una volta al mese" /> </note> </CarePlan> </resource> <search> <mode value="include" /> </search> </entry> <entry> <fullUrl value="Patient/b7807e00-9745-11ed-a8fc-0242ac120002" /> <resource> <Patient> <id value="b7807e00-9745-11ed-a8fc-0242ac120002" /> <meta> <versionId value="1" /> <lastUpdated value="2023-01-01T10:36:03Z" /> <profile value="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientCittadino" /> </meta> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientCittadinanza"> <valueCode value="ITA" /> </extension> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientTitoloDiStudio"> <valueCodeableConcept> <coding> <system value="https://fhir.siss.regione.lombardia.it/ValueSet/SIAD-TitoloStudio" /> <code value="6" /> <display value="Laurea" /> </coding> </valueCodeableConcept> </extension> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientPosizioneDellaProfessione"> <valueCodeableConcept> <coding> <system value="https://fhir.siss.regione.lombardia.it/ValueSet/SIAD-PosizioneProfessione" /> <code value="01" /> <display value="imprenditore" /> </coding> </valueCodeableConcept> </extension> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientSituazionePensionistica"> <valueCodeableConcept> <coding> <system value="https://fhir.siss.regione.lombardia.it/ValueSet/SIAD-SituazionePensionistica" /> <code value="5" /> <display value="Invalidità" /> </coding> </valueCodeableConcept> </extension> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientLuogoDiNascita"> <valueCode value="015146" /> </extension> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientATSResidenza"> <valueCode value="030321" /> </extension> <extension url="https://fhir.siss.regione.lombardia.it/StructureDefinition/RLPatientTipologiaCittadino"> <valueCodeableConcept> <coding> <system value="https://fhir.siss.regione.lombardia.it/ValueSet/SIAD-CondizioneClinica" /> <code value="1" /> <display value="Paziente ordinario: utenza tipica" /> </coding> </valueCodeableConcept> </extension> <identifier> <system value="http://hl7.it/sid/codiceFiscale" /> <value value="RSSMRA80A01F205X" /> </identifier> <active value="true" /> <name> <family value="Rossi" /> <given value="Mario" /> </name> <gender value="male" /> <birthDate value="1980-01-01" /> <address> <use value="billing" /> <city value="015146" /> </address> <maritalStatus> <coding> <system value="https://fhir.siss.regione.lombardia.it/ValueSet/SIAD-StatoCivile" /> <code value="2" /> <display value="Coniugato/a" /> </coding> </maritalStatus> <generalPractitioner> <reference value="PractitionerRole/0bfe5406-9751-11ed-a8fc-0242ac120002" /> <display value="Medico Prescrittore" /> </generalPractitioner> </Patient> </resource> <search> <mode value="include" /> </search> </entry> </Bundle>