Class: WhereClause
A conditional element that describes the circumstances under which a containing context applies, linking conditions to structures where they are used
URI: [odm:class/WhereClause](https://cdisc.org/odm2/class/WhereClause)
[Condition](../classes/Condition.md) | Logical conditions that apply in this context (combined with AND) | direct | | [OID](../slots/OID.md) | 1
[String](../types/String.md) | Local identifier within this study/context. Use CDISC OID format for regulatory submissions, or simple strings for internal use. | [Identifiable](../classes/Identifiable.md) | | [uuid](../slots/uuid.md) | 0..1
[String](../types/String.md) | Universal unique identifier | [Identifiable](../classes/Identifiable.md) | | [name](../slots/name.md) | 0..1
[String](../types/String.md) | Short name or identifier, used for field names | [Labelled](../classes/Labelled.md) | | [description](../slots/description.md) | 0..1
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Detailed description, shown in tooltips | [Labelled](../classes/Labelled.md) | | [coding](../slots/coding.md) | *
[Coding](../classes/Coding.md) | Semantic tags for this element | [Labelled](../classes/Labelled.md) | | [label](../slots/label.md) | 0..1
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Human-readable label, shown in UIs | [Labelled](../classes/Labelled.md) | | [aliases](../slots/aliases.md) | *
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Alternative name or identifier | [Labelled](../classes/Labelled.md) | | [mandatory](../slots/mandatory.md) | 0..1
[Boolean](../types/Boolean.md) | Is this element required? | [Governed](../classes/Governed.md) | | [comments](../slots/comments.md) | *
[Comment](../classes/Comment.md) | Comment on the element, such as a rationale for its inclusion or exclusion | [Governed](../classes/Governed.md) | | [siteOrSponsorComments](../slots/siteOrSponsorComments.md) | *
[SiteOrSponsorComment](../classes/SiteOrSponsorComment.md) | Comment on the element, such as a rationale for its inclusion or exclusion | [Governed](../classes/Governed.md) | | [purpose](../slots/purpose.md) | 0..1
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Purpose or rationale for this data element | [Governed](../classes/Governed.md) | | [lastUpdated](../slots/lastUpdated.md) | 0..1
[Datetime](../types/Datetime.md) | When the resource was last updated | [Governed](../classes/Governed.md) | | [owner](../slots/owner.md) | 0..1
[String](../types/String.md) or
[User](../classes/User.md) or
[Organization](../classes/Organization.md) | Party responsible for this element | [Governed](../classes/Governed.md) | | [wasDerivedFrom](../slots/wasDerivedFrom.md) | 0..1
[String](../types/String.md) or
[Item](../classes/Item.md) or
[ItemGroup](../classes/ItemGroup.md) or
[MetaDataVersion](../classes/MetaDataVersion.md) or
[CodeList](../classes/CodeList.md) or
[ReifiedConcept](../classes/ReifiedConcept.md) or
[ConceptProperty](../classes/ConceptProperty.md) or
[Condition](../classes/Condition.md) or
[Method](../classes/Method.md) or
[NominalOccurrence](../classes/NominalOccurrence.md) or
[Dataflow](../classes/Dataflow.md) or
[CubeComponent](../classes/CubeComponent.md) or
[DataProduct](../classes/DataProduct.md) or
[ProvisionAgreement](../classes/ProvisionAgreement.md) | Reference to another item that this item implements or extends, e.g. a template Item definition. | [Governed](../classes/Governed.md) | ## Usages | used by | used in | type | used | | --- | --- | --- | --- | | [MetaDataVersion](../classes/MetaDataVersion.md) | [whereClauses](../slots/whereClauses.md) | range | [WhereClause](../classes/WhereClause.md) | | [Item](../classes/Item.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [ItemGroup](../classes/ItemGroup.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [Parameter](../classes/Parameter.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [DataStructureDefinition](../classes/DataStructureDefinition.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [Analysis](../classes/Analysis.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | ## Identifier and Mapping Information ### Schema Source * from schema: https://cdisc.org/dds ## Mappings | Mapping Type | Mapped Value | | --- | --- | | self | odm:WhereClause | | native | odm:WhereClause | | related | fhir:StructureDefinition/context, qb:ObservationGroup, qb:Slice, sdmx:CubeRegion, sdmx:MetadataTargetRegion | | close | sdmx:AttachmentConstraint | ## LinkML Source ### Direct
### Induced
erDiagram
Coding {
AliasPredicate aliasType
string code
string codeSystem
string codeSystemVersion
string decode
}
Comment {
string text
string name
string description
string OID
stringList aliases
string label
datetime lastUpdated
boolean mandatory
string owner
string purpose
string uuid
string wasDerivedFrom
}
Condition {
string implementsCondition
LogicalOperator operator
string name
string description
string OID
stringList aliases
string label
datetime lastUpdated
boolean mandatory
string owner
string purpose
string uuid
string wasDerivedFrom
}
FormalExpression {
string expression
string returnType
string context
string name
string description
string OID
stringList aliases
string label
string uuid
}
RangeCheck {
stringList checkValues
Comparator comparator
string item
SoftHard softHard
LogicalOperator operator
}
SiteOrSponsorComment {
OriginSource sourceType
string source
string text
string name
string description
string OID
stringList aliases
string label
datetime lastUpdated
boolean mandatory
string owner
string purpose
string uuid
string wasDerivedFrom
}
WhereClause {
string name
string description
string OID
stringList aliases
string label
datetime lastUpdated
boolean mandatory
string owner
string purpose
string uuid
string wasDerivedFrom
}
Comment ||--}o Coding : "coding"
Comment ||--}o Comment : "comments"
Comment ||--}o DocumentReference : "documents"
Comment ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
Condition ||--}o Coding : "coding"
Condition ||--}o Comment : "comments"
Condition ||--}o Condition : "conditions"
Condition ||--}o FormalExpression : "expressions"
Condition ||--}o RangeCheck : "rangeChecks"
Condition ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
FormalExpression ||--|o ReturnValue : "returnValue"
FormalExpression ||--}o Coding : "coding"
FormalExpression ||--}o Parameter : "parameters"
FormalExpression ||--}o Resource : "externalCodeLibs"
RangeCheck ||--}o FormalExpression : "expressions"
SiteOrSponsorComment ||--}o Coding : "coding"
SiteOrSponsorComment ||--}o Comment : "comments"
SiteOrSponsorComment ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
WhereClause ||--}o Coding : "coding"
WhereClause ||--}o Comment : "comments"
WhereClause ||--}o Condition : "conditions"
WhereClause ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
## Inheritance
* [GovernedElement](../classes/GovernedElement.md) [ [Identifiable](../classes/Identifiable.md) [Labelled](../classes/Labelled.md) [Governed](../classes/Governed.md)]
* **WhereClause**
## Slots
| Name | Cardinality and Range | Description | Inheritance |
| --- | --- | --- | --- |
| [conditions](../slots/conditions.md) | * [Condition](../classes/Condition.md) | Logical conditions that apply in this context (combined with AND) | direct | | [OID](../slots/OID.md) | 1
[String](../types/String.md) | Local identifier within this study/context. Use CDISC OID format for regulatory submissions, or simple strings for internal use. | [Identifiable](../classes/Identifiable.md) | | [uuid](../slots/uuid.md) | 0..1
[String](../types/String.md) | Universal unique identifier | [Identifiable](../classes/Identifiable.md) | | [name](../slots/name.md) | 0..1
[String](../types/String.md) | Short name or identifier, used for field names | [Labelled](../classes/Labelled.md) | | [description](../slots/description.md) | 0..1
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Detailed description, shown in tooltips | [Labelled](../classes/Labelled.md) | | [coding](../slots/coding.md) | *
[Coding](../classes/Coding.md) | Semantic tags for this element | [Labelled](../classes/Labelled.md) | | [label](../slots/label.md) | 0..1
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Human-readable label, shown in UIs | [Labelled](../classes/Labelled.md) | | [aliases](../slots/aliases.md) | *
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Alternative name or identifier | [Labelled](../classes/Labelled.md) | | [mandatory](../slots/mandatory.md) | 0..1
[Boolean](../types/Boolean.md) | Is this element required? | [Governed](../classes/Governed.md) | | [comments](../slots/comments.md) | *
[Comment](../classes/Comment.md) | Comment on the element, such as a rationale for its inclusion or exclusion | [Governed](../classes/Governed.md) | | [siteOrSponsorComments](../slots/siteOrSponsorComments.md) | *
[SiteOrSponsorComment](../classes/SiteOrSponsorComment.md) | Comment on the element, such as a rationale for its inclusion or exclusion | [Governed](../classes/Governed.md) | | [purpose](../slots/purpose.md) | 0..1
[String](../types/String.md) or
[TranslatedText](../classes/TranslatedText.md) | Purpose or rationale for this data element | [Governed](../classes/Governed.md) | | [lastUpdated](../slots/lastUpdated.md) | 0..1
[Datetime](../types/Datetime.md) | When the resource was last updated | [Governed](../classes/Governed.md) | | [owner](../slots/owner.md) | 0..1
[String](../types/String.md) or
[User](../classes/User.md) or
[Organization](../classes/Organization.md) | Party responsible for this element | [Governed](../classes/Governed.md) | | [wasDerivedFrom](../slots/wasDerivedFrom.md) | 0..1
[String](../types/String.md) or
[Item](../classes/Item.md) or
[ItemGroup](../classes/ItemGroup.md) or
[MetaDataVersion](../classes/MetaDataVersion.md) or
[CodeList](../classes/CodeList.md) or
[ReifiedConcept](../classes/ReifiedConcept.md) or
[ConceptProperty](../classes/ConceptProperty.md) or
[Condition](../classes/Condition.md) or
[Method](../classes/Method.md) or
[NominalOccurrence](../classes/NominalOccurrence.md) or
[Dataflow](../classes/Dataflow.md) or
[CubeComponent](../classes/CubeComponent.md) or
[DataProduct](../classes/DataProduct.md) or
[ProvisionAgreement](../classes/ProvisionAgreement.md) | Reference to another item that this item implements or extends, e.g. a template Item definition. | [Governed](../classes/Governed.md) | ## Usages | used by | used in | type | used | | --- | --- | --- | --- | | [MetaDataVersion](../classes/MetaDataVersion.md) | [whereClauses](../slots/whereClauses.md) | range | [WhereClause](../classes/WhereClause.md) | | [Item](../classes/Item.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [ItemGroup](../classes/ItemGroup.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [Parameter](../classes/Parameter.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [DataStructureDefinition](../classes/DataStructureDefinition.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | | [Analysis](../classes/Analysis.md) | [applicableWhen](../slots/applicableWhen.md) | range | [WhereClause](../classes/WhereClause.md) | ## Identifier and Mapping Information ### Schema Source * from schema: https://cdisc.org/dds ## Mappings | Mapping Type | Mapped Value | | --- | --- | | self | odm:WhereClause | | native | odm:WhereClause | | related | fhir:StructureDefinition/context, qb:ObservationGroup, qb:Slice, sdmx:CubeRegion, sdmx:MetadataTargetRegion | | close | sdmx:AttachmentConstraint | ## LinkML Source ### Direct
name: WhereClause
description: A conditional element that describes the circumstances under which a
containing context applies, linking conditions to structures where they are used
from_schema: https://cdisc.org/dds
close_mappings:
- sdmx:AttachmentConstraint
related_mappings:
- fhir:StructureDefinition/context
- qb:ObservationGroup
- qb:Slice
- sdmx:CubeRegion
- sdmx:MetadataTargetRegion
is_a: GovernedElement
attributes:
conditions:
name: conditions
description: Logical conditions that apply in this context (combined with AND)
from_schema: https://cdisc.org/dds
domain_of:
- MetaDataVersion
- WhereClause
- Condition
- Parameter
range: Condition
multivalued: true
inlined: false
name: WhereClause
description: A conditional element that describes the circumstances under which a
containing context applies, linking conditions to structures where they are used
from_schema: https://cdisc.org/dds
close_mappings:
- sdmx:AttachmentConstraint
related_mappings:
- fhir:StructureDefinition/context
- qb:ObservationGroup
- qb:Slice
- sdmx:CubeRegion
- sdmx:MetadataTargetRegion
is_a: GovernedElement
attributes:
conditions:
name: conditions
description: Logical conditions that apply in this context (combined with AND)
from_schema: https://cdisc.org/dds
owner: WhereClause
domain_of:
- MetaDataVersion
- WhereClause
- Condition
- Parameter
range: Condition
multivalued: true
inlined: false
OID:
name: OID
description: Local identifier within this study/context. Use CDISC OID format
for regulatory submissions, or simple strings for internal use.
from_schema: https://cdisc.org/dds
rank: 1000
identifier: true
owner: WhereClause
domain_of:
- Identifiable
range: string
required: true
uuid:
name: uuid
description: Universal unique identifier
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Identifiable
range: string
name:
name: name
description: Short name or identifier, used for field names
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Labelled
- DefClass
- SubClass
- Standard
range: string
description:
name: description
description: Detailed description, shown in tooltips
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Labelled
- CodeListItem
range: string
any_of:
- range: string
- range: TranslatedText
coding:
name: coding
description: Semantic tags for this element
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Labelled
- CodeListItem
- SourceItem
range: Coding
multivalued: true
inlined: true
inlined_as_list: true
label:
name: label
description: Human-readable label, shown in UIs
from_schema: https://cdisc.org/dds
exact_mappings:
- skos:prefLabel
rank: 1000
owner: WhereClause
domain_of:
- Labelled
range: string
any_of:
- range: string
- range: TranslatedText
aliases:
name: aliases
description: Alternative name or identifier
from_schema: https://cdisc.org/dds
exact_mappings:
- skos:altLabel
rank: 1000
owner: WhereClause
domain_of:
- Labelled
- CodeListItem
range: string
multivalued: true
inlined: true
inlined_as_list: true
any_of:
- range: string
- range: TranslatedText
mandatory:
name: mandatory
description: Is this element required?
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Governed
range: boolean
comments:
name: comments
description: Comment on the element, such as a rationale for its inclusion or
exclusion
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Governed
range: Comment
multivalued: true
inlined: false
siteOrSponsorComments:
name: siteOrSponsorComments
description: Comment on the element, such as a rationale for its inclusion or
exclusion
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Governed
range: SiteOrSponsorComment
multivalued: true
inlined: false
purpose:
name: purpose
description: Purpose or rationale for this data element
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Governed
range: string
any_of:
- range: string
- range: TranslatedText
lastUpdated:
name: lastUpdated
description: When the resource was last updated
from_schema: https://cdisc.org/dds
rank: 1000
owner: WhereClause
domain_of:
- Governed
range: datetime
owner:
name: owner
description: Party responsible for this element
from_schema: https://cdisc.org/dds
narrow_mappings:
- prov:wasAttributedTo
- prov:wasAssociatedBy
rank: 1000
owner: WhereClause
domain_of:
- Governed
range: string
any_of:
- range: User
- range: Organization
- range: string
wasDerivedFrom:
name: wasDerivedFrom
description: Reference to another item that this item implements or extends, e.g.
a template Item definition.
from_schema: https://cdisc.org/dds
exact_mappings:
- prov:wasDerivedFrom
rank: 1000
owner: WhereClause
domain_of:
- Governed
range: string
any_of:
- range: Item
- range: ItemGroup
- range: MetaDataVersion
- range: CodeList
- range: ReifiedConcept
- range: ConceptProperty
- range: Condition
- range: Method
- range: NominalOccurrence
- range: Dataflow
- range: CubeComponent
- range: DataProduct
- range: ProvisionAgreement