How to do multiple text search in same field

Elastic Stack Elasticsearch
1

Hi,

I want to do multiple text search in same field

for example in sub_cat_seo_url field i want to get 'english-news' and 'business-news' filter by language and region

when i tried like below code it is not working

{
   "query":{
      "filtered":{
         "query":{
            "query_string":{
               "query":[
                  "english-news",
                  "business-news"
               ],
               "fields":[
                  "sub_cat_seo_url"
               ]
            }
         },
         "filter":{
            "bool":{
               "must":[
                  {
                     "term":{
                        "lang":"en"
                     }
                  },
                  {
                     "term":{
                        "region":"1"
                     }
                  }
               ]
            }
         }
      }
   }
}

For single text search it is working fine

{
   "query":{
      "filtered":{
         "query":{
            "query_string":{
               "query":"english-news",
               "fields":[
                  "sub_cat_seo_url"
               ]
            }
         },
         "filter":{
            "bool":{
               "must":[
                  {
                     "term":{
                        "lang":"en"
                     }
                  },
                  {
                     "term":{
                        "region":"1"
                     }
                  }
               ]
            }
         }
      }
   }
}

Please help what have to change in my code, to do multi text search in same field (or operation)

Thanks

Thanigaivelan

2

Maybe try this:

{
   "query":{
      "filtered":{
        "query": {
          "bool": {
            "should": [
              {
                "query_string": {
                  "query": "english-news",
                  "fields": ["sub_cat_seo_url"]
                }
              },
              {
                "query_string": {
                  "query": "business-news",
                  "fields": ["sub_cat_seo_url"]
                }
              }
            ]
          }
        },
         "filter":{
            "bool":{
               "must":[
                  {
                     "term":{
                        "lang":"en"
                     }
                  },
                  {
                     "term":{
                        "region":"1"
                     }
                  }
               ]
            }
         }
      }
   }
}
3

it is not working, it fetch only second search (business-news) not fetching the (english-news).

4

Then please provide a full recreation with example documents so that we can help you.

5

http://27378a470e566caadd54304da0d85849.us-east-1.aws.found.io:9200/episodes/episode/_search?pretty=true&size=100&from=0