Hello guys, I'm new to the Elasticsearch world and I'm sorry if my doubt is very basic. I need to create an index on there will be a type that will store a product catalog. In this there will be several fields but what I need to use for research is only one DESCRIPTION field. Examples of contents …

Hi Fabricio, you can use a wild card query: "CH COMB*06*" https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-wildcard-query.html

Hello, thanks for the quick response. I had already tried with the link instruction that you passed. However I was not successful. For example: I have a product that the description is: "ARMARIO P/FERRAMENTA AM-2 / MARCON". If I use the query as written below, it returns results: { "query": …

you can use 2 x must much : "query": { "bool": { "must": [ {"match": {"descricao": "arma"}}, {"match": {"descricao":"ferra"}} ] } }

Using wildcard I got a result very close to what I need. But now I have another problem. For example, in my SQL database, if I send the following query (SELECT * FROM produtos WHERE descricao LIKE 'PF%SX%1/2%') I get the following result: PF SX D 3/16X1/2 RI BSW-24 G2 PO PF SX D 3/16X 1.1/2 RI B…

You will need to change the mapping of the field to not be analyzed, otherwise the slashes will not be indexed. you can check these 2 posts on how to use slashes in filters: https://discuss.elastic.co/t/how-to-use-slash-to-search-in-discovery/92340 [Alexey] How to use slash (…

Discuss the Elastic Stack

Search for parts of a string field

Elastic Stack Elasticsearch

Mark_Harwood (Mark Harwood) February 18, 2020, 8:22am 5

See this topic about double wildcards

Topic		Replies	Views
ElasticSearch - Searching partial text in String Elasticsearch	4	10460	November 13, 2022
Wildcard is not working as expected Elasticsearch eql-elastic-query-language	7	972	May 24, 2024
Performing a partial word search without wildcards Elasticsearch	3	2845	July 6, 2017
Querying for fragment of string intersecting 2 words Elasticsearch	6	5206	August 3, 2019
Elastic simple query with wildcard Elasticsearch	2	345	July 19, 2021

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Search for parts of a string field

Related topics