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="1f4b3dc7-e0ca-4783-9ba2-8137c0a1967f" /> <meta> <versionId value="1" /> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedicationRequest" /> <tag> <display value="Fetch MedicationRequest as a healthcare provider" /> </tag> <tag> <display value="Example of fetch prescription for a patient having a national identity number" /> </tag> <tag> <display value="fetch-medicationrequest-example-1" /> </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/NLLTreatmentDates"> <extension url="treatmentEndDate"> <valueDate value="2022-05-23" /> </extension> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPrescriptionChain"> <valueUuid value="urn:uuid:eecb13af-76b6-4d11-b633-b0f2f77ae8ce" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLPatientTreatmentReason"> <valueString value="Mot ögoninfektion" /> </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="25149" /> </extension> <identifier> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNEFId"> <extension url="PrescriptionSetId"> <valueString value="8513e8df-67d9-40c2-bd37-58c3a09b01bc" /> </extension> </extension> <system value="http://electronichealth.se/fhir/NamingSystem/NEFId" /> <value value="8513e8df-67d9-40c2-bd37-58c3a09b01bc" /> </identifier> <status value="active" /> <intent value="order" /> <medicationCodeableConcept> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplid" /> <code value="20141125000095" /> </coding> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <code value="20150225100086" /> </coding> </medicationCodeableConcept> <subject> <reference value="Patient/722c3e2f-52bb-458f-af46-aa22466f478c" /> </subject> <authoredOn value="2022-05-09T00:00:00+02:00" /> <requester> <reference value="#1" /> </requester> <reasonCode> <coding> <system value="http://electronichealth.se/fhir/CodeSystem/nkoo-sct" /> <code value="128350005" /> </coding> </reasonCode> <dosageInstruction> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAdministeringInstruction"> <valueString value="vänster öga" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLSiteQualifier"> <valueCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="7771000" /> </coding> </valueCodeableConcept> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLDosageType"> <valueCode value="FREKVENSDOSERING" /> </extension> <sequence value="1" /> <additionalInstruction> <text value="Behandla till 2 dagar efter symptomfrihet." /> </additionalInstruction> <patientInstruction value="1 droppe 6 till 8 gånger dagligen i vänster öga." /> <timing> <repeat> <frequency value="6" /> <frequencyMax value="8" /> <period value="1" /> <periodUnit value="d" /> </repeat> </timing> <asNeededBoolean value="false" /> <site> <coding> <system value="http://snomed.info/sct" /> <code value="81745001" /> </coding> </site> <doseAndRate> <doseQuantity> <value value="1.0" /> <system value="http://ehalsomyndigheten.se/fhir/CodeSystem/ehm-ucum-annotations" /> <code value="{drop}" /> </doseQuantity> </doseAndRate> </dosageInstruction> <dispenseRequest> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfPackagesPrescribed"> <valuePositiveInt value="1" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLNumberOfFillsRemaining"> <valuePositiveInt value="1" /> </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="10.0" /> </valueQuantity> </extension> <extension url="remaining"> <valueQuantity> <value value="10.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="1" /> </extension> <validityPeriod> <end value="2022-05-23" /> </validityPeriod> <numberOfRepeatsAllowed value="0" /> <quantity> <value value="10.0" /> </quantity> </dispenseRequest> </MedicationRequest>