Clear all

I need to extract PLT.Page_IB


Topic starter

I need to extract PLT.Page_IB on a UAT instance with no JMX console. Does anybody know how to do this?

1 Answer

We can run the following query to dump the Page to process using PLT.Page_IB interface (Available under PageExportSqls.xml in case we need to dump other entities for UDP)

select pf.model_level || ',' || || ',' || || ',"' || nvl(replace(json_query(layout, '$' returning CLOB pretty), '"', '""'),layout) || '"' csv_row
from page p
join page_flow pf on pf.sys_page_flow_id = p.sys_page_flow_id
order by pf.model_level,,
© 2020 One Network Enterprises. All rights reserved. Privacy Policy