How to query the date that a document has been trashed

We would like to retain our trash for a set time period and have it hard deleted afterwards. We can do this with API calls but I would like to be able to query the date when a document was trashed, is there anyway to do that? Please see the screen shot from the history tab that I have attached.

0 votes

2 answers



So the info about the date when the document is trashed is available in the audit, not in the document properties itself. You can access it throught the @audit web adapter (

0 votes


You have to use the ecm:isTrashed = 1 in your queries. More info here


0 votes

Thank you but what I mean is how do I query the date that a document was trashed not if the document is trashed. I'll clean up my initial question and try to make it clearer.