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="8bee14db-df04-4b3b-8cae-1304d624f0a3" /> <meta> <versionId value="2" /> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedicationDispense" /> <tag> <display value="Close MedicationDispense reverse dispense" /> </tag> <tag> <display value="An instance of MedicationDispense" /> </tag> <tag> <display value="close-medicationdispense-example-1" /> </tag> </meta> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLBenefitChoiceCode"> <valueCode value="R" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfPackagesDispensed"> <valuePositiveInt value="2" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDeductedQuantity"> <valueDecimal value="100.0" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLActorDispatchId"> <valueString value="10431431715" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispatchId"> <valueString value="10431431716" /> </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:07:35+02:00" /> </extension> </extension> <status value="cancelled" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <code value="20080507100681" /> </coding> </medicationCodeableConcept> <authorizingPrescription> <reference value="MedicationRequest/c7005500-a251-4135-aa27-f2d808b729b6/_history/2" /> </authorizingPrescription> <type> <coding> <system value="http://ehalsomyndigheten.se/fhir/CodeSystem/library" /> <code value="SP" /> </coding> </type> <quantity> <value value="200.0" /> </quantity> <whenHandedOver value="2022-04-25T15:07:30+02:00" /> <note> <text value="Expedierat 10 mg pga. rest." /> </note> <dosageInstruction> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDosageType"> <valueCode value="TILLFALLESDOSERING" /> </extension> <sequence value="1" /> <patientInstruction value="2 tabletter på kvällen." /> <timing> <repeat> <when value="EVE" /> </repeat> </timing> <asNeededBoolean value="false" /> <doseAndRate> <doseQuantity> <value value="2.0" /> <system value="http://ehalsomyndigheten.se/fhir/CodeSystem/ehm-ucum-annotations" /> <code value="{tbl}" /> </doseQuantity> </doseAndRate> </dosageInstruction> <substitution> <wasSubstituted value="true" /> </substitution> </MedicationDispense>