Patient Names with Index - SQL on FHIR v3.0.0-ballot

SQL on FHIR
3.0.0-ballot - STU 3 Ballot International flag

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

Example ViewDefinition: Patient Names with Index

This view acts on the Patient resource to produce a table named "patient_names_with_index".

The table contains the following columns:

Name	Fhir Type	SQL Type	Notes
patient_id	string	String
use	string	String	This column is not defined as a collection, but the path statement 'use' might return multiple values for the column 'use' for some inputs
family	string	String	This column is not defined as a collection, but the path statement 'family' might return multiple values for the column 'family' for some inputs
given	string	String

Name

Fhir Type

SQL Type

Collection

Notes

patient_id

string

String

use

string

String

This column is not defined as a collection, but the path statement 'use' might return multiple values for the column 'use' for some inputs

family

string

String

This column is not defined as a collection, but the path statement 'family' might return multiple values for the column 'family' for some inputs

given

string

String

Selection Rules:

Item	Type	Description
patient_names_with_index	Patient
Select
patient_id		`getResourceKey()`
Select		for each `name`
name_index	integer	`%rowIndex` The 0-based position of this name in the patient's name array.
use		`use`
family		`family`
given		`given.join(' ')`

IG © 2023+ HL7 International / FHIR Infrastructure. Package hl7.fhir.uv.sql-on-fhir#3.0.0-ballot based on FHIR 6.0.0-ballot5. Generated 2026-08-13
Links: Table of Contents | QA Report | Version History | | Propose a change