Solved

How could I access the XML data generated by a Archive Report?

+14

Hello IFS Community,

Is there a table or view that allows me to access the data from the XML file generated by the Archive Report?

Best answer by Arosha Mudalige

Hi @ZTC ZTC JGOTA ,

Hope you can use the table: XML_REPORT_DATA_TAB to view the xml data.

Many Thanks,

Arosha

+6

Hi @ZTC ZTC JGOTA ,

Hope you can use the table: XML_REPORT_DATA_TAB to view the xml data.

Many Thanks,

Arosha

+14

Hello @Arosha Mudalige

Thanks so much, quick question do you have an example of how you query inside the field DATA?

Thanks,

JL

+6

Hi @ZTC ZTC JGOTA ,

Following query works for me when querying the CLOB field directly.

Example:

SELECT * FROM XML_REPORT_DATA_TAB WHERE DATA like '%CUST_AGE_ANALYSIS_REP%';

Thank you!

Sign up