topic Re: How to query the date that a document has been trashed in Nuxeo Forum

How to query the date that a document has been trashed

Eric_Atencio — Fri, 19 Feb 2021 22:11:52 GMT

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.

Re: How to query the date that a document has been trashed

Gregory_Carlin — Tue, 23 Feb 2021 13:24:31 GMT

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

Re: How to query the date that a document has been trashed

Eric_Atencio — Tue, 23 Feb 2021 17:13:18 GMT

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.

Re: How to query the date that a document has been trashed

Gregory_Carlin — Wed, 24 Feb 2021 08:43:10 GMT

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/)