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="6d972fbd-7718-43b8-9cce-40167648aec6" /> <meta> <lastUpdated value="2022-10-03T11:31:54.380+02:00" /> <tag> <display value="Fetch MedicationDispense" /> </tag> <tag> <display value="Bundle of type searchset" /> </tag> <tag> <display value="fetch-medicationdispense-example-1" /> </tag> </meta> <type value="searchset" /> <total value="2" /> <link> <relation value="self" /> <url value="https://test.ehalsomyndigheten.se/fhir/MedicationDispense?medicationrequest._id=bba77438-41ed-45f8-843c-c25f6f7b20a1" /> </link> <entry> <fullUrl value="https://test.ehalsomyndigheten.se/fhir/MedicationDispense/8bee14db-df04-4b3b-8cae-1304d624f0a3" /> <resource> <MedicationDispense> <id value="8bee14db-df04-4b3b-8cae-1304d624f0a3" /> <meta> <versionId value="1" /> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedicationDispense" /> </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/NLLActorDispatchId"> <valueString value="10431453639" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispatchId"> <valueString value="10431453640" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispatchRowNo"> <valueDecimal value="1" /> </extension> <status value="completed" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <code value="20080507100681" /> </coding> </medicationCodeableConcept> <authorizingPrescription> <reference value="MedicationRequest/bba77438-41ed-45f8-843c-c25f6f7b20a1/_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-10-01T11:31:46+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> </resource> </entry> <entry> <fullUrl value="https://test.ehalsomyndigheten.se/fhir/MedicationDispense/9d6acb34-de4d-448c-be5e-57716732e3aa" /> <resource> <MedicationDispense> <id value="9d6acb34-de4d-448c-be5e-57716732e3aa" /> <meta> <versionId value="1" /> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedicationDispense" /> </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/NLLActorDispatchId"> <valueString value="2" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispatchId"> <valueString value="10431453638" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDispatchRowNo"> <valueDecimal value="1" /> </extension> <status value="completed" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <code value="20080507100681" /> </coding> </medicationCodeableConcept> <authorizingPrescription> <reference value="MedicationRequest/bba77438-41ed-45f8-843c-c25f6f7b20a1/_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-10-01T11:31:46+02:00" /> <note> <text value="uttag 2" /> </note> <substitution> <wasSubstituted value="false" /> </substitution> </MedicationDispense> </resource> </entry> </Bundle>