Skip to main content

Hi All,

 

Given the metadata wihtin the database I would think it would be possible to query the Lobby names, their underlying page elements and finally the datasources involved.

 

i am using ifsapp.composite_page_element as the source for my query

 

This gives me the lobby elements and their corresponding datasources.

What I am actually looking for are the parents, the lobby name. Probably this is a page so I thoug querying ifsapp.composite_page which does exist would give page names with id's but querying this table gives no record. 

Do you have a hint to get the accompanying lobby name for the elements?

 

 

COMPOSITE_PAGE has row-level security. You may not have permission to view every record or any at all.

 

This query will help you extract some of the information buried in the XML-encoded columns.

SELECT cp.id,
-- XMLTYPE(value),
EXTRACTVALUE(XMLTYPE(cp.value), 'Page/PageTitle') AS page_title,
(SELECT LISTAGG(
EXTRACTVALUE(column_value , '/Element/@id'), ';'
) WITHIN GROUP (ORDER BY 1)
FROM TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(cp.value), 'Page/Layout/Groups/Group/Elements/Element')))) AS elements,
(SELECT LISTAGG(
EXTRACTVALUE(column_value , '/DataSource/@id'), ';'
) WITHIN GROUP (ORDER BY 1)
FROM TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(cp.value), 'Page/DataSources/DataSource')))) AS data_sources
FROM composite_page cp
WHERE cp.value IS NOT NULL;

 


Hi Kevin, the query works but gives no results. I am using IFS10. 

Probably like you say it will be a permission thing.