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": "4137d1c4-1e87-4e86-8c15-344ad086e3f9", "meta": { "versionId": "1", "lastUpdated": "05/27/2019 09:05:44", "profile": [ "http://phr.kanta.fi/StructureDefinition/fiphr-sd-stepstaken" ] }, "language": "fi", "text": { "status": "generated", --- We have skipped the narrative for better readability of the resource --- }, "identifier": [ { "system": "urn:ietf:rfc:3986", "value": "urn:uuid:0b0a55d2-799a-45f5-a161-6a4a5faad1f8" } ], "status": "final", "category": [ { "coding": [ { "system": "http://phr.kanta.fi/fiphr-cs-fitnesscategory", "code": "fitness", "display": "Fitness" }, { "system": "http://ownSystem.com/phr-cs-fitnesscategory", "code": "fitness", "display": "Fatneeees" } ] } ], "code": { "coding": [ { "system": "http://loinc.org", "code": "66334-4", "display": "Steps" }, { "system": "http://loinc.org", "code": "41950-7", "display": "Number of Steps in 24 Hours" }, { "system": "http://snomed.info/sct", "code": "129006008", "display": "Walking (observable entity)" } ] }, "subject": { "reference": "Patient/daf8ca40-b46c-4c6b-99d5-d3a1b77074ad" }, "effectiveDateTime": "2012-09-17", "issued": "02/02/2012 08:00:00", "performer": [ { "reference": "Patient/daf8ca40-b46c-4c6b-99d5-d3a1b77074ad" } ], "valueQuantity": { "value": 6500, "unit": "1", "system": "http://unitsofmeasure.org", "code": "1" }, "note": [ { "text": "Note" } ], "interpretation": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v3-ObservationInterpretation", "code": "N", "display": "Normal" } ] } ], "referenceRange": [ { "low": { "value": 5000, "unit": "1", "system": "http://unitsofmeasure.org", "code": "1" }, "high": { "value": 15000, "unit": "1", "system": "http://unitsofmeasure.org", "code": "1" }, "appliesTo": [ { "coding": [ { "system": "http://snomed.info/sct", "code": "248153007", "display": "Male" } ], "text": "Normal range" } ], "age": { "low": { "value": 15, "unit": "years", "system": "http://unitsofmeasure.org", "code": "a" }, "high": { "value": 100, "unit": "years", "system": "http://unitsofmeasure.org", "code": "a" } }, "text": "Age" } ] }