Skip to main content
Solved

Quick Report_Display the updated records as well as the old records


Forum|alt.badge.img+7

I have created a quick report in IFS. I need to display the updated records as well as the old records of Vendor bank details on the same report.

Currently, the History Log only show the meta data but not the actual changed value. And If I run payment table, it only shows changed value.

Is there any way I can display the actual changes and the old value?

Is there any table/db that holds the original data?

Best answer by Pawel Dworzynski

Hi,

If you have defined History log to store updates of records in particular table, you can find old values and new values in history log tables.

You can find this in HISTORY_LOG_TAB and HISTORY_LOG_ATTRIBUTE_TAB

as on the example.

 

 

Best Regards,
Pawel Dworzynski

 

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

Hi,

If you have defined History log to store updates of records in particular table, you can find old values and new values in history log tables.

You can find this in HISTORY_LOG_TAB and HISTORY_LOG_ATTRIBUTE_TAB

as on the example.

 

 

Best Regards,
Pawel Dworzynski

 


Forum|alt.badge.img+7
  • Do Gooder (Customer)
  • April 27, 2022

solved


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