Analysing “PSQRYCRITERIA” Table

 

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