Notifications
Clear all

I need to extract PLT.Page_IB

1 Posts
2 Users
2 Likes
5,134 Views
1
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
1

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 || ',' || pf.name || ',' || p.name || ',"' || 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, pf.name, p.name