topic Re: How to search for documents that have a list property empty ? in Nuxeo Forum

How to search for documents that have a list property empty ?

fast_narcis_ — Thu, 24 Apr 2014 16:37:11 GMT

Like documents having no value in the dc:subjects field.

Re: How to search for documents that have a list property empty ?

fast_narcis_ — Thu, 24 Apr 2014 16:54:52 GMT

Also, how about searching for documents with no subjects OR with subject 'X'.

Re: How to search for documents that have a list property empty ?

ThibArg_ — Thu, 24 Apr 2014 23:01:34 GMT

You can use the following query for this:

SELECT * FROM Document WHERE dc:subjects/* IS NULL

Adding the usual filters on deleted documents or versions:

SELECT * FROM Document WHERE dc:subjects/* IS NULL AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'

If the question is about the User Interface and the default forms displayed by Nuxeo (in the FacetedSearch for example), then you must override the search or add you own (Content-View in Studio, with the "Faceted Search" box checked), because by default, Nuxeo handles the empty parameters of these layouts as if they where not filled at all.

Re: How to search for documents that have a list property empty ?

fast_narcis_ — Fri, 25 Apr 2014 10:20:25 GMT

It works ! Thank you very much !

Re: How to search for documents that have a list property empty ?

ThibArg_ — Mon, 19 May 2014 23:52:18 GMT

Good idea. Just did it today thanks