SQL on FHIR
2.1.0-pre - ci-build 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 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/HL7/sql-on-fhir/ and changes regularly. See the Directory of published versions

Library: Active Patients

Official URL: http://hl7.org/fhir/uv/sql-on-fhir/Library/ActivePatientsView Version: 2.1.0-pre
Standards status: Informative Computable Name: ActivePatientsView
Other Identifiers: OID:2.16.840.1.113883.4.642.40.77.28.2

Selects the identifier, name, and birth date of every active patient. Other queries reference this view by its canonical URL and use the active_patients label as a table name.

SELECT
  patient_view.id AS patient_id,
  patient_view.name AS patient_name,
  patient_view.birth_date
FROM patient_view
WHERE patient_view.active = true

Title: Active Patients
Id: ActivePatientsView
Version: 2.1.0-pre
Url: Active Patients

urn:oid:2.16.840.1.113883.4.642.40.77.28.2

Type:

system: http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/LibraryTypesCodes

code: sql-view

Date: 2026-07-28 04:38:44+0000
Publisher: HL7 International / FHIR Infrastructure
Description:

Selects the identifier, name, and birth date of every active patient. Other queries reference this view by its canonical URL and use the active_patients label as a table name.

SELECT
  patient_view.id AS patient_id,
  patient_view.name AS patient_name,
  patient_view.birth_date
FROM patient_view
WHERE patient_view.active = true
Jurisdiction: 001
Related Artifacts:

Dependencies

  • https://example.org/ViewDefinition/patient_view
Content: application/sql
Encoded data (204 characters)