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="UC1-4-Alt-Delivery-Fullfilled-DispenseRequest-To-Pharmacy" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-message-container" /> </meta> <identifier> <system value="urn:ietf:rfc:3986" /> <value value="urn:uuid:ebad657e-589f-4386-ad81-19352ca21310" /> </identifier> <type value="message" /> <timestamp value="2025-05-14T08:30:12+02:00" /> <entry> <fullUrl value="http://erp-servicerequest-test.de/MessageHeader/UC1-Alt-Delivery-Pharmacy-to-HealthCareService-MessageHeader" /> <resource> <MessageHeader> <id value="UC1-Alt-Delivery-Pharmacy-to-HealthCareService-MessageHeader" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-request-header" /> </meta> <eventCoding> <system value="https://gematik.de/fhir/atf/CodeSystem/service-identifier-cs" /> <code value="eRezept_Rezeptanforderung;Abgabebestaetigung" /> </eventCoding> <destination> <name value="Pflegeheim Immergrün" /> <endpoint value="mailto:healthcare-service@test.kim.de" /> </destination> <sender> <identifier> <system value="https://gematik.de/fhir/sid/telematik-id" /> <value value="3-test-telematik-id" /> </identifier> <display value="Test Apotheke" /> </sender> <source> <name value="Pharmacy-Source" /> <software value="Pharmacy-Software" /> <version value="1.0.0" /> <contact> <system value="email" /> <value value="info@avs_solutions.com" /> </contact> <endpoint value="https://avs_solutions.com/jira_helpdesk" /> </source> <responsible> <reference value="Organization/Example-Pharmacy-Organization" /> </responsible> <focus> <reference value="ServiceRequest/UC1-Alt-Delivery-Response-Dispense-Request" /> </focus> </MessageHeader> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/Organization/Example-Pharmacy-Organization" /> <resource> <Organization> <id value="Example-Pharmacy-Organization" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-organization" /> <tag> <system value="https://gematik.de/fhir/directory/CodeSystem/Origin" /> <code value="owner" /> </tag> </meta> <identifier> <system value="https://gematik.de/fhir/sid/telematik-id" /> <value value="123456789" /> </identifier> <type> <coding> <system value="https://gematik.de/fhir/directory/CodeSystem/OrganizationProfessionOID" /> <code value="1.2.276.0.76.4.54" /> <display value="Öffentliche Apotheke" /> </coding> </type> <name value="Test Apotheke" /> <address> <type value="both" /> <line value="Musterstr. 2" /> <city value="Berlin" /> <postalCode value="10623" /> </address> <contact> <telecom> <system value="phone" /> <value value="0301234567" /> </telecom> </contact> </Organization> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/ServiceRequest/UC1-Alt-Delivery-Response-Dispense-Request" /> <resource> <ServiceRequest> <id value="UC1-Alt-Delivery-Response-Dispense-Request" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-dispense-request" /> </meta> <identifier> <system value="https://gematik.de/fhir/erp-servicerequest/sid/RequestIdentifier" /> <value value="2" /> </identifier> <requisition> <system value="https://gematik.de/fhir/erp-servicerequest/sid/ProcedureIdentifier" /> <value value="GroupID-UC1" /> </requisition> <status value="completed" /> <intent value="filler-order" /> <code> <coding> <system value="https://gematik.de/fhir/erp-servicerequest/CodeSystem/service-request-type-cs" /> <code value="dispense-request" /> </coding> <coding> <system value="https://gematik.de/fhir/erp-servicerequest/CodeSystem/delivery-type-cs" /> <code value="delivery-to-alternative-address" /> </coding> </code> <subject> <reference value="Patient/Example-Patient" /> </subject> <authoredOn value="2025-05-14" /> <supportingInfo> <reference value="MedicationDispense/UC1-Medication-Dispense" /> <type value="MedicationDispense" /> </supportingInfo> <note> <time value="2025-05-14T08:27:05+02:00" /> <text value="Lagert vor Ort. Kommt mit Extra Botendienst." /> </note> </ServiceRequest> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/Patient/Example-Patient" /> <resource> <Patient> <id value="Example-Patient" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-patient" /> </meta> <identifier> <system value="http://fhir.de/sid/gkv/kvid-10" /> <value value="X234567890" /> </identifier> <name> <use value="official" /> <family value="Königsstein"> <extension url="http://hl7.org/fhir/StructureDefinition/humanname-own-name"> <valueString value="Königsstein" /> </extension> </family> <given value="Ludger" /> </name> <birthDate value="1935-06-22" /> <address> <type value="both" /> <line value="Musterstr. 1"> <extension url="http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-houseNumber"> <valueString value="1" /> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-streetName"> <valueString value="Musterstr." /> </extension> </line> <city value="Berlin" /> <postalCode value="10623" /> </address> </Patient> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/MedicationDispense/UC1-Medication-Dispense" /> <resource> <MedicationDispense> <id value="UC1-Medication-Dispense" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-medication-dispense" /> </meta> <identifier> <system value="https://gematik.de/fhir/erp/NamingSystem/GEM_ERP_NS_PrescriptionId" /> <value value="169.100.000.000.002.36" /> </identifier> <status value="completed" /> <medicationReference> <reference value="Medication/Example-Initial-Medication" /> </medicationReference> <subject> <reference value="Patient/Example-Patient" /> </subject> <quantity> <value value="1" /> <unit value="Packung" /> </quantity> <dosageInstruction> <text value="1-1-1-0" /> </dosageInstruction> </MedicationDispense> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/Medication/Example-Initial-Medication" /> <resource> <Medication> <id value="Example-Initial-Medication" /> <meta> <profile value="https://fhir.kbv.de/StructureDefinition/KBV_PR_ERP_Medication_PZN|1.1.0" /> </meta> <extension url="https://fhir.kbv.de/StructureDefinition/KBV_EX_Base_Medication_Type"> <valueCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <version value="http://snomed.info/sct/900000000000207008/version/20220331" /> <code value="763158003" /> <display value="Medicinal product (product)" /> </coding> </valueCodeableConcept> </extension> <extension url="https://fhir.kbv.de/StructureDefinition/KBV_EX_ERP_Medication_Category"> <valueCoding> <system value="https://fhir.kbv.de/CodeSystem/KBV_CS_ERP_Medication_Category" /> <code value="00" /> </valueCoding> </extension> <extension url="https://fhir.kbv.de/StructureDefinition/KBV_EX_ERP_Medication_Vaccine"> <valueBoolean value="false" /> </extension> <extension url="http://fhir.de/StructureDefinition/normgroesse"> <valueCode value="N1" /> </extension> <code> <coding> <system value="http://fhir.de/CodeSystem/ifa/pzn" /> <code value="08585997" /> </coding> <text value="Prospan® Hustensaft 100ml" /> </code> <form> <coding> <system value="https://fhir.kbv.de/CodeSystem/KBV_CS_SFHIR_KBV_DARREICHUNGSFORM" /> <code value="FLE" /> </coding> </form> </Medication> </resource> </entry> </Bundle>