CONDTYPE and EXPRTYPE stores below code in PSQRYCRITERIA Table.
| Field: Condition Type (CONDTYPE) | ||
| Code | Description | Return Code |
| 2 | equal to | EQU |
| 3 | not equal to | EQU- |
| 4 | greater than | GRE |
| 5 | not greater than | GRE- |
| 6 | less than | LES |
| 7 | not less than | LES- |
| 8 | in list | LIS |
| 9 | not in list | LIS- |
| 10 | Between | BET |
| 11 | not between | BET- |
| 12 | Exists | EXI |
| 13 | does not exist | EXI- |
| 14 | Like | LIK |
| 15 | not like | LIK- |
| 16 | is null | NUL |
| 17 | is not null | NUL- |
| 18 | in tree | TRE |
| 19 | not in tree | TRE- |
| 20 | eff dt <= | EDLE |
| 21 | eff dt >= | EDGE |
| 22 | eff dt < | EDLT |
| 23 | eff dt > | EDGT |
| 24 | first eff dt | EDFS |
| 25 | last eff dt | EDLS |
| Field: Expression Type (EXPRTYPE) | ||
| Code | Description | Return Code |
| 0 | effective sequence | ES |
| 1 | constant | CN |
| 2 | field | FD |
| 3 | Expression | EX |
| 4 | Subquery | SQ |
| 5 | list | LS |
| 6 | current date | CD |
| 7 | tree | TR |
| 8 | Prompt | PR |
| 9 | between const-const | CC |
| 10 | between const-field | CF |
| 11 | between const-expr | CE |
| 12 | between field-const | FC |
| 13 | between field-field | FF |
| 14 | between field-expr | FE |
| 15 | between expr-const | EC |
| 16 | between expr-field | EF |
| 17 | between expr-expr | EE |
| 18 | Tree prompt | TP |
Detailed Information:
Record Field Name: QRYFUNCTIONS - QRYTRANSFUNCS
