Operator property: QueryCriteria class
Description
This property returns or sets the operator for the criteria.
The value of this property determines the valid types of the Expression 2, set with the Expr2Type property.
This property is read/write.
See Expr2Type property: QueryCriteria class, Working With Query Criteria and Expressions.
You can use either a constant or numeric value for this property. The values are:
| Numeric Value | Constant Value | Description |
|---|---|---|
|
1 |
%Query_CondNone |
None (used for initializing a new criteria.) |
|
2 |
%Query_CondEqual |
Criteria's left-hand side is equal to right-hand side (= operator) |
|
3 |
%Query_CondNotEqual |
Criteria's left-hand side is not equal to right-hand side (<> operator) |
|
4 |
%Query_CondGreaterThan |
Criteria's left-hand side is greater than right-hand side (> operator) |
|
5 |
%Query_CondNotGreaterThan |
Criteria's left-hand side is not greater than right-hand side (<= operator) |
|
6 |
%Query_CondLessThan |
Criteria's left-hand side is less than right-hand side (< operator) |
|
7 |
%Query_CondNotLessThan |
Criteria's left-hand side is not less than right-hand side (>= operator) |
|
8 |
%Query_CondInList |
Criteria's left-hand side is in the given list (IN operator) |
|
9 |
%Query_CondNotInList |
Criteria's left-hand side is not in the given list (Not IN operator) |
|
10 |
%Query_CondBetween |
Criteria's left-hand side is between the two values of right-hand side (BETWEEN operator) |
|
11 |
%Query_CondNotBetween |
Criteria's left-hand side is not between the two values of right-hand side (BETWEEN operator) |
|
12 |
%Query_CondExists |
Criteria's left-hand side is the output of the subquery of right-hand side (EXISTS operator) |
|
13 |
%Query_CondNotExists |
Criteria's left-hand side doesn't exist in the output of the subquery of right-hand side (NOT EXISTS operator) |
|
14 |
%Query_CondLike |
Criteria's left-hand side is like (wildcard search) the right-hand side (LIKE operation) |
|
15 |
%Query_CondNotLike |
Criteria's left-hand side is not like (wildcard search) the right-hand side (NOT LIKE operation) |
|
16 |
%Query_CondNull |
Criteria's left-hand side is NULL (NULL operation) |
|
17 |
%Query_CondNotNull |
Criteria's left-hand side is not NULL (IS NOT NULL operation) |
|
18 |
%Query_CondInTree |
Criteria's left-hand side is from a list of nodes in Tree (IN operation) |
|
19 |
%Query_CondNotInTree |
Criteria's left-hand side is not from a list of nodes in Tree (NOT IN operation) |
|
20 |
%Query_CondEffDtLessEqual |
Criteria's left-hand side is an Effective Date and is less than or equal to the date on the right-hand side (<= operation) |
|
21 |
%Query_CondEffDtGreaterEqual |
Criteria's left-hand side is an Effective Date and is greater than or equal to the date on the right-hand side (>= operation) |
|
22 |
%Query_CondEffDtLess |
Criteria's left-hand side is an Effective Date and is less than the date on the right-hand side (< operation) |
|
23 |
%Query_CondEffDtGreater |
Criteria's left-hand side is an Effective Date and is greater than the date on the right-hand side (> operation) |
|
24 |
%Query_CondFirstEffDt |
Criteria's left-hand side is the first effective date (Function MIN()) |
|
25 |
%Query_CondLastEffDt |
Criteria's left-hand side is the last effective date (Function MAX()) |
|
26 |
%Query_CondInTreeJoin |
Criteria's left-hand side is an In Tree Join. |