How to put multiple match query inside a bool query in elasticsearch

Question

I am trying to implement below elasticsearch query

{
"query": {
    "bool": {
        "must": [
            {"match": {"collegeName": "XXXX"}},
            {"match": {"userType": "STUDENT"}},
            {"match": {"details.blocklisted":"TRUE"}}
            ]
    }
}

}

How do I implement it in java. I thought of doing this

BoolQueryBuilder boolQueryBuilder = new BoolQueryBuilder();
    searchSourceBuilder.query(boolQueryBuilder.must(new 
MatchQueryBuilder("collegeName",loggedInUserCollegeName)).must(new MatchQueryBuilder("userType",studentsSearchRequestDTO.getUserType())).must(new MatchQueryBuilder("details.blocklisted",studentsSearchRequestDTO.isBlockListed())));

Is there a better way to do???? Help!!

Ravi · Accepted Answer · 2020-02-28 06:25:23Z

2

you can use MultiMatchQueryBuilder something like

SearchQuery searchQuery = new NativeSearchQueryBuilder()
              .withQuery(multiMatchQuery("college")
                .field("collegeName")
                .field("userType")
                .type(MultiMatchQueryBuilder.Type.BEST_FIELDS))
              .build();

answered Feb 28, 2020 at 6:25

Ravi

3481 silver badge12 bronze badges

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

1 Comment

avez raj Over a year ago

i'm trying to use multiMatchQuery but this method is not found

Anurag · Accepted Answer · 2018-04-24 16:28:44Z

Yes,

Use Search Template (ES official doc). It's like a stored procedure. A query with a replaceable variable. Plus changing the query is just a simple update. Create template beforehand (POST /_search/template/templateName {BODY} ) then you can call it (POST /twitter/tweet/_search/templateName {BODY containing dynamic variables}).

similarly in JAVA

Map<String, Object> params = new HashMap<String, Object>();
params.put("search_term", "elasticsearch");
params.put("since", "now-30d");

Template template = new Template("tweets", ScriptService.ScriptType.FILE, 
MustacheScriptEngineService.NAME, null, params);
SearchRequestBuilder request = 
client.prepareSearch(INDEX).setTemplate(template);

SearchResponse response = request.execute().actionGet();

Collectives™ on Stack Overflow

How to put multiple match query inside a bool query in elasticsearch

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related