SQL on FHIR
2.0.0-pre - ci-build International flag

SQL on FHIR, published by HL7. This guide is not an authorized publication; it is the continuous build for version 2.0.0-pre built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/FHIR/sql-on-fhir-v2/ and changes regularly. See the Directory of published versions

Example Binary: ShareablePatientDemographics

This content is an example of the Shareable View Definition Logical Model and is not a FHIR Resource

    
{
  "resourceType": "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/ViewDefinition",
  "meta": {
    "profile": [
      "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/ShareableViewDefinition",
      "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/TabularViewDefinition"
    ]
  },
  "fhirVersion": [
    "4.0",
    "5.0"
  ],
  "select": [
    {
      "column": [
        {
          "path": "getResourceKey()",
          "name": "id",
          "type": "string"
        },
        {
          "path": "gender",
          "name": "gender",
          "type": "code"
        }
      ]
    },
    {
      "column": [
        {
          "path": "given.join(' ')",
          "name": "given_name",
          "description": "A single given name field with all names joined together.",
          "type": "string"
        },
        {
          "path": "family",
          "name": "family_name",
          "type": "string"
        }
      ],
      "forEach": "name.where(use = 'official').first()"
    }
  ],
  "url": "http://example.com/ShareablePatientDemographics",
  "name": "patient_demographics",
  "status": "draft",
  "resource": "Patient"
}

Notes:

This will result in a "patient_demographics" table that looks like this:

id gender given_name family_name
1 female Malvina Gerda Vicario
2 male Yolotzin Adel Bristow
3 other Jin Gomer Aarens