query string search is not working

Question

Hi I am using the not analyzed over the field

but when i search with the below query

 "query": {
    "query_string": {
      "query": "06H121605E",
      "default_field": "invoiceID"
    }
  }
}

I am getting 2 documents in results

but when I went for the wild card

its giving me hits as null

 "query": {
    "query_string": {
      "query": "06H121605*",
      "default_field": "invoiceID"
    }
  }

Here is my mapping for the invoiceID field

 "invoiceID": {
                  "type": "string",
                  "index": "not_analyzed"
               },

Query:

GET ordersdetails/_search
{
 "size": 1000, 
 "query": {
   "query_string": {
     "query": "06H121605E\\*",
     "default_field": "invoiceID",
     "analyze_wildcard": true
   }
 }
}

OUTPUT

{
   "took": 5,
   "timed_out": false,
   "_shards": {
      "total": 5,
      "successful": 5,
      "failed": 0
   },
   "hits": {
      "total": 0,
      "max_score": null,
      "hits": []
   }
}

mel · Accepted Answer · 2017-03-14 16:16:22Z

2

For the version 5.2.1 your query works you can as well use:

{
    "query": {
        "query_string" : { 
            "query" : "06H121605*",
            "default_field": "invoiceID",
            "analyze_wildcard": true
        }
    }
}

Here is the reference:

Documentation query string

edited Mar 14, 2017 at 16:16

answered Mar 14, 2017 at 13:43

mel

2,8209 gold badges42 silver badges71 bronze badges

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

7 Comments

prasad kp Over a year ago

Hi Mel thanks for your remarks .!!!!! but in the second query m using the wildcard character *, for this m getting hit as null should I go for standard analyzer or index: not_analyzed in mapping

prasad kp Over a year ago

"query": { "query_string": { "query": "06H121605*", "default_field": "partNumber", "analyze_wildcard": true } }

prasad kp Over a year ago

Still using * in search term and analyze wild card : true combination is giving me hits as Null

mel Over a year ago

Try to escape the * by doing \\* in your query

prasad kp Over a year ago

No luck with using escape sequence, Mel :(

|

Collectives™ on Stack Overflow

query string search is not working

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related