Skip to main content

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 ​@ZTC ZTC JGOTA ,

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

Many Thanks,

Arosha


Hello ​@Arosha Mudalige 

 

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

 

Thanks,

 


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!

 


Reply