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": "Appointment", "meta": { "profile": [ "https://pta.kanta.fi/fhir/StructureDefinition/AppointmentAppointment" ], "security": [ { "system": "https://pta.kanta.fi/fhir/CodeSystem/fipta-cs-visibletocustodian", "code": "1", "display": "Huoltaja saa käsitellä ajanvaraustietoja" } ] }, "text": { "status": "generated", --- We have skipped the narrative for better readability of the resource --- }, "contained": [ { "resourceType": "Patient", "id": "PAT1", "meta": { "profile": [ "https://pta.kanta.fi/fhir/StructureDefinition/AppointmentPatient" ] }, "identifier": [ { "use": "official", "system": "urn:oid:1.2.246.21", "value": "300111A9001" }, { "use": "old", "system": "urn:oid:1.2.246.10.12345678.22.2023", "value": "1122" } ], "name": [ { "use": "official", "family": "Koski", "given": [ "Iida", "Maria" ] } ] }, { "resourceType": "Organization", "id": "ORG-UNIT1", "meta": { "profile": [ "https://pta.kanta.fi/fhir/StructureDefinition/AppointmentOrganization" ] }, "identifier": [ { "system": "urn:ietf:rfc:3986", "value": "urn:oid:1.2.246.10.99999773.10.20.1010" } ], "name": "Diabeteshoitajan vastaanotto, Kirkonkylän sosiaali- ja terveystoimi", "partOf": { "identifier": [ { "system": "urn:ietf:rfc:3986", "value": "urn:oid:1.2.246.10.99999773.10.0" } ], "display": "Hämeen hyvinvointialue" } }, { "resourceType": "HealthcareService", "id": "HEALTHCARESERVICE1", "meta": { "profile": [ "https://pta.kanta.fi/fhir/StructureDefinition/AppointmentHealthcareService" ] }, "providedBy": { "reference": "#ORG-UNIT1" }, "category": [ { "coding": [ { "system": "urn:oid:1.2.246.537.6.50.202401", "code": "SOTE2.1", "display": "Terveysneuvonta" } ] } ], "name": "Ajanvaraus terveydenhoitajalle" } ], "identifier": [ { "system": "http://organisaationmaarittelemanimiavaruus.fi", "value": "12345" } ], "status": "booked", "start": "06/10/2023 09:00:00", "end": "06/10/2023 11:00:00", "participant": [ { "type": [ { "coding": [ { "system": "https://pta.kanta.fi/fhir/CodeSystem/fipta-cs-appointmenttypecategory", "code": "1", "display": "Asiakas tai potilas, jota resurssi koskee" } ] } ], "actor": { "reference": "#PAT1" }, "status": "accepted" }, { "type": [ { "coding": [ { "system": "https://pta.kanta.fi/fhir/CodeSystem/fipta-cs-appointmenttypecategory", "code": "2", "display": "Terveydenhuollon palvelu, johon ajanvaraus kohdistuu" } ] } ], "actor": { "reference": "#HEALTHCARESERVICE1" }, "status": "accepted" } ], "extension": [ { "url": "https://pta.kanta.fi/fhir/StructureDefinition/extension/ChildAppointment", "valueIdentifier": { "system": "http://organisaationmaarittelemanimiavaruus.fi", "value": "12345_1" } }, { "url": "https://pta.kanta.fi/fhir/StructureDefinition/extension/ChildAppointment", "valueIdentifier": { "system": "http://organisaationmaarittelemanimiavaruus.fi", "value": "12345_2" } } ] }