I want to write reports and/or GIs to show audit trail history.
Specifically, I want to show value changes, the field name, what the value was before and the new value and the user who performed the change.
I would also like to be able to report lines that were deleted.
Specifically, this is for projects, but the question is applicable in general.
What table and fields would I use?
I see an AuditHistory DAC, but it does not have USER, BEFORE VALUE, AFTER VALUE.
And the ModifiedFields entry seems like an unusable jumble of stuff.
Best answer by BenjaminCrisman
Hi @ltussing03 Along with what Manikanta has mentioned these fields record the changes, not necessarily what the values were beforehand, but this would be captured in the initial creation of a record as long as auditing was turned on.
Once the audit is turned on you can filter the results of AuditHistory for the record(s) needing to view and then see what the value was beforehand which would be captured prior in the audit as well as the newer records in the table which would show what the value had change to.
This is after creating an SO, then adding the Description of TEST, then changing that to TEST UPDATE:
The before and after values are both visible
Also, to download files Right Click > Save Link As...
Hi @ltussing03 Along with what Manikanta has mentioned these fields record the changes, not necessarily what the values were beforehand, but this would be captured in the initial creation of a record as long as auditing was turned on.
Once the audit is turned on you can filter the results of AuditHistory for the record(s) needing to view and then see what the value was beforehand which would be captured prior in the audit as well as the newer records in the table which would show what the value had change to.
This is after creating an SO, then adding the Description of TEST, then changing that to TEST UPDATE:
The before and after values are both visible
Also, to download files Right Click > Save Link As...
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
