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?

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?
Hi
Hope you can use the table: XML_REPORT_DATA_TAB to view the xml data.
Many Thanks,
Arosha
Hello
Thanks so much, quick question do you have an example of how you query inside the field DATA?
Thanks,
Hi
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.