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": "Observation", "id": "f1ac639e-052f-4d2f-a7dc-ebb6eb0334f2", "meta": { "versionId": "2", "lastUpdated": "07/22/2024 01:10:53", "source": "http://pekab40.moh.gov.my#oXjuIz1WcN59J4KV", "profile": [ "http://fhir.hie.moh.gov.my/StructureDefinition/Observation-smoking-history-my-core" ] }, "status": "final", "category": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/observation-category", "code": "social-history", "display": "Social History" } ] } ], "code": { "coding": [ { "system": "http://loinc.org", "code": "72166-2", "display": "Smoking History" } ] }, "subject": { "reference": "Patient/patient-placeholder" }, "effectiveDateTime": "07/16/2024 06:40:57", "issued": "07/16/2024 06:40:57", "performer": [ { "type": "PractitionerRole", "display": "Saifuldaulah Bin Mohd Hafiz Ngoo" } ], "note": [ { "text": "<div xmlns=\"http://www.w3.org/1999/xhtml\"><table><tbody><tr><td>Smoking Status</td><td>true</td></tr><tr><td>Lifetime smoking use</td><td>15 years</td></tr><tr><td>Date quit smoking</td><td>19/7/2024</td></tr></tbody><tfoot><tr><td>Smoking device</td><td>Cigarette</td></tr><tr><td>Smoking history</td><td> Patient has been smoking for the past 15 years, have plan to quit now</td></tr></tfoot></table><p> </p></div>" } ], "component": [ { "code": { "coding": [ { "system": "http://loinc.org", "code": "72166-2", "display": "Smoking status" } ] }, "valueBoolean": true }, { "code": { "coding": [ { "system": "http://loinc.org", "code": "74011-8", "display": "Lifetime smoking use" } ] }, "valueQuantity": { "value": 15, "unit": "years", "system": "http://unitsofmeasure.org", "code": "a" } }, { "code": { "coding": [ { "system": "http://loinc.org", "code": "74010-0", "display": "Date quit smoking" } ] }, "valueDateTime": "2024-07-19" }, { "code": { "coding": [ { "system": "http://loinc.org", "code": "81228-9", "display": "Smoking product" } ] }, "valueCodeableConcept": { "coding": [ { "system": "http://snomed.info/sct", "code": "722496004", "display": "Cigarette" } ] } }, { "code": { "coding": [ { "system": "http://loinc.org", "code": "11366-2", "display": "Smoking History" } ] }, "valueString": "<div xmlns=\"http://www.w3.org/1999/xhtml\">Patient has been smoking for the past 15 years, have plan to quit now</div>" } ] }