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.
<MedicationRequest xmlns="http://hl7.org/fhir"> <id value="50556" /> <meta> <versionId value="ticks/637689361643670000" /> <lastUpdated value="2021-10-04T09:22:44.367+02:00" /> <profile value="http://nictiz.nl/fhir/StructureDefinition/zib-MedicationAgreement" /> </meta> <extension url="http://nictiz.nl/fhir/StructureDefinition/zib-Medication-PeriodOfUse"> <valuePeriod> <start value="2021-10-04T09:22:44.39+02:00" /> <end value="2021-10-31T00:00:00+02:00" /> </valuePeriod> </extension> <extension url="http://nictiz.nl/fhir/StructureDefinition/zib-MedicationUse-Duration"> <valueDuration> <value value="26.6092084490741" /> <unit value="day" /> <system value="http://unitsofmeasure.org" /> <code value="d" /> </valueDuration> </extension> <status value="active" /> <intent value="order" /> <category> <coding> <system value="http://hl7.org/fhir/medication-request-category" /> <code value="inpatient" /> </coding> </category> <medicationReference> <reference value="Medication/ArticleGroup.3931" /> <display value="PARACETAMOL KAUWTABLET 120MG" /> </medicationReference> <subject> <reference value="Patient/20422306" /> <display value="Engel" /> </subject> <authoredOn value="2021-10-04T10:22:44.367+02:00" /> <requester> <agent> <reference value="User/3975" /> <display value="_michael" /> </agent> </requester> <note> <text value="Volg schema" /> </note> <dosageInstruction> <additionalInstruction> <coding> <system value="https://referentiemodel.nhg.org/tabellen/nhg-tabel-25-gebruiksvoorschrift#aanvullend-numeriek" /> <code value="193" /> </coding> <text value="De tablet mag worden fijngemalen" /> </additionalInstruction> <timing> <repeat> <boundsPeriod> <start value="2021-10-04T09:22:44.39+02:00" /> <end value="2021-10-31T00:00:00+02:00" /> </boundsPeriod> <frequency value="1" /> <period value="1.00" /> <periodUnit value="d" /> <timeOfDay value="12:00" /> </repeat> </timing> <asNeededCodeableConcept> <coding> <system value="https://referentiemodel.nhg.org/tabellen/nhg-tabel-25-gebruiksvoorschrift#aanvullend-numeriek" /> <code value="1137" /> </coding> <text value="zo nodig" /> </asNeededCodeableConcept> <route> <coding> <system value="urn:oid:2.16.840.1.113883.2.4.4.9" /> <code value="9" /> </coding> <text value="ORAAL" /> </route> <doseQuantity> <value value="1.00" /> <unit value="STUK" /> <system value="urn:oid:2.16.840.1.113883.2.4.4.1.900.2" /> <code value="245" /> </doseQuantity> </dosageInstruction> </MedicationRequest>