Combining regexp query with query_string elastic search

Question

I have a query string as follows:

query_body_text = {
    "from" : 0 ,
    "size": 7000,
    "query": {
    "query_string": {
      "query": "document_OrderName:(Mystuff) AND document_CreatedWhen:[2017-01-01T00:00:00.000+00:00 TO 2017-01-31T00:00:00.000+00:00]"
     }
   }
 }

I want to be able to search the field body_analysed for a regular expression in these documents

I know I can phrase this as below but how do I combine this with the query above for the field of interest?

"query": {
    "regexp": {
      "user.id": {
        "value": "k.*y",
        "flags": "ALL",
        "case_insensitive": true,
        "max_determinized_states": 10000,
        "rewrite": "constant_score"
      }
    }
  }

Bhavya · Accepted Answer · 2021-06-10 08:03:22Z

2

You can use a boolean query to combine both the query

should clause works like a logical OR operator and must clause works like a logical AND operator

{
  "query": {
    "bool": {
      "should": [
        {
          "query_string": {
            "query": "document_OrderName:(Mystuff) AND document_CreatedWhen:[2017-01-01T00:00:00.000+00:00 TO 2017-01-31T00:00:00.000+00:00]"
          }
        },
        {
          "regexp": {
            "user.id": {
              "value": "k.*y",
              "flags": "ALL",
              "case_insensitive": true,
              "max_determinized_states": 10000,
              "rewrite": "constant_score"
            }
          }
        }
      ]
    }
  }
}

answered Jun 10, 2021 at 8:03

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

Combining regexp query with query_string elastic search

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