PSPRSMNAVMODE

index back

Cref Navigation Modes

View to return Target Cref's Properties such as Classic, FLUID, SFF. Mainly used by PORTALREGISTRY_CQ Connected Query for Menu Search Returns '1' for Classic , '2' for Fluid, and 3 for SFF (Small Form Factor)
SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , CASE WHEN (A.FLUIDMODE = 1) THEN '2' ELSE '1' END FROM %Table(PSPRSMDEFN) A WHERE (A.PORTAL_CREF_USGT = 'TARG') UNION SELECT B.PORTAL_NAME , B.PORTAL_OBJNAME , '3' FROM %Table(PSPRSMDEFN) B WHERE (B.PORTAL_CREF_USGT = 'TARG') AND B.SMALLFFOPT=1

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PTSF_NAV_MODE Character(1) VARCHAR2(1) NOT NULL Navigation Modes
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19