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="3a4fcef3-57b9-476a-a419-b96ed790e3f7" /> <meta> <versionId value="1" /> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedicationRequest" /> <tag> <display value="Fetch MedicationRequest for medical consumables" /> </tag> <tag> <display value="Example of fetch prescription for medical consumables" /> </tag> <tag> <display value="fetch-medicationrequest-example-4" /> </tag> </meta> <contained> <Practitioner> <id value="1" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLPractitioner" /> </meta> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLWorkplaceSummary"> <extension url="workplaceIdentifier"> <valueString value="7711222222" /> </extension> <extension url="workplaceName"> <valueString value="Min vardcentral" /> </extension> <extension url="workplaceType"> <valueCode value="HEALTHCAREUNIT" /> </extension> <extension url="workplaceIdType"> <valueCode value="ORGNR" /> </extension> </extension> <name> <family value="Svensson" /> <given value="Gustav" /> </name> <telecom> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAvailableToPatient"> <valueBoolean value="false" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLContactPointType"> <valueCode value="P" /> </extension> <system value="phone" /> <value value="011-900000" /> <rank value="1" /> </telecom> <telecom> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAvailableToPatient"> <valueBoolean value="true" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLContactPointType"> <valueCode value="W" /> </extension> <system value="phone" /> <value value="011-900000" /> <rank value="1" /> </telecom> <address> <type value="postal" /> <line value="postGatan 133" /> <city value="stockholm" /> <postalCode value="12345" /> </address> <address> <type value="physical" /> <line value="fysiskaGatan 134" /> <city value="stockholm" /> <postalCode value="12345" /> </address> <qualification> <identifier> <system value="urn:oid:1.2.752.116.3.1.2" /> <value value="9000027" /> </identifier> <code> <coding> <system value="urn:oid:1.2.752.116.3.1.3" /> <code value="LK" /> </coding> </code> </qualification> </Practitioner> </contained> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriptionChain"> <valueUuid value="urn:uuid:fa7565ec-b5d1-456c-ad44-a3bbad03a165" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPatientTreatmentReason"> <valueString value="testtext NLLPatientTreatmentReason - Behandlingsändamål" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLRegistrationBasis"> <valueCode value="ELECTRONIC" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriptionFormat"> <valueCode value="ELEKTRONISKT" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLOrdinationsId"> <valueDecimal value="25154" /> </extension> <identifier> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNEFId"> <extension url="PrescriptionSetId"> <valueString value="dbbe69a8-78e0-48cf-b4dc-790a1042c775" /> </extension> </extension> <system value="http://electronichealth.se/fhir/NamingSystem/NEFId" /> <value value="dbbe69a8-78e0-48cf-b4dc-790a1042c775" /> </identifier> <status value="active" /> <intent value="order" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/varunr" /> <code value="210761" /> </coding> </medicationCodeableConcept> <subject> <reference value="Patient/cefe1521-d4dc-48bc-be51-52a12b9697ef" /> </subject> <authoredOn value="2022-05-09T00:00:00+02:00" /> <requester> <reference value="#1" /> </requester> <dispenseRequest> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfPackagesPrescribed"> <valuePositiveInt value="6" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfFillsRemaining"> <valuePositiveInt value="12" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDosePackaging"> <valueBoolean value="false" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLTotalQuantity"> <extension url="prescribed"> <valueQuantity> <value value="28800.0" /> </valueQuantity> </extension> <extension url="remaining"> <valueQuantity> <value value="28800.0" /> </valueQuantity> </extension> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriberCostCenter"> <valueIdentifier> <system value="http://electronichealth.se/identifier/arbetsplatskod" /> <value value="4000000000000" /> </valueIdentifier> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriptionCommunicableDiseasesAct"> <valueBoolean value="false" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPatientPharmaceuticalBenefitsAct"> <valueBoolean value="true" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfDispensesAllowed"> <valueUnsignedInt value="12" /> </extension> <validityPeriod> <end value="2023-05-09" /> </validityPeriod> <numberOfRepeatsAllowed value="11" /> <quantity> <value value="2400.0" /> </quantity> </dispenseRequest> </MedicationRequest>