Define ordering in wildcard query

v_kumar · September 30, 2021, 2:12pm

Hi,
In one of our use-case we're using a wildcard query on a field("cmpy") with searchQuery(val). Let's say values on different documents for "cmpy" field is "val", "1 val", "a value". Ask is, is there a way to order the results such as exactly matched text("val") should be on top & then followed by other documents? Tried "rewrite" as well but couldn't able to get "val" on top of the results.

Es_version: 6.4

dadoonet · September 30, 2021, 3:10pm

You could use ngram or edge ngram based analyzers to index your field in addition to the default analyzer.
Then you can query both fields and boost if neede the field with exact match.

Some examples at:

gist.github.com

https://gist.github.com/dadoonet/1a599c3e68420aa95ade73fe58b9e0a1

jussieu1.js

DELETE user
PUT user
{
  "settings": {
    "number_of_shards": 1
  }, 
  "mappings": {
    "_doc": {
      "properties": {
        "name": {

This file has been truncated. show original

jussieu2.js

DELETE user
PUT user
{
  "settings": {
    "number_of_shards": 1,
    "analysis": {
      "analyzer": {
        "for_synonyms": {
          "type":      "custom",
          "tokenizer": "standard",

This file has been truncated. show original

jussieu3.js

DELETE user
PUT user
{
  "settings": {
    "number_of_shards": 1,
    "analysis": {
      "analyzer": {
        "for_synonyms": {
          "type":      "custom",
          "tokenizer": "standard",

This file has been truncated. show original

There are more than three files. show original

Es_version: 6.4

It's urgent that you upgrade to at the very least 6.8 or better 7.15.0.

v_kumar · September 30, 2021, 5:11pm

Got it. @dadoonet Thanks for your reply. Yes David we'll be updating our ES version to the latest in the coming months.

system · October 28, 2021, 5:11pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.