combine two bool queries in elasticsearch

Question

I want to create the equivalent of the following query:

(country.id = 2000 AND natureservices.id = 2000 AND metiers.id = 1000) AND (shortname = "shortname" OR fullname = "fullname" OR categories.id = 1000 OR specialities.id = 2000)

in my case he must show me a single result but when i tried the below query it show many results

{ "query": {
   "bool": {
        "must": [
            { "term": { "country.id": 2000 } },
            { "term": { "natureservices.id": 2000 } },
            { "term": { "metiers.id": 1000 } },
            {
                "bool": {
                    "should": [
                        { "term": { "shortname": "vgftQzSPwW" } },
                        { "term": { "fullname": "qcouWRzFNG" } },
                        { "term": { "categories.id": 1000 } },
                        { "term": { "specialities.id": 2000 } }
                    ], "minimum_should_match": 4
                }
            }
        ], "minimum_should_match": 3
    }
 } }

Lupanoide · Accepted Answer · 2018-04-13 10:55:54Z

0

Please read here . I have correct your query literally, but I can't understand why you are using a minimum_should_match clause in that way. minimum_should_match usually is used when you have more clauses than the number you specify there. For example if you have 4 should clauses, but for some reason you only need three of them to be fulfilled, you would assign 3 as value of minimum_should_match . According me this use of minimum_should_match could creates problems, so i have expunged minimum_should_match from your query. The correct syntax of your query is:

{
  "query": {
    "bool": {
      "must": [
        {
          "bool": {
            "must": [
              {
                "term": {
                  "country.id": 2000
                }
              },
              {
                "term": {
                  "natureservices.id": 2000
                }
              },
              {
                "term": {
                  "metiers.id": 1000
                }
              }
            ]
          }
        },
        {
          "bool": {
            "should": [
              {
                "term": {
                  "shortname": "vgftQzSPwW"
                }
              },
              {
                "term": {
                  "fullname": "qcouWRzFNG"
                }
              },
              {
                "term": {
                  "categories.id": 1000
                }
              },
              {
                "term": {
                  "specialities.id": 2000
                }
              }
            ]
          }
        }
      ]
    }
  }
}

edited Apr 13, 2018 at 10:55

answered Apr 13, 2018 at 10:16

Lupanoide

3,24225 silver badges38 bronze badges

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

1 Comment

Aymen Kanzari Over a year ago

Thank you for your answer. How can i modify this query according to this condition: if(valueShortName != null) { shortname = valueShortName} OR if(valueFullName != null) { fullname = valueFullName }

Collectives™ on Stack Overflow

combine two bool queries in elasticsearch

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related