Search Document which have NULL OR Empty metadata using predicate
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
 |
Ahmad Ben Maallem
Member (1.9K) 2 4 7 |
01/14/2021 ( History) |
Hello, A solution might be https://doc.nuxeo.com/nxdoc/how-to-search-or-operator/#create-a-page-provider Regards
 |
Gregory Carlin
Nuxeo Specialist (18.6K) 4 7 5 |
01/14/2021 ( History) |
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