We have noticed that Resolved- cases in our application that do not have their PYRESOLVEDTIMESTAMP set, are not purged by Purge/Archive.
While we are investigating this issue to fix the code and properly Resolve cases so that PYRESOLVEDTIMESTAMP is set with a value, we also need a solution to "safely" purge existing Resolved- cases with missing PYRESOLVEDTIMESTAMP.
1- Is it safe to run a SQL update to set PYRESOLVEDTIMESTAMP for any row in PC_xyz_WORK table that is Resolved- and its PYRESOLVEDTIMESTAMP is null?
2- Some of the cases have a child case. Will using the above solution for both parent and child case be safe to do?
Please also note that we do not Archive the cases. We only Purge them.
***Edited by Moderator: Pooja Gadige to add platform capability tag***