How to query the date that a document has been trashed

[Eric_Atencio]

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.

[Gregory_Carlin]

Hello,

You have to use the ecm:isTrashed = 1 in your queries. More info here https://doc.nuxeo.com/nxdoc/nxql/#special-nxql-properties

Regards

[Eric_Atencio]

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.

[Gregory_Carlin]

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 (https://doc.nuxeo.com/nxdoc/rest-api-web-adapters/)