I need a query to identify all the portlets utilizing a query and to list the query ID. I have a query for both but cannot figure out how to join?
SELECT DISTINCT
-- page.page_id,
cmn.portlet_id,
cmn.created_by,
cmn.created_date,
nls.name,
port.portlet_code,
source,
usr.last_name
|| ','
|| usr.first_name
FROM
cmn_page_portlets cmn
--LEFT JOIN CMN_USER_PAGES PAGE ON CMN.PAGE_ID = PAGE.PAGE_ID
LEFT JOIN cmn_portlets port ON cmn.portlet_id = port.id
LEFT JOIN cmn_sec_users usr ON cmn.created_by = usr.id
LEFT JOIN cmn_captions_nls nls ON port.id = nls.pk_id
WHERE
cmn.created_by <> 1
AND nls.name NOT LIKE '%Favo%'
--AND
--SOURCE = 'csk.niku.com'
AND nls.table_name = 'CMN_PORTLETS'
AND nls.language_code = 'en'
select *
--query_code, source, nsql_text
from cmn_nsql_queries nsql, CMN_GG_NSQL_QUERIES gg
where
--nsql_text
--like '%MONTHLY_INVESTMENT_SQL%'
--and
gg.CMN_NSQL_QUERIES_ID = nsql.id
------------------------------
[Clarity Tech]
[NIH]
[MD]
------------------------------