This example shows an instance of the WhereClause class (or one of its specializations) that defines a simple condition based on multiple specified selection values. The example shown specifies that the value of the AEREL variable in the ADAE dataset matches one of the listed values ("POSSIBLE" or "PROBABLE"), which could be expressed as:
ADAE.AEREL IN ('POSSIBLE','PROBABLE')
Note that some attributes (such as the expected level and order attributes) have been excluded from this example.
YAML Example
... condition: dataset: ADAE variable: AEREL comparator: IN value: - POSSIBLE - PROBABLE
This condition could be represented in tabular form as shown in the following table where the multiple selection values are represented as a pipe (|) delimited list:
$titleHtml
$warningHtml
Other conditions based on multiple selecton values (i.e., with a comparator value of "NOTIN") would be represented in a similar way.
| dataset | variable | comparator | value |
|---|---|---|---|
| ADAE | AEREL | IN | POSSIBLE|PROBABLE |