Clarity

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Portlet Pages - I tried the query but missing few things

  • 1.  Portlet Pages - I tried the query but missing few things

    Posted Nov 07, 2021 02:21 AM
    Under the Admin --> Portlet Pages --> List view shows some records. I'm trying for a query on that, but not getting exact match.

    Query :-
    --------

    SELECT

    (SELECT NLS.NAME FROM CMN_CAPTIONS_NLS NLS WHERE NLS.LANGUAGE_CODE='en' AND TABLE_NAME='CMN_PAGES' AND NLS.PK_ID = PG.ID) PAGENAME
    ,PG.PAGE_CODE ID
    ,PG.CREATED_DATE CREATED_DATE
    ,(SELECT FULL_NAME FROM CMN_SEC_USERS CMN WHERE CMN.ID=PG.CREATED_BY) CREATED_BY

    FROM

    CMN_PAGES PG
    JOIN CMN_PAGE_PORTLETS PO ON PO.ID=PG.ID
    WHERE 1=1 
    AND PO.portlet_title_table='CMN_PAGE_PORTLETS'