Class: WhereClauseCompoundExpression

An abstract class representing a compound expression consisting of either two or more sub-clauses combined with the AND or OR logical operator, or a single sub-clause negated with the NOT logical operator. Each sub-clause is either a fully-defined WhereClause (containing either a condition or a compoundExpression) or a ReferencedWhereClause (containing a subClauseId).

  • NOTE: this is an abstract class and should not be instantiated directly

URI: ars:WhereClauseCompoundExpression

 classDiagram
    class WhereClauseCompoundExpression
      WhereClauseCompoundExpression <|-- CompoundSetExpression
      WhereClauseCompoundExpression <|-- CompoundSubsetExpression
      WhereClauseCompoundExpression <|-- CompoundGroupExpression
      WhereClauseCompoundExpression : logicalOperator        
        WhereClauseCompoundExpression --|> ExpressionLogicalOperatorEnum : logicalOperator
        WhereClauseCompoundExpression : whereClauses        
        WhereClauseCompoundExpression --|> SubClause : whereClauses
        

Inheritance

Slots

Name Cardinality* and Range Description Inheritance
logicalOperator 1..1
ExpressionLogicalOperatorEnum
The boolean operator that is used to combine (AND, OR) or negate (NOT) the wh... direct
whereClauses 0..*
SubClause
A list of one or more where clauses (selection criteria) to be combined or ne... direct

* See LinkML documentation for cardinality definitions.

Usages

used by used in type used
WhereClause compoundExpression range WhereClauseCompoundExpression
SubClause compoundExpression range WhereClauseCompoundExpression

Identifier and Mapping Information

Schema Source

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

Mappings

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

Examples

Example: WhereClauseCompoundExpression-01 AND

# Compound expression: (    ADAE.TRTEMFL EQ 'Y'
#                       AND ADAE.AESDTH EQ 'Y')
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

Example: WhereClauseCompoundExpression-02 NOT with OR

# Compound expression: NOT (ADXX.VAR1 IN ('value 1','value 2') OR ADXX.VAR2 GT 37)
logicalOperator: NOT
whereClauses:
- level: 2
  order: 1
  compoundExpression:
    logicalOperator: OR
    whereClauses:
    - level: 3
      order: 1
      condition:
        dataset: ADXX
        variable: VAR1
        comparator: IN
        value:
        - value 1
        - value 2
    - level: 3
      order: 2
      condition:
        dataset: ADXX
        variable: VAR2
        comparator: GT
        value:
        - 37

LinkML Source

Direct

name: WhereClauseCompoundExpression
description: An abstract class representing a compound expression consisting of either
  two or more sub-clauses combined with the `AND` or `OR` logical operator, or a single
  sub-clause negated with the `NOT` logical operator. Each sub-clause is either a
  fully-defined `WhereClause` (containing either a `condition` or a `compoundExpression`)
  or a `ReferencedWhereClause` (containing a `subClauseId`).
from_schema: https://www.cdisc.org/ars/1-0
rank: 1000
abstract: true
slots:
- logicalOperator
- whereClauses
slot_usage:
  whereClauses:
    name: whereClauses
    domain_of:
    - WhereClauseCompoundExpression
    any_of:
    - range: WhereClause
    - range: ReferencedWhereClause

Induced

name: WhereClauseCompoundExpression
description: An abstract class representing a compound expression consisting of either
  two or more sub-clauses combined with the `AND` or `OR` logical operator, or a single
  sub-clause negated with the `NOT` logical operator. Each sub-clause is either a
  fully-defined `WhereClause` (containing either a `condition` or a `compoundExpression`)
  or a `ReferencedWhereClause` (containing a `subClauseId`).
from_schema: https://www.cdisc.org/ars/1-0
rank: 1000
abstract: true
slot_usage:
  whereClauses:
    name: whereClauses
    domain_of:
    - WhereClauseCompoundExpression
    any_of:
    - range: WhereClause
    - range: ReferencedWhereClause
attributes:
  logicalOperator:
    name: logicalOperator
    description: The boolean operator that is used to combine (AND, OR) or negate
      (NOT) the where claus(s) in the compound expression.
    from_schema: https://www.cdisc.org/ars/1-0
    rank: 1000
    alias: logicalOperator
    owner: WhereClauseCompoundExpression
    domain_of:
    - WhereClauseCompoundExpression
    range: ExpressionLogicalOperatorEnum
    required: true
  whereClauses:
    name: whereClauses
    description: A list of one or more where clauses (selection criteria) to be combined
      or negated.
    from_schema: https://www.cdisc.org/ars/1-0
    rank: 1000
    multivalued: true
    list_elements_ordered: true
    alias: whereClauses
    owner: WhereClauseCompoundExpression
    domain_of:
    - WhereClauseCompoundExpression
    range: SubClause
    inlined: true
    inlined_as_list: true
    any_of:
    - range: WhereClause
    - range: ReferencedWhereClause