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": "d1536af3-6755-49e9-984c-372cf72c1f7a", "meta": { "lastUpdated": "01/13/2022 15:40:33" }, "type": "searchset", "total": 3, "link": [ { "relation": "self", "url": "<host>/fhir/Observation/_search?_profile=https%3A%2F%2Ffhir.cambio.se%2FStructureDefinition%2FObservationBodyWeightLite%2Fv1&date=gt2021-10-01T15%3A33%3A48.583Z&date=lt2021-12-01T15%3A33%3A48.583Z&patient%3Aidentifier=urn%3Aoid%3A1.2.752.129.2.1.3.1%7C198101199282&status=final" } ], "entry": [ { "fullUrl": "<host>/fhir/Observation/13156", "resource": { "resourceType": "Observation", "id": "13156", "meta": { "id": "13156", "versionId": "13156", "lastUpdated": "12/01/2021 09:56:30", "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/617207", "type": "Practitioner" }, "organization": { "reference": "Organization/1085", "type": "Organization" } } ], "identifier": [ { "system": "https://fhir.cambio.se/Observation", "value": "13156" } ], "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/11330", "type": "Patient" }, "encounter": { "reference": "Encounter/319824", "type": "Encounter" }, "effectiveDateTime": "12/01/2021 09:56:30", "performer": [ { "reference": "#1", "type": "PractitionerRole" } ], "valueQuantity": { "value": 102, "unit": "kg", "system": "http://unitsofmeasure.org", "code": "kg" } } }, { "fullUrl": "<host>/fhir/Observation/13158", "resource": { "resourceType": "Observation", "id": "13158", "meta": { "id": "13158", "versionId": "13158", "lastUpdated": "11/07/2021 08:15:00", "profile": [ "https://fhir.cambio.se/StructureDefinition/ObservationBodyWeightLite/v1" ] }, "identifier": [ { "system": "https://fhir.cambio.se/Observation", "value": "13158" } ], "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/11330", "type": "Patient" }, "effectiveDateTime": "11/07/2021 08:15:00", "performer": [ { "reference": "Patient/11330", "type": "Patient" }, { "reference": "Organization/1064", "type": "Organization" } ], "valueQuantity": { "value": 99, "unit": "kg", "system": "http://unitsofmeasure.org", "code": "kg" }, "note": [ { "text": "." } ] } }, { "fullUrl": "<host>/fhir/Observation/13154", "resource": { "resourceType": "Observation", "id": "13154", "meta": { "id": "13154", "versionId": "13154", "lastUpdated": "11/01/2021 09:51:01", "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/617207", "type": "Practitioner" }, "organization": { "reference": "Organization/1064", "type": "Organization" } } ], "identifier": [ { "system": "https://fhir.cambio.se/Observation", "value": "13154" } ], "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/11330", "type": "Patient" }, "effectiveDateTime": "11/01/2021 09:51:01", "performer": [ { "reference": "#1", "type": "PractitionerRole" } ], "valueQuantity": { "value": 110, "unit": "kg", "system": "http://unitsofmeasure.org", "code": "kg" } } } ] }