Searching Integer with wild cards

[Prashant.kasodariya (Prashant)]

Can anyone please help me identifying how to use wild cards for integer searches? I tried using the inline script but no luck. This is what I have tried (I have also tried with different regex pattern which works for javascript but here with the query, it does not work)..

"query": {
        "bool": {
            "must": {
            	"script" : {
            		"script" : {
            			"inline" : "doc['statCode'].value.toString().match('/9.*/')",
            			"lang" : "javascript"
            		}
            	}   
            }
        }
    }

[dadoonet (David Pilato)]

Why do you want to do something so complex and so bad in term of performance?

What are the different values you can have for statCode? Can't you use a range query instead?

[Prashant.kasodariya (Prashant)]

My requirement is to support wild card search for integer fields? Do you suggest any other way to achieve? how can we use range query for this? If the field has the value say 00123789 and if I want to search with *7 how do I use range query for it?

[dadoonet (David Pilato)]

Some comments:

• 00123789 is not an integer but a text. 123789 might be a number indeed. So what is your mapping?
• If it's indexed as a text, then the wildcard query might work. See https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-wildcard-query.html
• Note that it will be extremely slow. Specifically with *whatever form as mentioned in documentation.
• You can use ngrams if you want to be able to search for substrings. See https://www.elastic.co/guide/en/elasticsearch/reference/6.1/analysis-ngram-tokenizer.html. But it will use more space on disk and will take more time at index time. In which case wildcards won't be required as you will be able to search for something like 123 in you example.

[Prashant.kasodariya (Prashant)]

Yes I have indexed those as String and those are working as well but sorting is an issue currently. if I index them as string then it will not sort it as number (sorting order will not be proper). so I am trying to see if we have wildcard support for integer fields or there is an easy way to achieve it.

[dadoonet (David Pilato)]

You can index the same field as both text and number. Then sort on the later.