SQL on FHIR
2.1.0-pre - release International flag

SQL on FHIR - Local Development build (v2.1.0-pre) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions

Example ViewDefinition: PatientAndContactAddressUnion

draft

Generated Narrative: ViewDefinition PatientAndContactAddressUnion

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

The table contains the following columns:

NameFhir TypeSQL TypeCollection
resource_idstringString

Selection Rules:

ItemCollTypeDescription
.. patient_and_contact_addressesPatient
... Select
.... resource_idgetResourceKey()