Question

Track Changes(Delta)

  • 12 March 2024
  • 3 replies
  • 43 views

Badge +4

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

Userlevel 5
Badge +13

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

Badge +4

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

Userlevel 5
Badge +13

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'

Reply