I am trying to write a query that will produce a list of records deleted in the last 24 hours. I notice that the LAST_UPDATED_DATE field seems to be populated with when the object (let's use a Status Report for example) was last modified, not whe the Status itself was deleted. In Clarity 13.0.
Here is a screenshot:
I need to know when the record was deleted for this query to work correctly. I notice in the Audit trail on the Project that the date the delete took place is captured, so it has to be in there somewhere.