Hello, I am using "wildcard" for matching fields of type text with a specific pattern. "query": { "wildcard": { "description": { "value": "objective*", "case_insensitive": true, } } } } It should only match descriptio…

Hello @venkatesh_aamanchi , I think in this case you'll need to use the prefix query ( see docs ). With the prefix query you can search a field that starts with objective. Your query should look something like: GET /_search { "query": { "prefix": { "description": { "value": "obje…

Hi @piergm , Thanks for the response. "prefix" is used check against text to see if there are any words that start with the value that was provided in query. It does not work in this. But, I still tried and result is same as "objective". Any idea why wildcard is not working properly in my case?

The wildcard character means 0 or more characters of any type, so is working as expected. To get the result you want you may need to search the keyword field for *objective:*, but be aware that this type of wildcard queries can be very slow.

@dadoonet The combination of wildcard with description.keyword actually worked. Thank you

@Christian_Dahlqvist I am new to elasticsearch. But, wildcard is supposed to match the pattern right? Actually, I tried query "query_string" and "regex" in place of wildcard, the search still yielded wrong results.

It will depend onthe mapping of the field. If you are querying a field mapped as text the tokens will be indexed individually. I believe the default analyser will remove certain characters, so objective: will be indexed as objective. If you search for objective* the wildcard means 0 or more characte…

Wildcard is not working as expected

Elastic Stack Elasticsearch

dadoonet (David Pilato) May 24, 2024, 8:15am 3

You need to search within the description.keyword field instead. As the description field is analyzed and broken into tokens.

Topic		Replies	Views
Wildcard search not working for text field Elasticsearch	8	3299	July 11, 2018
Search character ( wild card ) Elasticsearch	8	930	April 29, 2020
Use wildcard data type ,The number of events does not match when querying Elasticsearch	6	786	October 1, 2020
Search for parts of a string field Elasticsearch	7	1003	March 17, 2020
Searching on text fields using wildcard Elasticsearch	5	5703	October 13, 2020

Wildcard is not working as expected

Related topics