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.
Code Block | ||
---|---|---|
| ||
... 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:
Dataset2 | ||||||||
---|---|---|---|---|---|---|---|---|
|
Other conditions based on multiple selecton values (i.e., with a comparator value of "NOTIN") would be represented in a similar way.