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", "type": "transaction", "entry": [ { "fullUrl": "urn:uuid:00000011-0001-0001-0003-000000000001", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-vital-sign-panel-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "85353-1", "display": "Vital Sign Panel" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "hasMember": [ { "reference": "Observation/urn:uuid:00000011-0005-0005-0005-000000000002" }, { "reference": "Observation/urn:uuid:00000011-0005-0005-0005-000000000003" }, { "reference": "Observation/urn:uuid:00000011-0005-0005-0005-000000000004" }, { "reference": "Observation/urn:uuid:00000011-0005-0005-0005-000000000005" }, { "reference": "Observation/urn:uuid:00000011-0005-0005-0005-000000000006" }, { "reference": "Observation/urn:uuid:00000011-0005-0005-0005-000000000007" }, { "reference": "Observation/urn:uuid:00000011-0005-0005-0005-000000000008" } ] } }, { "fullUrl": "urn:uuid:00000011-0005-0005-0005-000000000002", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-heart-rate-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "8867-4", "display": "Heart Rate" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "valueQuantity": { "value": 60, "unit": "/min", "system": "http://unitsofmeasure.org", "code": "/min" }, "component": [ { "code": { "coding": [ { "system": "http://loinc.org", "code": "8361-8", "display": "Heart rate device" } ] }, "valueString": "mobile machine" }, { "code": { "coding": [ { "system": "http://loinc.org", "code": "8887-2", "display": "Body position" } ] }, "valueString": "sitting" } ] } }, { "fullUrl": "urn:uuid:00000011-0005-0005-0005-000000000003", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-respi-rate-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "9279-1", "display": "Respiratory Rate" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "valueQuantity": { "value": 16, "unit": "/min", "system": "http://unitsofmeasure.org", "code": "/min" } } }, { "fullUrl": "urn:uuid:00000011-0005-0005-0005-000000000004", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-oxygen-sat-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "59408-5", "display": "Oxygen Saturation" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "valueQuantity": { "value": 94, "unit": "%", "system": "http://unitsofmeasure.org", "code": "%" } } }, { "fullUrl": "urn:uuid:00000011-0005-0005-0005-000000000005", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-systolic-bp-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "8480-6", "display": "systolic BP" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "valueQuantity": { "value": 80, "unit": "mmHg", "system": "http://unitsofmeasure.org", "code": "mm[Hg]" } } }, { "fullUrl": "urn:uuid:00000011-0005-0005-0005-000000000006", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-diastolic-bp-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "8462-4", "display": "Diastolic BP" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "valueQuantity": { "value": 60, "unit": "mmHg", "system": "http://unitsofmeasure.org", "code": "mm[Hg]" } } }, { "fullUrl": "urn:uuid:00000011-0005-0005-0005-000000000007", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-body-temp-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "8310-5", "display": "Temperature" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "valueQuantity": { "value": 31, "unit": "Cel", "system": "http://unitsofmeasure.org", "code": "Cel" } } }, { "fullUrl": "urn:uuid:00000011-0005-0005-0005-000000000008", "request": { "method": "POST" }, "resource": { "resourceType": "Observation", "meta": { "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-pain-score-my-core" ], "source": "http://sample.com" }, "status": "final", "code": { "coding": [ { "system": "http://loinc.org", "code": "72514-3", "display": "Pain Score" } ] }, "subject": { "reference": "Patient/692a1a7d-38dc-409b-8049-e76918594989" }, "encounter": { "reference": "Encounter/1ed9f4c0-69a9-4cf3-abd7-27d27943ee3d/_history/1" }, "effectiveDateTime": "07/01/2024 00:00:00", "issued": "07/01/2024 00:00:00", "performer": [ { "display": "Saifuldaulah Bin Mohd Hafiz Ngoo", "type": "PractitioneRole" } ], "valueQuantity": { "value": 8 } } } ] }