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="f2fcf328-ab36-4eba-86ad-93590a5a079b" /> <meta> <lastUpdated value="2022-10-03T11:32:12.450+02:00" /> <tag> <display value="Fetch Provenance related to an updated prescription" /> </tag> <tag> <display value="Example of a Provenance related to an updated prescription" /> </tag> <tag> <display value="fetch-provenance-example-1" /> </tag> </meta> <type value="searchset" /> <total value="2" /> <link> <relation value="self" /> <url value="https://test.ehalsomyndigheten.se/fhir/MedicationRequest/5099332b-7591-4e8a-8919-087f82db440c/Provenance" /> </link> <entry> <fullUrl value="https://test.ehalsomyndigheten.se/fhir/Provenance/d4ed53da-728c-4f75-a37a-ddea8b77cf45" /> <resource> <Provenance> <id value="d4ed53da-728c-4f75-a37a-ddea8b77cf45" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLProvenance" /> </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> <target> <reference value="MedicationRequest/5099332b-7591-4e8a-8919-087f82db440c/_history/1" /> </target> <occurredDateTime value="2022-10-03T11:32:11+02:00" /> <recorded value="2022-10-03T11:32:11.109+02:00" /> <activity> <coding> <system value="http://ehalsomyndigheten.se/fhir/CodeSystem/provenance-activity-types" /> <code value="REGISTRERA_FORSKRIVNING" /> </coding> </activity> <agent> <type> <coding> <code value="enterer" /> </coding> </type> <who> <reference value="#1" /> </who> </agent> </Provenance> </resource> </entry> <entry> <fullUrl value="https://test.ehalsomyndigheten.se/fhir/Provenance/c2152ce1-e5ce-46ec-bdc8-5a3a7be032a4" /> <resource> <Provenance> <id value="c2152ce1-e5ce-46ec-bdc8-5a3a7be032a4" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLProvenance" /> </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="SE165567766992-101W" /> </extension> <extension url="workplaceName"> <valueString value="Min vardcentral" /> </extension> <extension url="workplaceType"> <valueCode value="HEALTHCAREUNIT" /> </extension> <extension url="workplaceIdType"> <valueCode value="HSA" /> </extension> </extension> <name> <family value="Svensson" /> <given value="Gustav" /> </name> <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> <contained> <Practitioner> <id value="2" /> <meta> <profile value="http://electronichealth.se/fhir/StructureDefinition/NLLPractitioner" /> </meta> <extension url="https://electronichealth.se/fhir/StructureDefinition/NLLUserAcronym"> <valueString value="105687" /> </extension> <extension url="http://electronichealth.se/fhir/StructureDefinition/NLLWorkplaceSummary"> <extension url="workplaceIdentifier"> <valueString value="7350045511997" /> </extension> <extension url="workplaceName"> <valueString value="Doris �ppenv�rd" /> </extension> <extension url="workplaceType"> <valueCode value="PHARMACY" /> </extension> <extension url="workplaceIdType"> <valueCode value="GLN" /> </extension> </extension> <name> <family value="Ingesson" /> <given value="Inga-Lill" /> </name> <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="08123461" /> <rank value="1" /> </telecom> <address> <type value="physical" /> <line value="Bes�ksadressen 6" /> <city value="Stockholm" /> </address> <qualification> <identifier> <system value="urn:oid:1.2.752.116.3.1.1" /> <value value="920007" /> </identifier> <code> <coding> <system value="urn:oid:1.2.752.116.3.1.3" /> <code value="AP" /> </coding> </code> </qualification> </Practitioner> </contained> <target> <reference value="MedicationRequest/5099332b-7591-4e8a-8919-087f82db440c/_history/2" /> </target> <occurredDateTime value="2022-10-03T11:32:11+02:00" /> <recorded value="2022-10-03T11:32:11.727+02:00" /> <reason> <coding> <system value="http://terminology.hl7.org/CodeSystem/v3-NullFlavor" /> <code value="OTH" /> </coding> <text value="Byte av l�kemedelsform." /> </reason> <activity> <coding> <system value="http://ehalsomyndigheten.se/fhir/CodeSystem/provenance-activity-types" /> <code value="UPPDATERA_FORSKRIVNING" /> </coding> </activity> <agent> <type> <coding> <code value="author" /> </coding> </type> <who> <reference value="#1" /> </who> </agent> <agent> <type> <coding> <code value="enterer" /> </coding> </type> <who> <reference value="#2" /> </who> </agent> </Provenance> </resource> </entry> </Bundle>