Elasticsearch: How to combine regex query with filter

Question

I have a search that in some situations needs to be searched by a regex query

GET my-index/_search
{
  "query": {
    "regexp":{  
      "name":".*something.*"
    }  
  }

}

And sometimes needs to be filtered, like so:

GET /my-index/_search
{  
  "query":{  
      "bool":{  
      "filter":[  
           {  
              "term":{  
                 "createdByEmail.keyword":"[email protected]"
              }
           }
      ]
  }
}

I want to combine these 2 so that it will only show me resolts where the name matches the regex AND the createdByEmail matches the email address I'm sending in.

Nishant · Accepted Answer · 2019-03-20 00:55:43Z

5

You can add first query inside must clause of second as below:

{
  "query": {
    "bool": {
      "must": [
        {
          "regexp": {
            "name": ".*something.*"
          }
        }
      ],
      "filter": [
        {
          "term": {
            "createdByEmail.keyword": "[email protected]"
          }
        }
      ]
    }
  }
}

answered Mar 20, 2019 at 0:55

Nishant

7,9121 gold badge24 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch: How to combine regex query with filter

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