Posted by Nitin Pai
October 31st, 2008

What is the best way of identifying UNUSED panels /Pages in the Application / Database.
Currently , Present scenario at my end I am filtering the pages which are created But Not used in Components .

Still is there best way of identifying unused pages from PeopleTools Tables .

Thanks for posting your question!

Based on available information, I am assuming that you are looking for orphan pages. You can use the below SQL in that case to identify orphan pages.

SELECT PNLNAME FROM PSPNLDEFN WHERE PNLNAME NOT IN (SELECT PNLNAME FROM PSPNLGROUP)

AND PNLTYPE = 0 — Standard Page

UNION

SELECT PNLNAME FROM PSPNLDEFN WHERE PNLNAME NOT IN (SELECT PNLNAME FROM PSPNLGROUP)

AND PNLTYPE != 0 — SubPages

AND PNLNAME NOT IN (SELECT SUBPNLNAME FROM PSPNLFIELD)

/

Please note that these pages might still be referred in some PeopleCode.

Thanks

Nitin Pai

Comments (0)