Search Document which have NULL OR Empty metadata using predicate

[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

[Ahmad_BenMaallem]

Thanks Gregory Carlin for the reply