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.
<Medication xmlns="http://hl7.org/fhir"> <id value="125a8cb6-15fe-4213-b5cd-84031f9c4feb" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedication" /> <tag> <display value="Fetch Medication eligible for reimbursement" /> </tag> <tag> <display value="A medication" /> </tag> <tag> <display value="fetch-medication-example-2" /> </tag> </meta> <text> <status value="extensions" /> --- We have skipped the narrative for better readability of the resource --- </text> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLArticleInfo"> <extension url="medicinalProduct"> <valueBoolean value="true" /> </extension> <extension url="productType"> <valueCodeableConcept> <coding> <system value="http://npl.mpa.se/CodeSystem/productclass" /> <code value="MEP" /> </coding> <text value="Läkemedel" /> </valueCodeableConcept> </extension> <extension url="productName"> <extension url="currentProductName"> <valueString value="Forxiga" /> </extension> <extension url="history"> <extension url="productName"> <valueString value="Forxiga" /> </extension> <extension url="periodOfUse"> <valuePeriod> <start value="2012-11-16T00:00:00+01:00" /> </valuePeriod> </extension> </extension> </extension> <extension url="package"> <extension url="packageContainer"> <valueString value="Blister" /> </extension> <extension url="packageDescription"> <valueString value="Blister, 98 tabletter (kalenderförpackning) (PD: Abacus Medicine A/S)" /> </extension> </extension> <extension url="strength"> <extension url="quantity"> <valueQuantity> <value value="10.0" /> <unit value="mg" /> </valueQuantity> </extension> <extension url="text"> <valueString value="10 mg" /> </extension> </extension> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLArticleAvailability"> <extension url="onTheMarket"> <valueBoolean value="true" /> </extension> <extension url="salesStopped"> <valueBoolean value="false" /> </extension> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLArticleRegulations"> <extension url="prescriptiveAuthorityCode"> <valueCode value="-" /> </extension> <extension url="substitutionDetails"> <extension url="interchangeable"> <valueBoolean value="true" /> </extension> <extension url="interchangeSubstanceGroup"> <valueString value="Dapagliflozin" /> </extension> </extension> <extension url="controlledMedicinalProduct"> <valueBoolean value="false" /> </extension> <extension url="narcoticClassification"> <valueCodeableConcept> <coding> <system value="http://npl.mpa.se/CodeSystem/narcotic-classification" /> <code value="0" /> </coding> <text value="Ej narkotikaklassad" /> </valueCodeableConcept> </extension> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLReimbursement"> <extension url="eligibleForReimbursement"> <valueBoolean value="true" /> </extension> <extension url="restrictedReimbursement"> <valueBoolean value="true" /> </extension> <extension url="productOfThePeriod"> <extension url="currentPeriod"> <valueBoolean value="false" /> </extension> <extension url="previousPeriod"> <valueBoolean value="false" /> </extension> <extension url="unavailable"> <valueBoolean value="false" /> </extension> </extension> </extension> <identifier> <system value="http://electronichealth.se/fhir/NamingSystem/nplpackid" /> <value value="20180117100030" /> </identifier> <identifier> <use value="official" /> <system value="http://electronichealth.se/fhir/NamingSystem/varunr" /> <value value="454001" /> </identifier> <code> <coding> <system value="http://www.whocc.no/atc" /> <code value="A10BK01" /> </coding> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplid" /> <code value="20101221000108" /> </coding> <text value="Dapagliflozin" /> </code> <status value="active" /> <manufacturer> <display value="Abacus Medicine A/S" /> </manufacturer> <form> <text value="filmdragerad tablett" /> </form> <amount> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAmountDescription"> <valueString value="98 tablett(er)" /> </extension> <numerator> <value value="98.0" /> <unit value="tablett(er)" /> </numerator> <denominator> <value value="1" /> </denominator> </amount> </Medication>