Introduce a way to also permanently delete the sensitive info from the staff logs

ux
1

It seems that the design of this feature was to remove the post data from the database completely. However, we find that the data is still in the database via the /admin/logs/staff_action_logs

image
image706×210 21.1 KB

We were trying to remove the post from the database completely to comply with local regulations. Is there a way to remove the post data from the staff_action_logs?

8 Likes
2

I don’t believe there is a way currently to do this from the UI. I think you would be able to delete the staff action itself through the rails console if you have access.

You can find the id for the staff action either by checking the staff logs json (/admin/logs/staff_action_logs.json) or using a data explorer query to give you a list to pick it from:

SELECT *
FROM user_histories
WHERE action = 17 --action code for 'delete post'
ORDER BY created_at DESC

And then using that id in the rails console:

UserHistory.where(id:[ID]).delete_all

Though, reading your ask more closely, I think you could overwrite the ‘details’ section instead of deleting the log with something like this:

UserHistory.where(id:[ID]).update(details:"permanently deleted")
7 Likes