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": "43397c49-3079-47c2-b585-c6a2fb067244", "meta": { "lastUpdated": "07/11/2022 13:24:16" }, "type": "searchset", "total": 4, "link": [ { "relation": "self", "url": "http://13.74.30.234:8080/fhir/Observation/_search?_include=Observation%3Aperformer.organization&_profile=https%3A%2F%2Ffhir.cambio.se%2FStructureDefinition%2FObservationBodyWeightLite%2Fv1&_sid=gustav.cederblad%40cambio.se&date=gt2018-11-20T15%3A33%3A48.583Z&date=lt2022-12-20T15%3A33%3A48.583Z&patient.identifier=urn%3Aoid%3A1.2.752.129.2.1.3.1%7C199402112388&status=final" } ], "entry": [ { "fullUrl": "http://13.74.30.234:8080/fhir/Observation/21645", "resource": { "resourceType": "Observation", "id": "21645", "meta": { "id": "21645", "versionId": "21645", "lastUpdated": "12/15/2020 12:39:27", "profile": [ "https://fhir.cambio.se/StructureDefinition/ObservationBodyWeightLite/v1" ] }, "contained": [ { "resourceType": "PractitionerRole", "id": "1", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/PractitionerRoleLiteSe/v1" ] }, "practitioner": { "reference": "Practitioner/548378", "type": "Practitioner" }, "organization": { "reference": "Organization/3557", "type": "Organization" } } ], "identifier": [ { "system": "https://fhir.cambio.se/Observation", "value": "21645" } ], "status": "final", "category": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/observation-category", "code": "vital-signs" } ] } ], "code": { "coding": [ { "system": "http://snomed.info/sct", "code": "27113001", "display": "Body weight" }, { "system": "http://loinc.org", "code": "29463-7" } ] }, "subject": { "reference": "Patient/8181", "type": "Patient" }, "encounter": { "reference": "Encounter/339014", "type": "Encounter" }, "effectiveDateTime": "12/15/2020 12:39:27", "performer": [ { "reference": "#1", "type": "PractitionerRole" } ], "valueQuantity": { "value": 60, "unit": "kg", "system": "http://unitsofmeasure.org", "code": "kg" } } }, { "fullUrl": "http://13.74.30.234:8080/fhir/Observation/21649", "resource": { "resourceType": "Observation", "id": "21649", "meta": { "id": "21649", "versionId": "21649", "lastUpdated": "12/14/2020 14:04:00", "profile": [ "https://fhir.cambio.se/StructureDefinition/ObservationBodyWeightLite/v1" ] }, "contained": [ { "resourceType": "PractitionerRole", "id": "1", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/PractitionerRoleLiteSe/v1" ] }, "practitioner": { "reference": "Practitioner/548378", "type": "Practitioner" }, "organization": { "reference": "Organization/3557", "type": "Organization" } } ], "identifier": [ { "system": "https://fhir.cambio.se/Observation", "value": "21649" } ], "status": "final", "category": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/observation-category", "code": "vital-signs" } ] } ], "code": { "coding": [ { "system": "http://snomed.info/sct", "code": "27113001", "display": "Body weight" }, { "system": "http://loinc.org", "code": "29463-7" } ] }, "subject": { "reference": "Patient/8181", "type": "Patient" }, "encounter": { "reference": "Encounter/339014", "type": "Encounter" }, "effectiveDateTime": "12/14/2020 14:04:00", "performer": [ { "reference": "#1", "type": "PractitionerRole" } ], "valueQuantity": { "value": 40, "unit": "kg", "system": "http://unitsofmeasure.org", "code": "kg" } } }, { "fullUrl": "http://13.74.30.234:8080/fhir/Observation/21640", "resource": { "resourceType": "Observation", "id": "21640", "meta": { "id": "21640", "versionId": "21640", "lastUpdated": "12/14/2020 12:05:27", "profile": [ "https://fhir.cambio.se/StructureDefinition/ObservationBodyWeightLite/v1" ] }, "contained": [ { "resourceType": "PractitionerRole", "id": "1", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/PractitionerRoleLiteSe/v1" ] }, "practitioner": { "reference": "Practitioner/548378", "type": "Practitioner" }, "organization": { "reference": "Organization/3557", "type": "Organization" } } ], "identifier": [ { "system": "https://fhir.cambio.se/Observation", "value": "21640" } ], "status": "final", "category": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/observation-category", "code": "vital-signs" } ] } ], "code": { "coding": [ { "system": "http://snomed.info/sct", "code": "27113001", "display": "Body weight" }, { "system": "http://loinc.org", "code": "29463-7" } ] }, "subject": { "reference": "Patient/8181", "type": "Patient" }, "encounter": { "reference": "Encounter/339014", "type": "Encounter" }, "effectiveDateTime": "12/14/2020 12:05:27", "performer": [ { "reference": "#1", "type": "PractitionerRole" } ], "valueQuantity": { "value": 50, "unit": "kg", "system": "http://unitsofmeasure.org", "code": "kg" } } }, { "fullUrl": "http://13.74.30.234:8080/fhir/Organization/3557", "resource": { "resourceType": "Organization", "id": "3557", "meta": { "versionId": "18607", "profile": [ "https://fhir.cambio.se/StructureDefnition/Organization" ] }, "identifier": [ { "use": "secondary", "system": "https://cambio.codes/socialstyrelsen/is/arbetsplatskod", "value": "45678965497" }, { "use": "secondary", "system": "https://cambio.codes/socialstyrelsen/is/arbetsplatskod", "value": "4000000000000" }, { "use": "secondary", "system": "https://cambio.codes/is/unit/lab-identifier", "value": "EMERG" }, { "use": "official", "system": "urn:oid:1.2.752.129.2.1.4.1", "value": "SE162321000024-6907" } ], "active": true, "name": "Emergency Clinic*", "telecom": [ { "system": "phone", "value": "023-490000", "use": "work", "rank": 1 } ], "address": [ { "use": "work", "line": [ "Akut mott- Cambio lasarett" ], "_line": [ { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-streetAddressLine", "valueString": "Akut mott- Cambio lasarett" } ] } ], "city": "Bromma", "postalCode": "79182", "country": "SE" } ], "partOf": { "reference": "Organization/3555" } } } ] }