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.
<MedicationDispense xmlns="http://hl7.org/fhir"> <id value="30a7f4c5-8d6f-4ba2-bcf6-6bbe04f02210" /> <meta> <versionId value="1" /> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedicationDispense" /> <tag> <display value="Close MedicationDispense credit dispense" /> </tag> <tag> <display value="An instance of MedicationDispense" /> </tag> <tag> <display value="close-medicationdispense-example-2" /> </tag> </meta> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLBenefitChoiceCode"> <valueCode value="R" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfPackagesDispensed"> <valuePositiveInt value="1" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLActorDispatchId"> <valueString value="10431431717" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispatchId"> <valueString value="10431431718" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispatchRowNo"> <valueDecimal value="1" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispenseCrediting"> <extension url="creditDate"> <valueDateTime value="2022-04-27T15:10:58+02:00" /> </extension> <extension url="creditDispatchId"> <valueString value="10431431720" /> </extension> </extension> <status value="cancelled" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <code value="19801001100168" /> </coding> </medicationCodeableConcept> <authorizingPrescription> <reference value="MedicationRequest/cab58f43-b4f0-4211-8812-0fedace40274/_history/2" /> </authorizingPrescription> <type> <coding> <system value="http://ehalsomyndigheten.se/fhir/CodeSystem/library" /> <code value="SP" /> </coding> </type> <quantity> <value value="14.0" /> </quantity> <whenHandedOver value="2022-04-25T15:07:32+02:00" /> <note> <text value="Plockat ut 6 tabletter. 14 st restad." /> </note> <dosageInstruction> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDosageType"> <valueCode value="FREKVENSDOSERING" /> </extension> <sequence value="1" /> <patientInstruction value="1 tablett 2 gånger dagligen i 7 dagar." /> <timing> <repeat> <boundsDuration> <value value="7" /> <unit value="dag" /> <system value="http://unitsofmeasure.org" /> <code value="d" /> </boundsDuration> <frequency value="2" /> <period value="1" /> <periodUnit value="d" /> </repeat> </timing> <asNeededBoolean value="false" /> <doseAndRate> <doseQuantity> <value value="1.0" /> <system value="http://ehalsomyndigheten.se/fhir/CodeSystem/ehm-ucum-annotations" /> <code value="{tbl}" /> </doseQuantity> </doseAndRate> </dosageInstruction> <substitution> <wasSubstituted value="false" /> </substitution> </MedicationDispense>