I’m trying to write my own additional database record pruning and archiving scripts and going through the schema I’m looking at records in the aop_case_events table and it appears to be a log of events completes, only three types, case status, asignee or priority change. No other types of records. Can this table just be periodically cleared? Strangely searching for discussion on this table are virtually non existent.
So this table can be cleared regularly - nothing wrong with that.
I believe this table is used for Workflow processes and for case automations.
There’s a system process where it’ll fire emails or change things within a case when fields are updated.
It also uses this table for user notifications when cases are assigned & re-assigned.
I emptied this table in one of my test environments and didn’t notice anything go awry - but then again i don’t use case automations & have different things for workflow processes.
Don’t untick the “Use Case Automations” if you do that then the “Case Updates” won’t function 