Class: WhereClause

Selection criteria defined as either a simple condition ([variable] [comparator] [value(s)]) or a compound expression that may combine simple conditions or compound expressions.

URI: ars:WhereClause

 classDiagram
    class WhereClause
      LevelOrder <|-- WhereClause
      WhereClause <|-- SubClause
      WhereClause <|-- AnalysisSet
      WhereClause <|-- DataSubset
      WhereClause <|-- Group
            
      WhereClause : condition
        WhereClause --|> WhereClauseCondition : condition
        
      WhereClause : compoundExpression
        WhereClause --|> WhereClauseCompoundExpression : compoundExpression
        
      WhereClause : level
        
      WhereClause : order

Inheritance

Slots

Name Cardinality* and Range Description Inheritance
condition 0..1
WhereClauseCondition		 A simple selection criterion exressed as [dataset] direct
compoundExpression 0..1
WhereClauseCompoundExpression		 A compound expression that combines or negates where clauses direct
level 1..1
Integer		 The level of the entry within a hierarchical structure LevelOrder
order 1..1
Integer		 The ordinal of the instance with respect to other instances LevelOrder

* See LinkML documentation for cardinality definitions.

Comments

  • Each instance of this class should have either a condition or a compoundExpression, not both.

Identifier and Mapping Information

Schema Source

  • from schema: https://www.cdisc.org/ars/1-0

Mappings

Mapping Type Mapped Value
self ars:WhereClause
native ars:WhereClause

Examples

Example: WhereClause-01 condition

# Simple condition: (ADSL.SAFFL EQ 'Y')
order: 1
level: 1
condition:
  dataset: ADSL
  variable: SAFFL
  comparator: EQ
  value:
  - Y

Example: WhereClause-02 compoundExpression

# Compound expression: (    ADAE.TRTEMFL EQ 'Y'
#                       AND ADAE.AESDTH EQ 'Y'
#                       AND (   ADAE.AEREL EQ 'POSSIBLE'
#                            OR ADAE.AEREL EQ 'PROBABLE'))
level: 1
order: 1
compoundExpression:
  logicalOperator: AND
  whereClauses:
  - level: 2
    order: 1
    condition:
      dataset: ADAE
      variable: TRTEMFL
      comparator: EQ
      value:
      - Y
  - level: 2
    order: 2
    condition:
      dataset: ADAE
      variable: AESDTH
      comparator: EQ
      value:
      - Y
  - level: 2
    order: 3
    compoundExpression:
      logicalOperator: OR
      whereClauses:
      - level: 3
        order: 1
        condition:
          dataset: ADAE
          variable: AEREL
          comparator: EQ
          value:
          - POSSIBLE
      - level: 3
        order: 2
        condition:
          dataset: ADAE
          variable: AEREL
          comparator: EQ
          value:
          - PROBABLE

LinkML Source

Direct

name: WhereClause
description: Selection criteria defined as either a simple condition ([variable] [comparator]
  [value(s)]) or a compound expression that may combine simple conditions or compound
  expressions.
comments:
- Each instance of this class should have either a condition or a compoundExpression,
  not both.
from_schema: https://www.cdisc.org/ars/1-0
rank: 1000
mixins:
- LevelOrder
slots:
- condition
- compoundExpression
slot_usage:
  compoundExpression:
    name: compoundExpression
    domain_of:
    - WhereClause
    range: WhereClauseCompoundExpression
    any_of:
    - range: CompoundSetExpression
      inlined: true
      inlined_as_list: true
    - range: CompoundSubsetExpression
      inlined: true
      inlined_as_list: true
    - range: CompoundGroupExpression
      inlined: true
      inlined_as_list: true

Induced

name: WhereClause
description: Selection criteria defined as either a simple condition ([variable] [comparator]
  [value(s)]) or a compound expression that may combine simple conditions or compound
  expressions.
comments:
- Each instance of this class should have either a condition or a compoundExpression,
  not both.
from_schema: https://www.cdisc.org/ars/1-0
rank: 1000
mixins:
- LevelOrder
slot_usage:
  compoundExpression:
    name: compoundExpression
    domain_of:
    - WhereClause
    range: WhereClauseCompoundExpression
    any_of:
    - range: CompoundSetExpression
      inlined: true
      inlined_as_list: true
    - range: CompoundSubsetExpression
      inlined: true
      inlined_as_list: true
    - range: CompoundGroupExpression
      inlined: true
      inlined_as_list: true
attributes:
  condition:
    name: condition
    description: A simple selection criterion exressed as [dataset].[variable] [comparator]
      [value(s)]
    from_schema: https://www.cdisc.org/ars/1-0
    rank: 1000
    alias: condition
    owner: WhereClause
    domain_of:
    - WhereClause
    range: WhereClauseCondition
  compoundExpression:
    name: compoundExpression
    description: A compound expression that combines or negates where clauses.
    from_schema: https://www.cdisc.org/ars/1-0
    rank: 1000
    alias: compoundExpression
    owner: WhereClause
    domain_of:
    - WhereClause
    range: WhereClauseCompoundExpression
    any_of:
    - range: CompoundSetExpression
      inlined: true
      inlined_as_list: true
    - range: CompoundSubsetExpression
      inlined: true
      inlined_as_list: true
    - range: CompoundGroupExpression
      inlined: true
      inlined_as_list: true
  level:
    name: level
    description: The level of the entry within a hierarchical structure.
    comments:
    - 1 is the top level.
    from_schema: https://www.cdisc.org/ars/1-0
    rank: 1000
    alias: level
    owner: WhereClause
    domain_of:
    - LevelOrder
    range: integer
    required: true
  order:
    name: order
    description: The ordinal of the instance with respect to other instances.
    from_schema: https://www.cdisc.org/ars/1-0
    rank: 1000
    alias: order
    owner: WhereClause
    domain_of:
    - LevelOrder
    - Operation
    - OrderedGroupingFactor
    - OrderedDisplay
    - OrderedDisplaySubSection
    range: integer
    required: true