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.
<Bundle xmlns="http://hl7.org/fhir"> <id value="d273a3d6-11db-472b-b3f3-0d27ecdb444b" /> <meta> <lastUpdated value="2022-10-10T13:35:19.453+02:00" /> <tag> <display value="Fetch Medication with dispensing restriction" /> </tag> <tag> <display value="Bundle of type searchset" /> </tag> <tag> <display value="fetch-medication-example-1" /> </tag> </meta> <type value="searchset" /> <total value="1" /> <link> <relation value="self" /> <url value="https://test.ehalsomyndigheten.se/fhir/Medication?nplPackId=20120704100050" /> </link> <entry> <fullUrl value="https://test.ehalsomyndigheten.se/fhir/Medication/124cb76b-a6d2-42d6-b5c4-a194ceb89aa7" /> <resource> <Medication> <id value="124cb76b-a6d2-42d6-b5c4-a194ceb89aa7" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLMedication" /> </meta> <text> <status value="extensions" /> <div xmlns="http://www.w3.org/1999/xhtml">Concerta, depottablett 36 mg Orifarm AB</div> </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="Concerta" /> </extension> <extension url="history"> <extension url="productName"> <valueString value="Concerta" /> </extension> <extension url="periodOfUse"> <valuePeriod> <start value="2012-08-04T00:00:00+02:00" /> </valuePeriod> </extension> </extension> </extension> <extension url="package"> <extension url="packageContainer"> <valueString value="Burk" /> </extension> <extension url="packageDescription"> <valueString value="Burk, 30 tabletter" /> </extension> </extension> <extension url="strength"> <extension url="quantity"> <valueQuantity> <value value="36.0" /> <unit value="mg" /> </valueQuantity> </extension> <extension url="text"> <valueString value="36 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="repeatPrescription"> <valueCodeableConcept> <coding> <system value="http://npl.mpa.se/CodeSystem/prescription-repeatable-category" /> <code value="004" /> </coding> </valueCodeableConcept> </extension> <extension url="substitutionDetails"> <extension url="interchangeable"> <valueBoolean value="true" /> </extension> <extension url="interchangeSubstanceGroup"> <valueString value="Metylfenidat" /> </extension> </extension> <extension url="dispensingRestriction"> <valueCodeableConcept> <coding> <system value="http://npl.mpa.se/CodeSystem/dispensing-restriction" /> <code value="D01" /> </coding> <text value="Får lämnas ut endast om det har förordnats av läkare med specialistkompetens i barn/ungdomspsykiatri, psykiatri, rättspsykiatri, neurologi eller barn/ungdomsneurologi med habilitering eller av läkare med dispens från LV. Se HSLF-FS 2017:74." /> </valueCodeableConcept> </extension> <extension url="controlledMedicinalProduct"> <valueBoolean value="true" /> </extension> <extension url="narcoticClassification"> <valueCodeableConcept> <coding> <system value="http://npl.mpa.se/CodeSystem/narcotic-classification" /> <code value="1" /> </coding> <text value="II - Narkotika med medicinsk användning" /> </valueCodeableConcept> </extension> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLReimbursement"> <extension url="eligibleForReimbursement"> <valueBoolean value="true" /> </extension> <extension url="restrictedReimbursement"> <valueBoolean value="false" /> </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="20120704100050" /> </identifier> <identifier> <use value="official" /> <system value="http://electronichealth.se/fhir/NamingSystem/varunr" /> <value value="021104" /> </identifier> <code> <coding> <system value="http://www.whocc.no/atc" /> <code value="N06BA04" /> </coding> <coding> <system value="http://electronichealth.se/fhir/NamingSystem/nplid" /> <code value="20111117000037" /> </coding> <text value="Metylfenidat" /> </code> <status value="active" /> <manufacturer> <display value="Orifarm AB" /> </manufacturer> <form> <text value="depottablett" /> </form> <amount> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLAmountDescription"> <valueString value="30 tablett(er)" /> </extension> <numerator> <value value="30.0" /> <unit value="tablett(er)" /> </numerator> <denominator> <value value="1" /> </denominator> </amount> </Medication> </resource> </entry> </Bundle>