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="UC4-2-Prescription-Request-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:c80f6c55-92f8-4518-ba66-cb193da09336" /> </identifier> <type value="message" /> <timestamp value="2025-05-14T08:15:12+02:00" /> <entry> <fullUrl value="http://erp-servicerequest-test.de/MessageHeader/UC4-2-Practitioner-to-Pharmacy-MessageHeader" /> <resource> <MessageHeader> <id value="UC4-2-Practitioner-to-Pharmacy-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_ParenteraleZubereitung;Rezeptbestaetigung" /> </eventCoding> <destination> <name value="Test Apotheke" /> <endpoint value="mailto:pharmacy@test.kim.dee" /> </destination> <sender> <identifier> <system value="https://gematik.de/fhir/sid/telematik-id" /> <value value="1-test-telematik-id" /> </identifier> <display value="Praxis Hans Topp-Glücklich" /> </sender> <source> <name value="Practitioner-Source" /> <software value="Practitioner-Software" /> <version value="1.0.0" /> <contact> <system value="email" /> <value value="info@pvs_solutions.email" /> </contact> <endpoint value="https://pvs_solutions.com/jira_helpdesk" /> </source> <responsible> <reference value="Organization/Example-Practitioner-Organization" /> </responsible> <focus> <reference value="ServiceRequest/UC4-Response-Prescription-Request" /> </focus> </MessageHeader> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/Organization/Example-Practitioner-Organization" /> <resource> <Organization> <id value="Example-Practitioner-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.50" /> <display value="Betriebsstätte Arzt" /> </coding> </type> <name value="Test Arztpraxis" /> <address> <type value="both" /> <line value="Musterarztstr. 3" /> <city value="Berlin" /> <postalCode value="10623" /> </address> <contact> <telecom> <system value="phone" /> <value value="0307654321" /> </telecom> </contact> </Organization> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/ServiceRequest/UC4-Response-Prescription-Request" /> <resource> <ServiceRequest> <id value="UC4-Response-Prescription-Request" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-prescription-request" /> </meta> <extension url="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/eprescription-token-ex"> <valueIdentifier> <system value="https://gematik.de/fhir/erp/sid/NamingSystemEPrescriptionToken" /> <value value="Task/169.100.000.000.004.36/$accept?ac=777bea0e13cc9c42ceec14aec3ddee2263325dc2c6c699db115f58fe423607ea" /> </valueIdentifier> </extension> <identifier> <system value="https://gematik.de/fhir/erp-servicerequest/sid/RequestIdentifier" /> <value value="1" /> </identifier> <identifier> <system value="https://gematik.de/fhir/erp-servicerequest/sid/patient-id" /> <value value="Patient-ID-e15232e9-01e0-4ce8-b628-71adb9023b21" /> </identifier> <identifier> <system value="https://gematik.de/fhir/erp-servicerequest/sid/case-id" /> <value value="Case-ID-85d39ff7-2f02-4bfc-85d5-0ba2752f6076" /> </identifier> <identifier> <system value="https://gematik.de/fhir/erp-servicerequest/sid/process-id" /> <value value="Process-ID-db6fd21d-cc85-4411-8567-479a7dc1ef74" /> </identifier> <identifier> <system value="https://my-very-own-zyto-identifier" /> <value value="My-ID-bdbdf8a1-ffa4-4f16-a6c4-38e690ac5548" /> </identifier> <basedOn> <reference value="MedicationRequest/Example-Zyto-Medication-Request" /> </basedOn> <requisition> <system value="https://gematik.de/fhir/erp-servicerequest/sid/ProcedureIdentifier" /> <value value="GroupID-UC4" /> </requisition> <status value="completed" /> <intent value="order" /> <code> <coding> <system value="https://gematik.de/fhir/erp-servicerequest/CodeSystem/service-request-type-cs" /> <code value="prescription-request" /> </coding> </code> <subject> <reference value="Patient/Example-Patient" /> </subject> <authoredOn value="2025-05-13" /> <performer> <reference value="Practitioner/Example-Practitioner" /> </performer> </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/Practitioner/Example-Practitioner" /> <resource> <Practitioner> <id value="Example-Practitioner" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-practitioner" /> <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="1-838382202" /> </identifier> <identifier> <system value="https://fhir.kbv.de/NamingSystem/KBV_NS_Base_ANR" /> <value value="838382202" /> </identifier> <name> <use value="official" /> <text value="Dr. med. Hans Topp-Glücklich" /> <family value="Topp-Glücklich" /> <given value="Hans" /> <prefix value="Dr. med." /> </name> </Practitioner> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/MedicationRequest/Example-Zyto-Medication-Request" /> <resource> <MedicationRequest> <id value="Example-Zyto-Medication-Request" /> <meta> <profile value="https://gematik.de/fhir/erp-servicerequest/StructureDefinition/erp-service-request-medication-request" /> </meta> <status value="active" /> <intent value="order" /> <medicationReference> <reference value="Medication/Example-Zyto-Medication" /> </medicationReference> <subject> <reference value="Patient/Example-Patient" /> </subject> <authoredOn value="2022-05-20" /> <substitution> <allowedBoolean value="false" /> </substitution> </MedicationRequest> </resource> </entry> <entry> <fullUrl value="http://erp-servicerequest-test.de/Medication/Example-Zyto-Medication" /> <resource> <Medication> <id value="Example-Zyto-Medication" /> <meta> <profile value="https://fhir.kbv.de/StructureDefinition/KBV_PR_ERP_Medication_Compounding|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="373873005:860781008=362943005" /> <display value="Pharmaceutical / biologic product (product) : Has product characteristic (attribute) = Manual method (qualifier value)" /> </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> <code> <coding> <system value="https://fhir.kbv.de/CodeSystem/KBV_CS_ERP_Medication_Type" /> <code value="rezeptur" /> </coding> </code> <form> <text value="Infusionslösung" /> </form> <amount> <numerator> <extension url="https://fhir.kbv.de/StructureDefinition/KBV_EX_ERP_Medication_PackagingSize"> <valueString value="500" /> </extension> <unit value="ml" /> </numerator> <denominator> <value value="1" /> </denominator> </amount> <ingredient> <itemCodeableConcept> <text value="Etoposid" /> </itemCodeableConcept> <strength> <numerator> <value value="180" /> <unit value="mg" /> </numerator> <denominator> <value value="1" /> </denominator> </strength> </ingredient> <ingredient> <itemCodeableConcept> <text value="NaCl 0,9 %" /> </itemCodeableConcept> <strength> <numerator> <value value="500" /> <unit value="ml" /> </numerator> <denominator> <value value="1" /> </denominator> </strength> </ingredient> </Medication> </resource> </entry> </Bundle>