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?
Solved
How could I access the XML data generated by a Archive Report?
+14Best answer by Arosha Mudalige
Hi
Hope you can use the table: XML_REPORT_DATA_TAB to view the xml data.
Many Thanks,
Arosha
+6Hi
Hope you can use the table: XML_REPORT_DATA_TAB to view the xml data.
Many Thanks,
Arosha
1 person likes this
+14Hello
Thanks so much, quick question do you have an example of how you query inside the field DATA?
Thanks,
+6Hi
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!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.