COMPARISON_OPERATOR is a field in which the user may select an operator value to compare data or to filter data.
X_COMPARISON_OPERATOR is a FIXED LEXICON with the following values:
Saved Value | Displayed Value |
---|---|
00 | Not Specified |
01 | Like |
02 | Not Like |
03 | Equals |
04 | Not Equals |
05 | Within Range |
06 | By As Of Date |
07 | Is Null |
08 | Is Not Null |
09 | Is Secured |
10 | Between |
11 | Greater Than or Equal |
12 | Less Than or Equal |
13 | In |
14 | Not In |
15 | Contains |
16 | Equals Or Is Null |
17 | Not Equals Or Is Null |
18 | Greater Than Or Equal Or Null |
19 | Less Than Or Equal Or Null |
20 | Formatted Equals |