Search Document which have NULL OR Empty metadata using predicate

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.

Ahmad_BenMaallem

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

Gregory_Carlin

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