Solved

Quick Report_Display the updated records as well as the old records

+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

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

+7

solved

Sign up