topic Write a NXQL query to purge deleted documents in Nuxeo Forum

Write a NXQL query to purge deleted documents

Pierre_Jenicot1 — Thu, 30 Aug 2012 15:11:17 GMT

Hi,

I want to create a purge of deleted documents for more than 2 months after the last modification date.

Can we write a NXQL query like this :

SELECT * FROM Document WHERE ecm: currentLifeCycleState = 'deleted' AND (dc: modified + INTERVAL '2 month') < TIMESTAMP '2012-08-30 14:00:00'

Or another method?

thank you

Re: Write a NXQL query to purge deleted documents

Benjamin_Jalon1 — Thu, 30 Aug 2012 17:25:24 GMT

Hi,

The better is to use an automation chain and fetch by query documents to remove definitely.

So here is the request I would put into the Fetch > Query operation (becarefule no space between "ecm and :" and "dc and :):

SELECT * FROM Document WHERE ecm:currentLifeCycleState = 'deleted' AND dc:modified < TIMESTAMP '@{CurrentDate.months(2).format("yyyy-MM-dd HH:mm:ss")'

Re: Write a NXQL query to purge deleted documents

Florent_Guillau — Mon, 03 Sep 2012 15:59:04 GMT

NXQL does not have date interval arithmetic. It could be added though.