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": "1d0783c9-c643-4728-befd-6a83c328ce5f", "meta": { "lastUpdated": "08/15/2022 09:50:48" }, "type": "searchset", "total": 3, "link": [ { "relation": "self", "url": "https://localhost:7878/fhir/CarePlan?_include=CarePlan%3AsupportingInfo&_include=CarePlan%3Acontributor&_profile=https%3A%2F%2Ffhir.cambio.se%2FStructureDefinition%2FCareplanCordinatedCareSe&category=https%3A%2F%2Fcambio.codes%2Fcs%2Fcare-plan-categories%7CSIP&subject=19830825-1456" } ], "entry": [ { "fullUrl": "https://localhost:7878/fhir/CarePlan/5502", "resource": { "resourceType": "CarePlan", "id": "5502", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/CareplanCordinatedCareSe" ] }, "contained": [ { "resourceType": "PractitionerRole", "id": "1", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/PractitionerRoleLiteSe/v1" ] }, "practitioner": { "reference": "Practitioner/523306", "type": "Practitioner" }, "organization": { "reference": "Organization/1064", "type": "Organization" } } ], "status": "active", "intent": "plan", "category": [ { "coding": [ { "system": "https://cambio.codes/cs/care-plan-categories", "code": "SIP", "display": "Samordnad individuell plan" } ] } ], "title": "SIP", "subject": { "type": "Patient", "identifier": { "system": "1.2.752.129.2.1.3.1", "value": "198308251456" } }, "created": "08/05/2022 09:25:00", "contributor": [ { "reference": "#1", "type": "PractitionerRole" } ], "supportingInfo": [ { "reference": "QuestionnaireResponse/198853", "type": "QuestionnaireResponse" } ] } }, { "fullUrl": "https://localhost:7878/fhir/QuestionnaireResponse/198853", "resource": { "resourceType": "QuestionnaireResponse", "id": "198853", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/QuestionnaireResponseSe/v1" ] }, "contained": [ { "resourceType": "PractitionerRole", "id": "1", "meta": { "profile": [ "https://fhir.cambio.se/StructureDefinition/PractitionerRoleLiteSe/v1" ] }, "practitioner": { "reference": "Practitioner/523306", "type": "Practitioner" }, "organization": { "reference": "Organization/1064", "type": "Organization" } } ], "questionnaire": "http://fhir.cambio.se/fhir/Questionnaire/1797|1797", "status": "?", "subject": { "reference": "Patient/10753", "type": "Patient" }, "authored": "08/05/2022 09:24:00", "author": { "reference": "#1", "type": "PractitionerRole" }, "item": [ { "linkId": "1797.1797.0.421", "answer": [ { "valueDecimal": 1 } ] } ] } }, { "fullUrl": "https://localhost:7878/fhir/Organization/1064", "resource": { "resourceType": "Organization", "id": "1064", "meta": { "versionId": "13337", "profile": [ "https://commonprofiles.care/StructureDefinition/OrganizationSEVendorLite/v1" ] }, "identifier": [ { "use": "secondary", "system": "https://cambio.codes/is/unit/lab-identifier", "value": "MEDKLIN" }, { "use": "official", "system": "urn:oid:1.2.752.129.2.1.4.1", "value": "SE162321000024-0016313" }, { "use": "secondary", "system": "https://cambio.codes/socialstyrelsen/is/arbetsplatskod", "value": "4000000000000" } ], "active": true, "type": [ { "coding": [ { "system": "https://cambio.codes/cs/unit-type", "code": "responsibleUnit" } ] }, { "coding": [ { "system": "https://cambio.codes/cs/unit-type", "code": "perfomingUnit" } ] }, { "coding": [ { "system": "https://cambio.codes/cs/unit-type", "code": "specialityDivision" } ] } ], "name": "Medicinkliniken", "telecom": [ { "system": "email", "value": "123@gmail.com" } ], "address": [ { "line": [ "234", "Sri lanka" ], "_line": [ { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-careOf", "valueString": "234" } ] }, { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-streetAddressLine", "valueString": "Sri lanka" } ] } ], "city": "gam", "postalCode": "test 123", "country": "SE" }, { "line": [ "123", "Sri lanka" ], "_line": [ { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-careOf", "valueString": "123" } ] }, { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-streetAddressLine", "valueString": "Sri lanka" } ] } ], "city": "col", "postalCode": "test post", "country": "SE" }, { "use": "work", "line": [ "222", "Sri Lanka" ], "_line": [ { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-careOf", "valueString": "222" } ] }, { "extension": [ { "url": "http://hl7.org/fhir/StructureDefinition/iso21090-ADXP-streetAddressLine", "valueString": "Sri Lanka" } ] } ], "city": "col", "postalCode": "222", "country": "SE" } ], "partOf": { "reference": "Organization/1060", "type": "Organization" } } } ] }