How should query does it work ? ElasticSearch Java API

Question

I just want to get all result from a simple Pseudo-SQL query like that:

[...] WHERE 'idGroups' = '7078' AND ('titre' LIKE '%fuite%' OR 'tag' LIKE '%fuite%' OR 'message' LIKE '%fuite%')

In done that:

        BoolQueryBuilder qb = QueryBuilders
                .boolQuery()
                .must(QueryBuilders.termQuery("idGroups", 7078))
                .should(QueryBuilders.termQuery("titre", "fuite"))
                .should(QueryBuilders.termQuery("tag", "fuite"))
                .should(QueryBuilders.termQuery("message", "fuite"));

Obviously, that is not returning me desired result .. What's wrong?

Thank you :)

Richa · Accepted Answer · 2017-05-11 10:02:45Z

1

Can you try this:

QueryBuilders
            .boolQuery()
            .must(QueryBuilders.termQuery("idGroups", 7078))
            .should(QueryBuilders.wildcardQuery("titre", "*fuite*"))
            .should(QueryBuilders.wildcardQuery("tag", "*fuite*"))
            .should(QueryBuilders.wildcardQuery("message", "*fuite*")).minimumShouldMatch(1);

edited May 11, 2017 at 10:02

answered May 11, 2017 at 9:53

Richa

7,6796 gold badges30 silver badges36 bronze badges

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

10 Comments

Joris Bertomeu Over a year ago

I tried it, but this isn't working better. For example, if I do that:

QueryBuilders             .boolQuery()             .must(QueryBuilders.termQuery("idGroups", 7078))             .should(QueryBuilders.wildcardQuery("titre", "*fuite*"))

I have some result with "TEST EVENEMENT - MANDAT" or "Test SDB" as "titre" ..

Joris Bertomeu Over a year ago

This is the same result .. Not really more efficient

Richa Over a year ago

Do you use some plugin like sense or something where you write Elasticsearch Query DSL. Then Try this Query:

{"query":{"bool":{"must":[{"term":{"idGroups":{"value":7078}}},{"query_string":{"fields":["titre","tag","message"],"query":"*fuite*"}}]}}}

Richa Over a year ago

And Please share mapping of your index. GET /index/type/_mapping

Joris Bertomeu Over a year ago

So, my war deployement failed and your update hasn't been used. Now, with your update with "minimumShouldMatch", it works better! But, If I execute the request with "fuite", I have a result like "fuite eau" as "titre". When I execute the request with "fuite eau", I have 0 results ..

|

Collectives™ on Stack Overflow

How should query does it work ? ElasticSearch Java API

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related