AnsweredAssumed Answered

Query to find the portlet configured under which Menu Manager

Question asked by SiddiqSyed on Dec 1, 2017
Latest reply on Dec 1, 2017 by lakse01

 

I was trying to build a query to fetch the details of portlet where it is configured by passing portlet code. i.e.,to find Portlet Pages and Menu Manager details.


The below query help to get the portlet page details by using Portlet code.


Query to get Portlet Internal ID

SELECT *   --ID, PORTLET_CODE, IS_ACTIVE, PORTLET_TYPE_CODE 
FROM CLARITY.CMN_PORTLETS

WHERE PORTLET_CODE IN (
'PORTLET_CODE');                                 --ID 5102073

 

Query to get Page Internal ID

SELECT *   --ID, PAGE_ID, PORTLET_ID, PORTLET_TITLE_TABLE 
FROM CLARITY.CMN_PAGE_PORTLETS 
WHERE PORTLET_ID IN (
'5102073');                                                     --page id 5063137

 

Query to get Page details

SELECT *--ID, PAGE_CODE, PAGE_TYPE_CODE, PARENT_PAGE_ID, SPACE_CODE 
FROM CLARITY.CMN_PAGES
WHERE ID IN (
'5063137');

 

Could you please help me to built a Query to find MenuID or MenuItemID???

Outcomes