Skip to main content

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?

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

 

solved, thank you

Reply


Terms & ConditionsCookie settings