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

 

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

2 replies

Forum|alt.badge.img+14
  • Hero (Partner)
  • 200 replies
  • Answer
  • April 26, 2022

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

 


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Customer)
  • 15 replies
  • April 26, 2022

solved, thank you


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