topic Re: How to check for recently deleted documents? in Nuxeo Forum

How to check for recently deleted documents?

Kimberley_Masse — Wed, 07 Dec 2016 12:01:28 GMT

I have a set up which syncs content from Nuxeo to Drupal. To add content from Nuxeo to Drupal is simple, I query for recently modified Nuxeo documents. However deleting content in Drupal if it is deleted in Nuxeo is a little trickier.

Currently I'm comparing against the document ids in my map table to Drupal. I query Nuxeo for documents in an list of IDs (those from the map table) and if one exists in Drupal but not the Nuxeo results it is deleted. But with over 15000 documents in Nuxeo and the query only being able to handle approx 80 ids at a time (because it is effectively a GET request with the ids in the query string), it takes a long time.

Is it possible to query deleted documents while they are in the trash?

Re: How to check for recently deleted documents?

Pierre-Gildas_M — Wed, 07 Dec 2016 13:32:58 GMT

Hi,

I think you would have better results using an Event handler on Document removed triggering an Automation script with a Blob.PostToURL operation POSTing to a URL on Drupal actually removing the document.

Some references:

Re: How to check for recently deleted documents?

Kimberley_Mass1 — Wed, 14 Dec 2016 18:37:02 GMT

Thanks. I'm trying to avoid writing any modules for Nuxeo though, as I have little experience in java. Is there not a query I could run?

Re: How to check for recently deleted documents?

pibou_Bouvret — Thu, 15 Dec 2016 06:19:35 GMT

The event handler and associated automation chain can be written in an XML contribution without any Java code.

Re: How to check for recently deleted documents?

Kimberley_Masse — Sat, 24 Dec 2016 15:01:09 GMT

Thanks - I was able to achieve what I wanted using the query `SELECT * FROM Document WHERE ecm