Search Document which have NULL OR Empty metadata using predicate

Ahmad_BenMaallem — Thu, 14 Jan 2021 11:20:36 GMT

Hello,

Can we process the following request with a generic page provider

SELECT * FROM Document WHERE dc:language = '' OR dc:language IS NULL

For information I managed to look for the nulls but I don't know how to add a predicate on the empty space and especially how to add the "OR" between them.

My code :

<genericPageProvider class="org.nuxeo.elasticsearch.provider.ElasticSearchNxqlPageProvider" name="custom_search">
      <whereClause docType="CustomSearch">
        <predicate operator="IS NULL" parameter="dc:language">
          <field name="searchNullLanguage" schema="custom_search"/>
        </predicate>
        <fixedPart>
	  ecm:isVersion = 0 AND ecm:isTrashed = 0 AND ecm:isProxy=0
        </fixedPart>
      </whereClause>
	<aggregates>
		....
	</aggregates>
      <pageSize>20</pageSize>
    </genericPageProvider>

Thank you

Re: Search Document which have NULL OR Empty metadata using predicate

Gregory_Carlin — Thu, 14 Jan 2021 11:25:02 GMT

Hello, A solution might be https://doc.nuxeo.com/nxdoc/how-to-search-or-operator/#create-a-page-provider Regards

Re: Search Document which have NULL OR Empty metadata using predicate

Ahmad_BenMaallem — Thu, 14 Jan 2021 12:11:17 GMT

Thanks Gregory Carlin for the reply

topic Search Document which have NULL OR Empty metadata using predicate in Nuxeo Forum

Search Document which have NULL OR Empty metadata using predicate

Re: Search Document which have NULL OR Empty metadata using predicate

Re: Search Document which have NULL OR Empty metadata using predicate