Skip to main content
Solved

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


ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+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

View original
Did this topic help you find an answer to your question?

3 replies

Arosha Mudalige
Do Gooder (Employee)
Forum|alt.badge.img+6
  • Do Gooder (Employee)
  • 20 replies
  • Answer
  • March 13, 2025

Hi ​@ZTC ZTC JGOTA ,

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

Many Thanks,

Arosha


ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • 219 replies
  • March 13, 2025

Hello ​@Arosha Mudalige 

 

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

 

Thanks,

 


Arosha Mudalige
Do Gooder (Employee)
Forum|alt.badge.img+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!

 


Did this topic help you find an answer to your question?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings