search multiple value in query_string Elastic search

Question

I use these queries in elastic but the problem is when I replace values I get some different result or when I use each word individually we have different result.here is part of my queries

"query_string" : {
      "query" : "businessId : 1848 4335",
      "fields" : []
}
result : "hits": {"total": 81,....}

when replace businessIds:

"query_string" : {
      "query" : "businessId : 4335 1848",
      "fields" : []
}
result :  "hits": {"total": 162,...}

when I search "4335"

"query_string" : {
      "query" : "businessId : 4335",
      "fields" : []
}
result :  "hits": {"total": 0,...}

search "1848"

"query_string" : {
      "query" : "businessId : 1848",
      "fields" : []
}
result :  "hits": {"total": 14,...}

when I use "businessId" in fields

"query_string" : {
      "query" : "4335 1848",
      "fields" : ["businessId"]
}
result :  "hits": {"total": 14,...}

I am so confused why these results happened?

Jozef - Spatialized.io · Accepted Answer · 2022-08-04 09:01:54Z

4

You can use a query string query like so:

{
  "query": {
    "query_string": {
      "query": "businessId:4335 OR businessId:1848"
    }
  }
}

or

{
  "query": {
    "query_string": {
      "query": "businessId:(4335 OR 1848)"
    }
  }
}

edited Aug 4, 2022 at 9:01

answered Apr 19, 2020 at 13:00

Jozef - Spatialized.io

17k4 gold badges29 silver badges79 bronze badges

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

2 Comments

saba safavi Over a year ago

thank you. but I know white space works as OR operator doesn't it?

Jozef - Spatialized.io Over a year ago

Not sure about that one. I haven't seen your mapping... First of all, are we talking strings or numbers?

Collectives™ on Stack Overflow

search multiple value in query_string Elastic search

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related