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"> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedicationRequest" /> <tag> <display value="Create MedicationRequest for multi-dose dispensing" /> </tag> <tag> <display value="Create MedicationRequest for multi-dose dispensing" /> </tag> <tag> <display value="create-medicationrequest-example-5" /> </tag> </meta> <contained> <Practitioner> <id value="thePractitioner" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLPractitioner" /> </meta> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLWorkplaceSummary"> <extension url="workplaceName"> <valueString value="Min vardcentral" /> </extension> <extension url="workplaceIdentifier"> <valueString value="7711222222" /> </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/NLLContactPointType"> <valueCode value="P" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAvailableToPatient"> <valueBoolean value="false" /> </extension> <value value="011-900000" /> <rank value="1" /> </telecom> <telecom> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLContactPointType"> <valueCode value="W" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAvailableToPatient"> <valueBoolean value="true" /> </extension> <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/NLLPatientTreatmentReason"> <valueString value="Mot förhöjt blodtryck" /> </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/NLLUsageDates"> <extension url="usageStartDate"> <valueDate value="2022-05-04" /> </extension> <extension url="usageEndDate"> <valueDate value="2022-11-03" /> </extension> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLTreatmentDates"> <extension url="treatmentReviewDate"> <valueDate value="2022-07-03" /> </extension> </extension> <status value="active" /> <intent value="order" /> <priority value="urgent" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplid" /> <code value="20060710000381" /> </coding> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <code value="20091202100326" /> </coding> </medicationCodeableConcept> <subject> <reference value="Patient/0a1eecbf-4834-4848-ad2a-a79e0b1041e8" /> </subject> <authoredOn value="2022-05-03" /> <requester> <reference value="#thePractitioner" /> </requester> <reasonCode> <coding> <code value="38341003" /> </coding> </reasonCode> <dosageInstruction> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAdministeringInstruction"> <valueString value="Sväljning" /> </extension> <sequence value="1" /> <patientInstruction value="1 tablett kl. 08., sväljning." /> <timing> <repeat> <timeOfDay value="08:00:00" /> </repeat> </timing> <asNeededBoolean value="false" /> <method> <coding> <code value="738995006" /> </coding> </method> <doseAndRate> <doseQuantity> <value value="1" /> <code value="{tbl}" /> </doseQuantity> </doseAndRate> </dosageInstruction> <dispenseRequest> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDosePackaging"> <valueBoolean value="true" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriberCostCenter"> <valueIdentifier> <value value="4000000000000" /> </valueIdentifier> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPatientPharmaceuticalBenefitsAct"> <valueBoolean value="true" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLConditionsPharmaceuticalBenefitsAct"> <valueBoolean value="false" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriptionCommunicableDiseasesAct"> <valueBoolean value="false" /> </extension> <validityPeriod> <end value="2022-11-03" /> </validityPeriod> </dispenseRequest> </MedicationRequest>