topic Re: NXQL filtering out deleted documents in Nuxeo Forum

NXQL filtering out deleted documents

sstodghill_ — Thu, 13 Feb 2014 18:02:31 GMT

Hi,

I have the NXQL query below being executed via Resultset.PageProvider REST call

{ "params": {  "pageSize" : 100,  "query" :  "SELECT ecm:uuid, dc:title, ecm:primaryType, ecm:isLatestVersion, ecm:isCheckedInVersion, ecm:versionVersionableId, ecm:currentLifeCycleState, file:content/mime-type FROM Picture " } }

If the document has been edited then an object is returned for each version. Adding

where ecm:isLatestVersion = 1 or ecm:isLatestVersion is null

returns the latest version and the deleted version and the versions can be linked by matching the deleted version's ecm:uuid property with the non-deleted ecm:versionVersionableId but it seems error prone and is not documented.

Can an NXQL query be structured so documents in a deleted state are not returned without client-side post-processing?

Thanks in advance.

Re: NXQL filtering out deleted documents

Thierry_Martins — Thu, 13 Feb 2014 18:34:23 GMT

hello,

you need to add this clause to filter deleted documents:

ecm:currentLifeCycleState != 'deleted'

Thierry

Re: NXQL filtering out deleted documents

sstodghill_ — Fri, 14 Feb 2014 01:23:57 GMT

Thanks, I tried that but it still returns an entry for the version that was not deleted. The query results without the ecm

Re: NXQL filtering out deleted documents

Florent_Guillau — Tue, 18 Mar 2014 12:51:32 GMT

Try using ecm:isVersion = 0 (or the more verbose ecm:isCheckedInVersion = 0 before Nuxeo 5.8) to only get the "live" document, instead of ecm:isLatestVersion which deals with versions

Re: NXQL filtering out deleted documents

sstodghill_ — Thu, 27 Mar 2014 17:57:54 GMT

This tested successfully versioning documents and not versioning them and it getting the expected results. Thanks, Florent!