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

Extension: SQL Text

Official URL: http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text Version: 3.0.0-ballot
Standards status: Trial-use Maturity Level: 2 Computable Name: SqlText
Other Identifiers: OID:2.16.840.1.113883.4.642.40.77.42.6

Plain-text SQL query for human readability. Supplements the base64-encoded Attachment.data.

Context of Use

    This extension may be used on the following element(s)

Usage info

Usages:

You can also check for usages in the FHIR IG Statistics

Formal Views of Extension Content

Description Differentials, Snapshots, and other representations.

NameFlagsCard.TypeDescription & Constraints    Filter: Filtersdoco
.. Extension 0..* Extension SQL Text
... extension 0..0 Extension
... url 1..1 uri "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text"
... value[x] 1..1 string Value of extension

doco Documentation for this format
NameFlagsCard.TypeDescription & Constraints    Filter: Filtersdoco
.. Extension 0..* Extension SQL Text
... id 0..1 string Unique id for inter-element referencing
... extension 0..0 Extension
Slice: Unordered, Open by value:url
... url Σ 1..1 uri "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text"

doco Documentation for this format

Constraints

Id Grade Path(s) Description Expression
ele-1 error **ALL** elements All FHIR elements must have a @value or children hasValue() or (children().count() > id.count())
ext-1 error **ALL** extensions Must have either extensions or value[x], not both extension.exists() != value.exists()

Summary

Simple Extension with the type string: Plain-text SQL query for human readability. Supplements the base64-encoded Attachment.data.

Maturity: 2

Differential ViewDifferential View

NameFlagsCard.TypeDescription & Constraints    Filter: Filtersdoco
.. Extension 0..* Extension SQL Text
... extension 0..0 Extension
... url 1..1 uri "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text"
... value[x] 1..1 string Value of extension

doco Documentation for this format

Snapshot View

NameFlagsCard.TypeDescription & Constraints    Filter: Filtersdoco
.. Extension 0..* Extension SQL Text
... id 0..1 string Unique id for inter-element referencing
... extension 0..0 Extension
Slice: Unordered, Open by value:url
... url Σ 1..1 uri "http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text"

doco Documentation for this format

Constraints

Id Grade Path(s) Description Expression
ele-1 error **ALL** elements All FHIR elements must have a @value or children hasValue() or (children().count() > id.count())
ext-1 error **ALL** extensions Must have either extensions or value[x], not both extension.exists() != value.exists()

Summary

Simple Extension with the type string: Plain-text SQL query for human readability. Supplements the base64-encoded Attachment.data.

Maturity: 2

 

Other representations of profile: CSV, Excel, Schematron