Resolved- cases with missing PYRESOLVEDTIMESTAMP are not purged by Purge/Archive
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.