How to search a string which length is 0 in Elasticsearch?

Question

My documents have a keyword which value is "", how can I search it by java Elasticsearch?

No effect like the code is :

query.must(QueryBuilders.boolQuery()
            .should(QueryBuilders.regexpQuery("paymentRetCode", ""))
            );

Val · Accepted Answer · 2017-04-21 14:11:51Z

1

You need to use a script query in order to check that the length of the string is 0:

Script script = new Script(ScriptType.INLINE, "myscript", "doc.paymentRetCode.value.length() == 0", new HashMap())
query.must(QueryBuilders.boolQuery()
    .should(QueryBuilders.scriptQuery(script))))
);

Script queries are not ideal, though, you should set null instead of the empty string if you need to detect documents with empty strings, in which case you'll be able to use a negated exists query:

QueryBuilders.boolQuery()
    .mustNot(QueryBuilders.existsQuery("paymentRetCode"))

answered Apr 21, 2017 at 14:11

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to search a string which length is 0 in Elasticsearch?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related