Use the following query to get records behind not only the page but sub-pages on a page.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Comments
This Query has helped me a lost...thanks
The given queries only work for one subpanel level deep. If you want it to recurse and provide as many subpanels as possible, you can use the following (Oracle Syntax) SQL:
SELECT recname
FROM pspnlfield
WHERE recname<>' '
START WITH pnlname = :1
CONNECT BY PRIOR subpnlname = pnlname and PRIOR fieldtype=11
group by recname;