It’s confirmed that “RecordChanges” checkbox on a controls property doesn’t always work (SLXDev forum). Today I testified it too:
select * from sysdba.history where datediff( hour, startdate, GetUTCDate()) < 48
It only gives me a handful records while there are so many updates. The returned history are all in default SLOX objects. So I guess the custom objects/tables (e.g. Policy etc) have problems. I was thinking to put change logging in database triggers, but a few concerns:
- it may not always have valid ModifyUser value
- to add a new field to be logged is tedious and error-prone
- when we remove a database field, we have to remember to remove it from the trigger
- any unhandeled error will prevent saving.
That said, this isn’t a very practical approach.