Skip to main content

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

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

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

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


Terms & ConditionsCookie settings