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.
{ "resourceType": "Bundle", "id": "94260a20-66ad-4848-a840-95463f15dca0", "meta": { "lastUpdated": "01/13/2022 14:43:51" }, "type": "searchset", "total": 4, "link": [ { "relation": "self", "url": "<host>/fhir/Observation/_search?_include=Observation%3Asubject&_include=Observation%3Aperformer.practitioner&_include=Observation%3Aperformer.organization&_profile=https%3A%2F%2Ffhir.cambio.se%2FStructureDefinition%2FObservationBodyHeightLite%2Fv1&date=lt2022-12-20T15%3A33%3A48.583Z&date=gt2021-12-20T15%3A33%3A48.583Z&patient.identifier=urn%3Aoid%3A1.2.752.129.2.1.3.1%7C198101199282&status=final" } ], "entry": [ { "fullUrl": "<host>/fhir/Observation/13293", "resource": { "resourceType": "Observation", "id": "13293", "meta": { "id": "13293", "versionId": "13293", "lastUpdated": "01/13/2022 14:29:58", "profile": [ "https://fhir.cambio.se/StructureDefinition/ObservationBodyHeightLite/v1" ] }, "contained": [ { "resourceType": "PractitionerRole", "id": "1", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/PractitionerRoleLiteSe/v1" ] }, "practitioner": { "reference": "Practitioner/617207", "type": "Practitioner" }, "organization": { "reference": "Organization/1085", "type": "Organization" } } ], "identifier": [ { "system": "https://fhir.cambio.se/Observation", "value": "13293" } ], "status": "final", "category": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/observation-category", "code": "vital-signs" } ] } ], "code": { "coding": [ { "system": "http://loinc.org", "code": "8302-2" }, { "system": "http://snomed.info/sct", "code": "1153637007", "display": "Body height" } ] }, "subject": { "reference": "Patient/11330", "type": "Patient" }, "encounter": { "reference": "Encounter/319824", "type": "Encounter" }, "effectiveDateTime": "01/13/2022 14:29:58", "performer": [ { "reference": "#1", "type": "PractitionerRole" } ], "valueQuantity": { "value": 187, "unit": "cm", "system": "http://unitsofmeasure.org", "code": "cm" } } }, { "fullUrl": "<host>/fhir/Practitioner/617207", "resource": { "resourceType": "Practitioner", "id": "617207", "meta": { "versionId": "617207", "profile": [ "https://fhir.cambio.se/StructureDefnition/Practitioner" ] }, "active": true, "name": [ { "family": "Andersson", "given": [ "Nelly" ] } ] } }, { "fullUrl": "<host>/patients/fhir/Organization/1085", "resource": { "resourceType": "Organization", "id": "1085", "meta": { "versionId": "18200", "profile": [ "https://fhir.cambio.se/StructureDefnition/Organization" ] }, "identifier": [ { "use": "secondary", "system": "https://cambio.codes/is/unit/lab-identifier", "value": "MED1" }, { "use": "secondary", "system": "https://cambio.codes/socialstyrelsen/is/arbetsplatskod", "value": "4000000000000" }, { "use": "official", "system": "urn:oid:1.2.752.129.2.1.4.1", "value": "SE2321000016-13Q012" } ], "active": true, "name": "Medicin Avd 1", "telecom": [ { "system": "phone", "value": "019-345670", "use": "work", "rank": 1 } ], "address": [ { "use": "work", "line": [ "Nygatan 35" ], "_line": [ { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-streetAddressLine", "valueString": "Nygatan 35" } ] } ], "city": "Stockholm", "postalCode": "79182", "country": "SE" } ], "partOf": { "reference": "Organization/1064" } } }, { "fullUrl": "<host>/fhir/Patient/11330", "resource": { "resourceType": "Patient", "id": "11330", "meta": { "versionId": "11330", "profile": [ "https://fhir.cambio.se/StructureDefinition/PatientSe" ] }, "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/patient-genderIdentity", "valueCodeableConcept": { "coding": [ { "system": "http://hl7.org/fhir/gender-identity", "code": "female", "display": "female" } ] } }, { "url": "https://fhir.cambio.se/StructureDefinition/patient-populationRegistrationCounty", "valueCoding": { "system": "https://cambio.codes/scb/cs/lkf", "code": "01", "display": "Stockholms län" } }, { "url": "https://fhir.cambio.se/StructureDefinition/patient-populationRegistrationMunicipality", "valueCoding": { "system": "https://cambio.codes/scb/cs/lkf", "code": "80", "display": "Stockholm" } }, { "url": "https://fhir.cambio.se/StructureDefinition/patient-populationRegistrationParish", "valueCoding": { "system": "https://cambio.codes/scb/cs/lkf", "code": "07", "display": "S:t Matteus" } } ], "identifier": [ { "use": "official", "system": "urn:oid:1.2.752.129.2.1.3.1", "value": "198101199282" } ], "name": [ { "family": "Gran", "given": [ "Matilda" ] } ], "gender": "female", "birthDate": "1981-01-19", "deceasedBoolean": false, "address": [ { "line": [ "Kungsgatan 31" ], "_line": [ { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-streetAddressLine", "valueString": "Kungsgatan 31" } ] } ], "city": "Stockholm", "country": "SE" } ] } } ] }