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: PatientAddresses

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

    
{
  "resourceType": "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/ViewDefinition",
  "select": [
    {
      "column": [
        {
          "path": "getResourceKey()",
          "name": "patient_id"
        }
      ]
    },
    {
      "column": [
        {
          "path": "line.join('\n')",
          "name": "street",
          "description": "The full street address, including newlines if present."
        },
        {
          "path": "use",
          "name": "use"
        },
        {
          "path": "city",
          "name": "city"
        },
        {
          "path": "postalCode",
          "name": "zip"
        }
      ],
      "forEach": "address"
    }
  ],
  "name": "patient_addresses",
  "status": "draft",
  "resource": "Patient"
}

Notes:

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

patient_id street use city zip
1 123 Main St\nApt 1 home San Diego 92101
1 456 Maplewood Dve\nApt 2 work New York 10001
2 789 Brookside Ave\nApt 3 home Los Angeles 90001
3 987 Pinehurst Rd\nApt 4 home Chicago 60601
3 654 Evergreen Tce\nApt 5 work Houston 77001