Unable to Search middle substring of word from sentence

OpenSearch
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
1.3

Describe the issue:
Unable to Search middle substring of word from sentence

Configuration:
aws open search 1.3 version

Relevant Logs or Screenshots:
target skuit name : CHOC Milk 24X125ml

request:
{
“from”: 0,
“size”: 100,
“query”: {
“bool”: {
“filter”: [
{
“terms”: {
“company_id”: [
1740
],
“boost”: 1
}
},
{
“term”: {
“is_active”: {
“value”: true,
“boost”: 1
}
}
},
{
“terms”: {
“isvisible_retailer”: [
true
],
“boost”: 1
}
}
],
“should”: [
{
“query_string”: {
“query”: “(125*)”,
“default_field”: “name”,
“fields”: ,
“type”: “best_fields”,
“default_operator”: “or”,
“max_determinized_states”: 10000,
“enable_position_increments”: true,
“fuzziness”: “AUTO”,
“fuzzy_prefix_length”: 0,
“fuzzy_max_expansions”: 50,
“phrase_slop”: 0,
“analyze_wildcard”: true,
“escape”: false,
“auto_generate_synonyms_phrase_query”: true,
“fuzzy_transpositions”: true,
“boost”: 1
}
}
],
“adjust_pure_negative”: true,
“minimum_should_match”: “1”,
“boost”: 1
}
},
“highlight”: {
“fields”: {
“name”: {}
}
}
}
response :
{
“took”: 23,
“timed_out”: false,
“_shards”: {
“total”: 16,
“successful”: 16,
“skipped”: 0,
“failed”: 0
},
“hits”: {
“total”: {
“value”: 0,
“relation”: “eq”
},
“max_score”: null,
“hits”:
}
}

2

Firstly, you can use the _analyze API to check the generated tokens for that text:

POST test1/_analyze
{
  "text": "CHOC Milk 24X125ml"
}

, you can see that that text generates 3 tokens by default analyzer:

{
  "tokens": [
    {
      "token": "choc",
      "start_offset": 0,
      "end_offset": 4,
      "type": "<ALPHANUM>",
      "position": 0
    },
    {
      "token": "milk",
      "start_offset": 5,
      "end_offset": 9,
      "type": "<ALPHANUM>",
      "position": 1
    },
    {
      "token": "24x125ml",
      "start_offset": 10,
      "end_offset": 18,
      "type": "<ALPHANUM>",
      "position": 2
    }
  ]
}

, so in order to match the token 24x125ml, you need to query *125* instead of 125*.