This example shows an instance of the WhereClause class (or one of its specializations) that defines a simple condition based on a missing value. The example shown specifies that the value of the BASE variable in the ADVS dataset is not missing, which could be expressed as any of the following:
ADVS.BASE NE ''
ADVS.BASE IS NOT MISSING
ADVS.BASE IS NOT NULL
Note that some attributes (such as the expected level and order attributes) have been excluded from this example.
YAML Example
... condition: dataset: ADVS variable: BASE comparator: NE value:
This condition could be represented in tabular form as:
$titleHtml
$warningHtml
Other conditions based on a missing value (i.e., with a comparator value of "EQ" or "NE") would be represented similarly.
dataset | variable | comparator | value |
---|---|---|---|
ADVS | BASE | NE |