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 |
