SQL on FHIR
2.1.0-pre - release International flag

SQL on FHIR, published by SQL on FHIR Working Group. This guide is not an authorized publication; it is the continuous build for version 2.1.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: PatientNamesWithIndex

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

    
{
  "resourceType": "https://sql-on-fhir.org/ig/StructureDefinition/ViewDefinition",
  "id": "PatientNamesWithIndex",
  "select": [
    {
      "column": [
        {
          "path": "getResourceKey()",
          "name": "patient_id"
        }
      ]
    },
    {
      "column": [
        {
          "path": "%rowIndex",
          "name": "name_index",
          "type": "integer",
          "description": "The 0-based position of this name in the patient's name array."
        },
        {
          "path": "use",
          "name": "use"
        },
        {
          "path": "family",
          "name": "family"
        },
        {
          "path": "given.join(' ')",
          "name": "given"
        }
      ],
      "forEach": "name"
    }
  ],
  "name": "patient_names_with_index",
  "status": "draft",
  "resource": "Patient"
}