...
The WhereClauseCondition class is used to define simple selection criteria conditions in the condition attribute of the WhereClause class (or any of its specializations).
Excerpt Include |
---|
| ARSP:ER Diagram: WhereClauseConditionARSP: |
---|
| ER Diagram: WhereClauseCondition |
---|
|
...
- The dataset attribute contains the name of the dataset in which the condition is being applied.
- The variable attribute contains the name of the variable (within the specified dataset) to which the condition applies.
- The comparator attribute contains a value from the ConditionComparatorEnum enumeration ("EQ" for "is equal to", "LT" for "is less than", etc.) to indicate how values of the specified dataset variable are compared with the specified selection value(s).
- The value attribute specifies the selection value, or values, for comparison with values in the specified dataset variable. If the value of the comparator attribute is:
- "IN" or "NOTIN", there should be at least 2 values specified in the value attribute; otherwise there should be no more than 1 value specified in the value attribute.
- "EQ" or "NE", the value attribute may contain no value to indicate a condition based on a missing value (i.e., "is missing" or "is not missing" respectively).
Example |
---|
Include Page |
---|
| ARSP:condition: Single valueARSP: |
---|
| condition: Single value |
---|
|
|
Example |
---|
Include Page |
---|
| ARSP:condition: Multiple valuesARSP: |
---|
| condition: Multiple values |
---|
|
|
Example |
---|
Include Page |
---|
| ARSP:condition: Missing valueARSP: |
---|
| condition: Missing value |
---|
|
|