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 Tracy Norwillo
It’s unclear what you mean when you say that you can only see the meta data. Can you share how you have the History Log set up for capturing this information? You should be able to pull the old and new values like this:
SELECT h.lu_name
, h.history_type
, h.username
, a.column_name
, a.old_value
, a.new_value
, a.objversion
FROM history_log h
, history_log_attribute a
WHERE h.log_id = a.log_id
It’s unclear what you mean when you say that you can only see the meta data. Can you share how you have the History Log set up for capturing this information? You should be able to pull the old and new values like this:
SELECT h.lu_name
, h.history_type
, h.username
, a.column_name
, a.old_value
, a.new_value
, a.objversion
FROM history_log h
, history_log_attribute a
WHERE h.log_id = a.log_id
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.