Skip to main content
Question

Track Changes(Delta)

  • March 12, 2024
  • 3 replies
  • 80 views

Forum|alt.badge.img+6

Hello,

I’ve only been using IFS for a short period of time. I wanted to know how how IFS10 stored changes to a record. For example, if my job title was updated where can I see that change and what time it changed? Do I need to write a custom query?

 

Thanks
Ross

3 replies

Forum|alt.badge.img+14

Hi Ross,

You can configure a history log to track changes on required tables. You can find more info in the technical documentation:

https://docs.ifs.com/techdocs/foundation1/040_administration/270_monitoring/010_history/default.htm


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • April 3, 2024

@Roel van Zwieten Thanks, do you know if there is a query you can run to see what tables have this turned on?


Forum|alt.badge.img+14

I'd say the easiest way to check this is to just check this in the Setup History Log screen.

If you want to check this through a query you can try this:
select * from History_Setting_Module_Lu
where HISTORY_SETTING_SELECTION = 'TRUE'