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 on birthdate" /> </tag> <tag> <display value="Example of create prescription for a patient on birthdate" /> </tag> <tag> <display value="create-medicationrequest-example-3" /> </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> <contained> <Patient> <id value="thePatient" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLPatient" /> </meta> <name> <family value="Testsson" /> <given value="pelle" /> </name> <gender value="male" /> <birthDate value="1957-12-01" /> </Patient> </contained> <contained> <Location> <id value="thePharmacy" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLPharmacyLocation" /> </meta> <identifier> <system value="http://electronichealth.se/identifier/gln" /> <value value="7350046611966" /> </identifier> </Location> </contained> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPatientTreatmentReason"> <valueString value="Mot sömnbesvär" /> </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> <status value="active" /> <intent value="order" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplid" /> <code value="19940128000057" /> </coding> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <code value="19940128100016" /> </coding> </medicationCodeableConcept> <subject> <reference value="#thePatient" /> </subject> <authoredOn value="2022-05-03" /> <requester> <reference value="#thePractitioner" /> </requester> <reasonCode> <coding> <code value="193462001" /> </coding> </reasonCode> <dosageInstruction> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAdministeringInstruction"> <valueString value="Sväljning" /> </extension> <sequence value="1" /> <patientInstruction value="1-2 tabletter till natten vid behov, sväljning." /> <timing> <repeat> <when value="NIGHT" /> </repeat> </timing> <asNeededBoolean value="true" /> <method> <coding> <code value="738995006" /> </coding> </method> <doseAndRate> <doseRange> <low> <value value="1" /> <code value="{tbl}" /> </low> <high> <value value="2" /> <code value="{tbl}" /> </high> </doseRange> </doseAndRate> </dosageInstruction> <dispenseRequest> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriberCostCenter"> <valueIdentifier> <value value="4000000000000" /> </valueIdentifier> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriptionCommunicableDiseasesAct"> <valueBoolean value="false" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfPackagesPrescribed"> <valuePositiveInt value="1" /> </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/NLLDosePackaging"> <valueBoolean value="false" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPharmacyReference"> <valueReference> <reference value="#thePharmacy" /> </valueReference> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfDispensesAllowed"> <valueUnsignedInt value="4" /> </extension> <dispenseInterval> <value value="25" /> <unit value="day" /> <code value="d" /> </dispenseInterval> <validityPeriod> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLFirstDispenseBefore"> <valueDate value="2022-05-13" /> </extension> <end value="2023-05-03" /> </validityPeriod> <numberOfRepeatsAllowed value="3" /> </dispenseRequest> </MedicationRequest>