Search Document which have NULL OR Empty metadata using predicate
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>
Hello, A solution might be https://doc.nuxeo.com/nxdoc/how-to-search-or-operator/#create-a-page-provider Regards
But since I'm not too familiar with the Hints, I can not always understand because in the example, we have two fields, a single operator and a single value (equivalent to: select * From Document where dc:creator = "user1" OR dc:contributors = "user1" ) while in my case we have 1 single field with two operators and two values (equivalent to select * from Document where dc:description = '' OR dc:description IS NULL ).
Can you help me more please