This fragment is not visible to the reader
This publication includes IP covered under the following statements.
| Type | Reference | Content |
|---|---|---|
| web | github.com | 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 |
| web | www.iso.org |
When _format=fhir, each result column SHALL be
encoded using a FHIR value[x] type.
The following table defines the mapping from
ISO/IEC 9075
SQL types to FHIR
parameter value types.
|
| web | www.iso.org | To maximize consistency across different view runners, implementations SHOULD align their output types to the following default type mappings from FHIR and FHIRPath types to ISO/IEC 9075 SQL types. |
| web | github.com | ViewDefinitions can be modeled and implemented using the functional paradigm. In fact, the JavaScript reference implementation takes such an approach. See Functional Model for a detailed examination of this approach. |
| web | github.com | The record begins at 3.0.0-ballot. Published version 2.0.0 shipped without a changelog, and reconstruction of one is out of scope. All changes below are stated relative to that release. For earlier material, see version 2.0.0 , released 2024-10-09, and the original SQL on FHIR draft . |
| web | github.com |
Delivered by #397
, tracked in
#395
, which remains open for
follow-up work in hapifhir/org.hl7.fhir.core
.
|
| web | github.com |
Delivered by #397
, tracked in
#395
, which remains open for
follow-up work in hapifhir/org.hl7.fhir.core
.
|
| web | github.com | Delivered by #387 , tracked in #377 . |
| web | github.com | Delivered by #387 , tracked in #377 . |
| web | github.com | Issue: #268 . |
| web | github.com | Issue: #301 . |
| web | github.com |
Version 2.0.0 shipped the shared test suite inside the package, as twenty JSON
files under tests/
. The suite is not included in the 3.0.0 package. It now
resides in FHIR/sql-on-fhir.js
and is
versioned with the reference implementation rather than with the
specification.
|
| web | github.com | ( 48f3607 ) |
| web | github.com | Issues: #392 , #394 , #369 . |
| web | github.com | Issues: #392 , #394 , #369 . |
| web | github.com | Issues: #392 , #394 , #369 . |
| web | github.com | SQLQuery: #293 and #309 , requested in #291 . SQLView: #364 , requested in #329 . |
| web | github.com | SQLQuery: #293 and #309 , requested in #291 . SQLView: #364 , requested in #329 . |
| web | github.com | SQLQuery: #293 and #309 , requested in #291 . SQLView: #364 , requested in #329 . |
| web | github.com | SQLQuery: #293 and #309 , requested in #291 . SQLView: #364 , requested in #329 . |
| web | github.com | SQLQuery: #293 and #309 , requested in #291 . SQLView: #364 , requested in #329 . |
| web | github.com |
select.repeat
traverses arbitrarily nested structures, such as
QuestionnaireResponse.item
, without prior knowledge of their depth. Together
with %rowIndex
it is one of the two additions to the expressive part of the
model; every other addition to ViewDefinition describes the view rather than
what it computes.
( #296
)
|
| web | github.com |
%rowIndex
provides the position of an element during iteration, so that the
ordering of elements in FHIR resources can be preserved in the output and
surrogate keys derived from it.
( #311
)
|
| web | github.com | A view can declare the profiles its input resources are expected to conform to. The element describes the view rather than changing what the view computes, so a runner that ignores it produces the same rows. ( #267 , requested in #265 ) |
| web | github.com | A view can declare the profiles its input resources are expected to conform to. The element describes the view rather than changing what the view computes, so a runner that ignores it produces the same rows. ( #267 , requested in #265 ) |
| web | github.com |
Becoming a resource brings the standard FHIR read and search machinery with it.
The guide publishes the standard metadata search parameters for ViewDefinition,
so a server can be queried for views by url
, identifier
, name
, status
,
publisher
, date
, context
and the remaining metadata parameters, in the
same manner as any other canonical resource. Version 2.0.0 provided no means of
discovering the views held by a server, because a logical model has no
endpoint.
( #397
)
|
| web | github.com | FHIR types and FHIRPath types now have default mappings to SQL types, so that two runners evaluating the same view produce comparable column types when no type hint is present. ( #290 ) |
| web | github.com |
Adoption of the standard metadata occurred in two steps. Deriving from
CanonicalResource
brought version
, versionAlgorithm[x]
, date
, purpose
and copyrightLabel
. Implementing MetadataResource
, alongside the move to a
resource, brought approvalDate
, lastReviewDate
, effectivePeriod
, topic
,
author
, editor
, reviewer
, endorser
and relatedArtifact
, and
jurisdiction
, which R6 deprecates in favor of useContext
. All are
optional. identifier
is the one element for which this change was not
additive.
( #268
,
#397
)
|
| web | github.com |
Adoption of the standard metadata occurred in two steps. Deriving from
CanonicalResource
brought version
, versionAlgorithm[x]
, date
, purpose
and copyrightLabel
. Implementing MetadataResource
, alongside the move to a
resource, brought approvalDate
, lastReviewDate
, effectivePeriod
, topic
,
author
, editor
, reviewer
, endorser
and relatedArtifact
, and
jurisdiction
, which R6 deprecates in favor of useContext
. All are
optional. identifier
is the one element for which this change was not
additive.
( #268
,
#397
)
|
| web | github.com | Issues: #293 , #309 , #351 , #365 . |
| web | github.com | Issues: #293 , #309 , #351 , #365 . |
| web | github.com | Issues: #293 , #309 , #351 , #365 . |
| web | github.com | Issues: #293 , #309 , #351 , #365 . |
| web | github.com |
SUSHI does not support additional resources, so ViewDefinition, its profiles
and its examples are now authored directly as XML and JSON. The authoring
format carries no semantics of its own, but the change it enabled does: the
examples are now published as ViewDefinition resources rather than as Binary
,
and the guide gained search parameters for ViewDefinition and a list of its
operations. ( #397
)
|
| web | github.com |
None of these messages reflects a conformance change. Each is suppressed in
input/ignoreWarnings.txt
with a written justification and a link to the
discussion that established it.
( #399
)
|
| web | github.com |
Links to build.fhir.org
were replaced with links to published versions
( #386
). Code systems and value
sets were assigned OIDs from the root arc registered for this guide
( #381
). The repository license
text was replaced with the verbatim CC0 1.0 Universal dedication, matching the
CC0-1.0
license the guide already declared, and the contribution statement
required by the HL7 Governance and Operations Manual was added
( ff21894
,
3093259
).
|
| web | github.com |
Links to build.fhir.org
were replaced with links to published versions
( #386
). Code systems and value
sets were assigned OIDs from the root arc registered for this guide
( #381
). The repository license
text was replaced with the verbatim CC0 1.0 Universal dedication, matching the
CC0-1.0
license the guide already declared, and the contribution statement
required by the HL7 Governance and Operations Manual was added
( ff21894
,
3093259
).
|
| web | github.com |
Links to build.fhir.org
were replaced with links to published versions
( #386
). Code systems and value
sets were assigned OIDs from the root arc registered for this guide
( #381
). The repository license
text was replaced with the verbatim CC0 1.0 Universal dedication, matching the
CC0-1.0
license the guide already declared, and the contribution statement
required by the HL7 Governance and Operations Manual was added
( ff21894
,
3093259
).
|
| web | github.com |
Links to build.fhir.org
were replaced with links to published versions
( #386
). Code systems and value
sets were assigned OIDs from the root arc registered for this guide
( #381
). The repository license
text was replaced with the verbatim CC0 1.0 Universal dedication, matching the
CC0-1.0
license the guide already declared, and the contribution statement
required by the HL7 Governance and Operations Manual was added
( ff21894
,
3093259
).
|
| web | github.com | The JavaScript reference implementation, the shared test suite and the test report site now reside in FHIR/sql-on-fhir.js . This repository holds the specification alone, and moved to HL7/sql-on-fhir . ( 48f3607 , 8a9c98f ) |
| web | github.com | The JavaScript reference implementation, the shared test suite and the test report site now reside in FHIR/sql-on-fhir.js . This repository holds the specification alone, and moved to HL7/sql-on-fhir . ( 48f3607 , 8a9c98f ) |
| web | github.com | The JavaScript reference implementation, the shared test suite and the test report site now reside in FHIR/sql-on-fhir.js . This repository holds the specification alone, and moved to HL7/sql-on-fhir . ( 48f3607 , 8a9c98f ) |
| web | github.com | The JavaScript reference implementation, the shared test suite and the test report site now reside in FHIR/sql-on-fhir.js . This repository holds the specification alone, and moved to HL7/sql-on-fhir . ( 48f3607 , 8a9c98f ) |
| web | github.com |
The introduction was restructured around the three components of the
specification, and the query and operations sections were added.
Inconsistencies across the operation definitions were reconciled: return type,
Bundle unwrapping, Accept
semantics, supported _format
values, streaming
guidance and the completion status code.
( #325
,
#300
,
#365
closing
#358
- #363
)
|
| web | github.com |
The introduction was restructured around the three components of the
specification, and the query and operations sections were added.
Inconsistencies across the operation definitions were reconciled: return type,
Bundle unwrapping, Accept
semantics, supported _format
values, streaming
guidance and the completion status code.
( #325
,
#300
,
#365
closing
#358
- #363
)
|
| web | github.com |
The introduction was restructured around the three components of the
specification, and the query and operations sections were added.
Inconsistencies across the operation definitions were reconciled: return type,
Bundle unwrapping, Accept
semantics, supported _format
values, streaming
guidance and the completion status code.
( #325
,
#300
,
#365
closing
#358
- #363
)
|
| web | github.com |
The introduction was restructured around the three components of the
specification, and the query and operations sections were added.
Inconsistencies across the operation definitions were reconciled: return type,
Bundle unwrapping, Accept
semantics, supported _format
values, streaming
guidance and the completion status code.
( #325
,
#300
,
#365
closing
#358
- #363
)
|
| web | github.com |
The introduction was restructured around the three components of the
specification, and the query and operations sections were added.
Inconsistencies across the operation definitions were reconciled: return type,
Bundle unwrapping, Accept
semantics, supported _format
values, streaming
guidance and the completion status code.
( #325
,
#300
,
#365
closing
#358
- #363
)
|
| web | github.com | Contribute issues or pull requests on GitHub |
| web | github.com | Register your implementation and have it added to our test report |
| web | www.health-samurai.io | Health Samurai |
| web | www.healthdevhub.com | Health Dev Hub |
| web | github.com | The JavaScript reference implementation implements the functional model described here. It is very concise at roughly 400 lines of code and reading it is a good way to understand the model in detail. |
| web | github.com | This is an evolution of the original "SQL on FHIR" draft, which can still be found here . |
| web | creativecommons.org | This implementation guide is published under the Creative Commons CC0 1.0 Universal public domain dedication. CC0 is the licensing mechanism applied to HL7 FHIR products under section 09.01.05 of the HL7 Governance and Operations Manual (GOM). |
|
../assets/images/001.svg
|
|
help.png
|
|
layers.jpg
|
|
tree-filter.png
|
|
viewdef-runners.jpeg
|