Solved

Quick Report_Display the updated records as well as the old records

Userlevel 3

+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?

icon

Best answer by Pawel Dworzynski 21 April 2022, 15:58

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

Userlevel 3

+7

solved

Sign up