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.
<Bundle xmlns="http://hl7.org/fhir"> <id value="example-dental-chart" /> <type value="transaction" /> <entry> <fullUrl value="urn:uuid:00000013-0001-0001-0001-000000000001" /> <resource> <Observation> <meta> <source value="http://provider.hie.moh.gov.my" /> <profile value="http://fhir.hie.moh.gov.my/StructureDefinition/Observation-panel-my-core" /> </meta> <status value="final" /> <code> <coding> <system value="http://loinc.org" /> <code value="32885-6" /> <display value="Dental Chart" /> </coding> </code> <subject> <reference value="Patient/9beb7510-4d2a-46b5-a656-02d5bee01783" /> </subject> <encounter> <reference value="Encounter/37c6a82a-143d-4d5e-9e52-2b96fb696d24" /> </encounter> <effectiveDateTime value="2023-09-25T08:46:25.231+08:00" /> <issued value="2023-09-25T08:46:25.231+08:00" /> <performer> <type value="PractitionerRole" /> <display value="Al-amin" /> </performer> <hasMember> <reference value="Observation/urn:uuid:00000013-0005-0005-0005-000000000002" /> </hasMember> <hasMember> <reference value="Observation/urn:uuid:00000013-0005-0005-0005-000000000003" /> </hasMember> </Observation> </resource> <request> <method value="POST" /> </request> </entry> <entry> <fullUrl value="urn:uuid:00000013-0005-0005-0005-000000000002" /> <resource> <Observation> <meta> <source value="http://provider.hie.moh.gov.my" /> <profile value="http://fhir.hie.moh.gov.my/StructureDefinition/Observation-dental-chart-my-core" /> </meta> <status value="final" /> <code> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/dentitian-my-core" /> <code value="16" /> <display value="16" /> </coding> </code> <subject> <reference value="Patient/9beb7510-4d2a-46b5-a656-02d5bee01783" /> </subject> <encounter> <reference value="Encounter/37c6a82a-143d-4d5e-9e52-2b96fb696d24" /> </encounter> <issued value="2023-09-25T08:46:25.231+08:00" /> <performer> <reference value="PractitionerRole/2482f854-3bfd-4ecc-8147-f4afdda7bf3f/_history/8" /> </performer> <interpretation> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/dental-code-my-core" /> <code value="4a" /> <display value="For extraction for reasons otner than caries (Xa/xa)" /> </coding> </interpretation> <component> <code> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/surface-my-core" /> <code value="F" /> <display value="Labial" /> </coding> </code> </component> <component> <code> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/surface-my-core" /> <code value="I" /> <display value="Incisal" /> </coding> </code> </component> <component> <code> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/surface-my-core" /> <code value="M" /> <display value="Mesial" /> </coding> </code> </component> </Observation> </resource> <request> <method value="POST" /> </request> </entry> <entry> <fullUrl value="urn:uuid:00000013-0005-0005-0005-000000000003" /> <resource> <Observation> <id value="7bd7d6e2-4d80-4e47-bca5-48ef3b80c9c6" /> <meta> <source value="http://provider.hie.moh.gov.my" /> <profile value="http://fhir.hie.moh.gov.my/StructureDefinition/Observation-dental-chart-my-core" /> </meta> <status value="final" /> <code> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/dentitian-my-core" /> <code value="22" /> <display value="22" /> </coding> </code> <subject> <reference value="Patient/9beb7510-4d2a-46b5-a656-02d5bee01783" /> </subject> <encounter> <reference value="Encounter/37c6a82a-143d-4d5e-9e52-2b96fb696d24" /> </encounter> <issued value="2023-09-25T08:46:25.231+08:00" /> <performer> <reference value="PractitionerRole/2482f854-3bfd-4ecc-8147-f4afdda7bf3f/_history/8" /> </performer> <valueCodeableConcept> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/surface-code-my-core" /> <code value="8" /> <display value="Redo filling" /> </coding> </valueCodeableConcept> <interpretation> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/dental-code-my-core" /> <code value="1" /> <display value="Caries (D/d)" /> </coding> </interpretation> <component> <code> <coding> <system value="http://fhir.hie.moh.gov.my/CodeSystem/surface-my-core" /> <code value="P" /> <display value="Palatal" /> </coding> </code> </component> </Observation> </resource> <request> <method value="POST" /> </request> </entry> </Bundle>