Modify journal field entries?

[gaidem]

I'm looking for a way to modify and/or delete journal field entries. I started by creating a reference field to the task on the sys_journal_field table. I was then able to add it as a related list. However any modifications to the text did not reflect in the activity log. Also deleting the entry didn't remove it from the activity log.

Does anyone know of a way to achieve what I'm after?

[CapaJC]

I'm pretty sure the activity formatter pulls its info from the sys_audit table for the record being viewed. Kinda strange having the journal comment in two places, really.

Personalize Related Lists on your form, and add the "Audit Record" related list. See if the journal comments are there, and whether editing them there has the desired effect.

[gaidem]

They still display. Modifying the sys_journal_field entry or the sys_audit entry do not change what is in the activity log.

[ctrusty]

gaidem

You said you got this working so what table did you refer to? I couldn't find the History -> List option on the header. I did add the related list "Audit History" which refers to the sys_history_line table. If I modify a record from there it doesn't update in the activity log. If I delete a record from there, it DOES disappear from the activity log.

Thoughts?

[CapaJC]

One last thing to try. Instances on a current version use History Sets to improve performance. Right-click the form header, and select History --> List.

Delete the "Record History" record you are taken to. It's only a copy of actual audit data, and will be automatically rebuilt from audit data the next time the activity formatter is viewed.