You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

SQR path

1 reply [Last post]
Guest's picture
Guest

I would like to know the navigation path for a SQR. i mean menu of it when i have sqr name. please help me with this

Rabishankar's picture
Rabishankar (not verified)
Re: SQR path

Find the component name attached with the SQR in process security. Main Menu > People Tools > Process Scheduler > Process. Enter your SQR name, navigate to the second tab (Process Definition Options), then copy the Component name from process Security and paste that component in the following query to get the navigation path for that SQR.

SELECT LEVEL0.PORTAL_LABEL || ' > ' || LEVEL1.PORTAL_LABEL || ' > ' || LEVEL2.PORTAL_LABEL || ' > ' || level3.PORTAL_LABEL PATH_TO_COMPONENT
FROM PSPRSMDEFN level3
, PSPRSMDEFN level2
, PSPRSMDEFN level1
, PSPRSMDEFN LEVEL0
WHERE level3.PORTAL_URI_SEG2 = 'COMPONENT NAME'
AND level3.PORTAL_PRNTOBJNAME = level2.PORTAL_OBJNAME
AND level2.PORTAL_PRNTOBJNAME = level1.PORTAL_OBJNAME
AND level1.PORTAL_PRNTOBJNAME = LEVEL0.PORTAL_OBJNAME
AND level3.PORTAL_NAME = level2.PORTAL_NAME
AND level2.PORTAL_NAME = level1.PORTAL_NAME
AND level1.PORTAL_NAME = LEVEL0.PORTAL_NAME

Hope it will help you.

Thanks,
Rabishankar