Write a NXQL query to purge deleted documents

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Pierre_Jenicot1

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

Benjamin_Jalon1

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")'