How to remove an entry from Activity log?

antonymirza
Tera Expert

How to remove an entry from Activity log?

12 REPLIES 12

Slava Savitsky
Giga Sage

In your screenshot, there are four updates, some of which concern more than one field (you can click on [+] icon to see the details) and not all of them are related to Work Notes. Are you only interested in deleting a Work Notes entry or are you trying to delete evidence of an update to some other field like Incident state or Assigned to?


In screenshot, except the bottom entry (David Loo), all other were made by me, entering some rough input through work notes. I am interested in deleting any entry whether it is of Work Notes or any other evidence.


You would need to delete the corresponding records from sys_audit table as follows:
1. Copy the sys_id of your incident
2. Navigate to sys_audit_list.do?sysparm_query=documentkey=YOUR-INC-SYS-ID
3. Locate the relevant record and delete it

But before you do that, you should make another update to your incident record so as to revert field values to their state before the update that you are trying to remove from the record history. Otherwise, record history will not reflect the real state of affairs.

As you cannot "revert" Work Notes to their previous state, you would need to delete the corresponding journal entry from sys_journal_field table:
1. Copy the sys_id of your incident
2. Navigate to sys_journal_field_list.do?sysparm_query=element_id=YOUR-INC-SYS-ID
3. Locate the relevant journal entry and delete it

NB: sys_audit and sys_journal_field tables are huge, so you'd better not try to open the whole table as a list.


Thank you Slava, for sharing such a wonderful knowledge, I'll try and share my feedback!


I went through the steps you suggested but, it's not removing the comments/entries from Activity field. I have tried both the options as listed below:
1. Deleting the respective records from sys_journal_field and sys_audit tables.
2. Removing existing values from respective records in afore mentioned tables and save.

I am quite agree with the your instructions and ideally it should work as well but, don't know why it's not removing the correspondent entries from Activity field.