Monday, July 23, 2012

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

Friday, July 6, 2012

Error on Javascript in PeopleTools 8.52: "hAction_win0 is not defined"

Below code may not work from PeopleTools 8.52. But this will work on below version of tools release (i.e. 8.50, 8.51).
hAction_win0(document.win0,pageFldName,0,0,inlabel,false,true); 



Reason:


"hAction_win0" is no longer used in PeopleTools 8.52.


Solution:


"hAction_win0" can be replaced with "submitAction_win0" for 8.52 PeopleTools.


Sample code:

submitAction_win0(document.%FormName,pageFldName,0,0,inlabel,false,true);