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": "FetchDocumentReferenceResponseExample", "type": "searchset", "timestamp": "05/03/2023 02:15:49", "total": 1, "entry": [ { "fullUrl": "http://ehealthontario.ca/fhir/DocumentReference/docref1", "resource": { "resourceType": "DocumentReference", "meta": { "profile": [ "http://ontariohealth.ca/fhir/StructureDefinition/ca-on-ps-profile-DocumentReference|0.11.0" ] }, "id": "docref1", "identifier": [ { "system": "http://placeholder-ps-on-identifier-tbd", "value": "202310134430493" } ], "docStatus": "final", "type": { "coding": [ { "system": "http://loinc.org", "code": "60591-5", "display": "Patient summary Document" } ] }, "category": [ { "extension": [ { "url": "http://ontariohealth.ca/fhir/StructureDefinition/ext-loinc-ontology-axis", "valueCoding": { "system": "http://loinc.org", "code": "74478-9", "display": "Type of Service" } } ], "coding": [ { "system": "http://loinc.org", "code": "TBD", "display": "Patient summary" } ] }, { "extension": [ { "url": "http://ontariohealth.ca/fhir/StructureDefinition/ext-loinc-ontology-axis", "valueCoding": { "system": "http://loinc.org", "code": "74477-1", "display": "Kind of document" } } ], "coding": [ { "system": "http://loinc.org", "code": "LP173418-7", "display": "Note" } ] }, { "extension": [ { "url": "http://ontariohealth.ca/fhir/StructureDefinition/ext-loinc-ontology-axis", "valueCoding": { "system": "http://loinc.org", "code": "74480-5", "display": "Subject Matter Domain" } } ], "coding": [ { "system": "http://loinc.org", "code": "CGTA1009-1", "display": "Unspecified" } ] }, { "extension": [ { "url": "http://ontariohealth.ca/fhir/StructureDefinition/ext-loinc-ontology-axis", "valueCoding": { "system": "http://loinc.org", "code": "74479-7", "display": "Role" } } ], "coding": [ { "system": "http://loinc.org", "code": "CGTA4001-1", "display": "Unspecified" } ] }, { "extension": [ { "url": "http://ontariohealth.ca/fhir/StructureDefinition/ext-loinc-ontology-axis", "valueCoding": { "system": "http://loinc.org", "code": "74476-3", "display": "Setting" } } ], "coding": [ { "system": "http://loinc.org", "code": "CGTA5001-1", "display": "Unspecified" } ] } ], "subject": { "reference": "Patient/patient1" }, "date": "12/23/2022 22:43:41", "author": [ { "reference": "PractitionerRole/practrole1" } ], "custodian": { "reference": "Organization/org1" }, "content": [ { "attachment": { "url": "Bundle/patient-summary-bundle-example" } } ] }, "search": { "mode": "match" } } ] }