How to join two queries in one using elasticsearch?

Question

Hi I want to join two queries in one in elasticsearch, but I don't know how to do it: I think I should do an aggregation but I don't know very clear how to do it. Could you help me? My ES version is 5.1.2.

First filter by status and name:

POST test_lite/_search
{
   "aggs": {
      "filtered": {
         "filter": {
            "bool": {
               "must": [
                  {
                     "match": {
                        "STATUS": "Now"
                     }
                  },
                  {
                     "match": {
                        "NAME": "PRUDENTL"
                     }
                  }
               ]
            }
         }
      }
   }
}

Look for in the filtered records for the word filtered in description:

POST /test_lite/_search
{
   "query": {
        "wildcard" : { "DESCRIPTION" : "*english*" }
    }
}

score 0 · Accepted Answer · answered Aug 22 '17 at 12:20

The only query needed is:

POST test_lite/_search
{
   "query": {
            "bool": {
               "must": [
                  {
                     "match": {
                        "STATUS": "Now"
                     }
                  },
                  {
                     "match": {
                        "NAME": "PRUDENTL"
                     }
                  },
                     {"wildcard" : { "DESCRIPTION" : "*english*" }}
               ]
      } 
   }   
}

How to join two queries in one using elasticsearch?

1 Answers1