SQL on FHIR
2.0.0 - release International flag

This page is part of the SQL on FHIR (v2.0.0: Release) based on FHIR (HL7® FHIR® Standard) v5.0.0. This is the current published version. For a full list of available versions, see the Directory of published versions

Example Binary: PatientAndContactAddressUnion

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",
  "select": [
    {
      "column": [
        {
          "path": "getResourceKey()",
          "name": "resource_id"
        }
      ],
      "unionAll": [
        {
          "column": [
            {
              "path": "line.join('\n')",
              "name": "street"
            },
            {
              "path": "city",
              "name": "city"
            },
            {
              "path": "postalCode",
              "name": "zip"
            },
            {
              "path": "true",
              "name": "is_patient"
            }
          ],
          "forEach": "address"
        },
        {
          "column": [
            {
              "path": "line.join('\n')",
              "name": "street"
            },
            {
              "path": "city",
              "name": "city"
            },
            {
              "path": "postalCode",
              "name": "zip"
            },
            {
              "path": "false",
              "name": "is_patient"
            }
          ],
          "forEach": "contact.address"
        }
      ]
    }
  ],
  "name": "patient_and_contact_addresses",
  "status": "draft",
  "resource": "Patient"
}

Notes:

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

resource_id street city zip is_patient
1 123 Main St\nApt 1 San Diego 92101 true
1 456 Maplewood Dve\nApt 2 New York 10001 true
1 456 Maplewood Dve\nApt 2 New York 10001 false
2 789 Brookside Ave\nApt 3 Los Angeles 90001 true
2 987 Pinehurst Rd\nApt 4 Chicago 60601 false