2022-05-13 13:17:03
Topic starter
I need to extract PLT.Page_IB on a UAT instance with no JMX console. Does anybody know how to do this?
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