![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1Q3FEhCtV0O1JVCWdGD8djcKFxkTveqZkAdF_MB-zWjSC-vr6IwfocScLsGg70fvod4zwV4AXhSi_MQY-kHlWT6AOV3ylfnGD7NQzScH4Xj2r_ON4N35yBQQC2Zk9yLs6Ki0Ddc8_bMU/s400/shot2.jpg)
There is a catch –It doesn’t work for the transaction components like JOB_DATA.
This record is used in setup manager and hence doesn’t have details for the transactional components.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKgKvDQJ8xqPDrS12BjWhk08VY9hUPshzdqjEKtV5LX1mtT9UzrQbl2RUDbEvQ1acpRyalzJ-d0yreXXJUgiVSRpaHQshf9q6DDMUFTv_NQdWyzfkhlwf-EtsjGdxtBV_UAhvAgqzctqs/s400/shot1.jpg)
Below query gives for all tables (including hidden).. based the level of navigation (for example Main Menu --> Careers, for this two tables should be joined.. so if you are not getting the results, you have to keep reducing the no of joins :)) it is configured the self join table's count should be increased/decreased...
Oracle------
SELECT D.PORTAL_LABEL ' -->' C.PORTAL_LABEL' -->' B.PORTAL_LABEL ' -->' A.PORTAL_LABEL
FROM PSPRSMDEFN A, PSPRSMDEFN B, PSPRSMDEFN C,PSPRSMDEFN DWHERE A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAMEAND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAMEAND C.PORTAL_PRNTOBJNAME = D.PORTAL_OBJNAMEAND A.PORTAL_URI_SEG2 ='JOB_DATA_HIRE'
MSSQL-----
SELECT D.PORTAL_LABEL+ ' -->'+C.PORTAL_LABEL+' -->'+ B.PORTAL_LABEL +' -->' + A.PORTAL_LABEL
FROM PSPRSMDEFN A, PSPRSMDEFN B, PSPRSMDEFN C,PSPRSMDEFN DWHERE A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAMEAND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAMEAND C.PORTAL_PRNTOBJNAME = D.PORTAL_OBJNAMEAND A.PORTAL_URI_SEG2 ='JOB_DATA_HIRE'
Manivannan Ramar
Lovely sharp post. Never thought that it was this easy. Extolment to you!
ReplyDeleteAwesome posting. Benar-benar menikmati membaca posting blog anda.
ReplyDelete