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"> <type value="transaction" /> <entry> <fullUrl value="Organization/cdb1015c-0240-4d46-8f28-8fcedc60f281" /> <resource> <Organization> <id value="cdb1015c-0240-4d46-8f28-8fcedc60f281" /> <meta> <profile value="https://fhir.gevko.de/StructureDefinition/EMDAF_PR_Organization_Praxis|1.1.1" /> </meta> <name value="Medipolis" /> </Organization> </resource> <request> <method value="POST" /> <url value="Organization" /> </request> </entry> <entry> <fullUrl value="Patient/726152045" /> <resource> <Patient> <meta> <profile value="https://fhir.gevko.de/StructureDefinition/EMDAF_PR_Patient|1.1.1" /> </meta> <gender value="male" /> <managingOrganization> <reference value="Organization/cdb1015c-0240-4d46-8f28-8fcedc60f281" /> </managingOrganization> </Patient> </resource> <request> <method value="POST" /> <url value="Patient" /> </request> </entry> <entry> <fullUrl value="urn:uuid:a4e99d5b-606e-4ed3-8bd3-0115ffa271b9" /> <resource> <Medication> <meta> <profile value="https://fhir.gevko.de/StructureDefinition/EMDAF_PR_Medication_Wirkstoff|1.1.1" /> </meta> <code> <coding> <system value="https://fhir.kbv.de/CodeSystem/KBV_CS_ERP_Medication_Type" /> <code value="wirkstoff" /> <display value="Wirkstoff" /> </coding> <text value="IBUPROFEN 400 mg Apodiscounter Filmtabletten" /> </code> <status value="active" /> <ingredient> <itemCodeableConcept> <text value="IBUPROFEN" /> </itemCodeableConcept> </ingredient> </Medication> </resource> <request> <method value="POST" /> <url value="Medication" /> </request> </entry> <entry> <fullUrl value="urn:uuid:c9ce4216-1f6a-4d52-affc-b2af12f2a2f8" /> <resource> <MedicationStatement> <meta> <profile value="https://fhir.gevko.de/StructureDefinition/EMDAF_PR_MedicationStatement|1.1.1" /> </meta> <identifier> <system value="https://dtb-planer.comjoo.com/therapy" /> <value value="525eb8e0-487e-46b8-8f8c-4fe59bf44653" /> </identifier> <identifier> <system value="https://dtb-planer.comjoo.com/medication" /> <value value="a4e99d5b-606e-4ed3-8bd3-0115ffa271b9" /> </identifier> <status value="active" /> <medicationReference> <reference value="urn:uuid:a4e99d5b-606e-4ed3-8bd3-0115ffa271b9" /> </medicationReference> <subject> <reference value="Patient/726152045" /> </subject> </MedicationStatement> </resource> <request> <method value="POST" /> <url value="MedicationStatement" /> </request> </entry> <entry> <fullUrl value="urn:uuid:0b4b4132-a9d1-431a-850f-548c78dc2f4b" /> <resource> <AllergyIntolerance> <id value="0b4b4132-a9d1-431a-850f-548c78dc2f4b" /> <meta> <profile value="https://fhir.gevko.de/StructureDefinition/EMDAF_PR_AllergyIntolerance|1.1.1" /> </meta> <clinicalStatus> <coding> <system value="http://terminology.hl7.org/CodeSystem/allergyintolerance-clinical" /> <code value="active" /> <display value="Active" /> </coding> </clinicalStatus> <type value="intolerance" /> <category value="medication" /> <criticality value="low" /> <code> <coding> <system value="http://loinc.org" /> <code value="null" /> </coding> </code> <patient> <reference value="Patient/726152045" /> </patient> <recordedDate value="2022-01-18T11:00:00.000Z" /> <recorder> <reference value="Patient/726152045" /> </recorder> <asserter> <reference value="Patient/726152045" /> </asserter> <note> <text value="Durchfall eingestuft als: 1 (Werte: 0,1,2,3)" /> </note> </AllergyIntolerance> </resource> <request> <method value="POST" /> <url value="AllergyIntolerance" /> </request> </entry> <entry> <fullUrl value="urn:uuid:8b19c158-0189-45be-8f81-14bd6a70a407" /> <resource> <MedicationAdministration> <contained> <Medication> <id value="8b19c158-0189-45be-8f81-14bd6a70a407" /> </Medication> </contained> <status value="completed" /> <medicationReference> <reference value="#8b19c158-0189-45be-8f81-14bd6a70a407" /> </medicationReference> <subject> <reference value="Patient/726152045" /> </subject> <effectiveDateTime value="2022-01-17T11:00:00.000Z" /> <performer> <actor> <reference value="Patient/726152045" /> </actor> </performer> <reasonCode> <coding> <system value="http://medworx.io/fhir/CodeSystem/MedicationIntakeReasonMind" /> <code value="planned" /> </coding> </reasonCode> <dosage> <dose> <value value="100" /> <unit value="mg" /> <system value="http://unitsofmeasure.org" /> <code value="mg" /> </dose> </dosage> </MedicationAdministration> </resource> <request> <method value="POST" /> <url value="MedicationAdministration" /> </request> </entry> <entry> <fullUrl value="urn:uuid:a10a8892-30b6-4527-8260-486868bfd60b" /> <resource> <Observation> <id value="a10a8892-30b6-4527-8260-486868bfd60b" /> <status value="final" /> <code> <coding> <system value="http://loinc.org" /> <code value="null" /> </coding> </code> <subject> <reference value="Patient/726152045" /> </subject> <effectiveDateTime value="2022-01-19T11:00:00.000Z" /> <performer> <reference value="Patient/726152045" /> </performer> <valueQuantity> <value value="2" /> <unit value="mg" /> <system value="http://unitsofmeasure.org" /> <code value="mg" /> </valueQuantity> </Observation> </resource> <request> <method value="POST" /> <url value="Observation" /> </request> </entry> </Bundle>