Elastic Search query string request

Question

I am using elastic search in my Android application. I am passing filters in query string like below:

URL/IndexName/TypeName/_search?sort=registry_date:desc&from=0&size=10&q=firstname:رشید

That works fine. But i want to apply a prefix filter on firstname field for achieving below thing through query string:

{
  "query": {
    "bool": {
      "must": [
        {
          "prefix": {
            "firstname.keyword": "رشید"
          }
        }
      ],
      "must_not": [],
      "should": []
    }
  },
  "from": 0,
  "size": 10,
  "sort": [
    {
      "registry_date": {
        "order": "desc"
      }
    }
  ],
  "aggs": {}
}

Any help?

By prefix filter do you mean, for example, all names starting with "Fre". Would match "Fred" and "Freddy"? — Rishi Diwan
– Rishi Diwan, Commented Mar 9, 2018 at 9:51
@RishiDiwan yes . And I am referring to the prefix word in structured query in my question. — Naila
– Naila, Commented Mar 9, 2018 at 9:55
What is your ES version? If sufficiently updated elastic.co/guide/en/elasticsearch/reference/current/… — Rishi Diwan
– Rishi Diwan, Commented Mar 9, 2018 at 9:59

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

I cannot find now where I found this but for me (on Elasticsearch version 5.4) works something like this:

URL/IndexName/TypeName/_search?source=PLACE_JSON_HERE

where PLACE_JSON_HERE could be entire JSON which you are passing as a POST body.

So for example:

URL/IndexName/TypeName/_search?source={"query":{"match_all":{}}}

will return all the documents.

In your situation you can even replace the PLACE_JSON_HERE with:

{
  "query": {
    "bool": {
      "must": [
        {
          "prefix": {
            "firstname.keyword": "رشید"
          }
        }
      ],
      "must_not": [],
      "should": []
    }
  },
  "from": 0,
  "size": 10,
  "sort": [
    {
      "registry_date": {
        "order": "desc"
      }
    }
  ],
  "aggs": {}
}

But as I said I cannot find this in ES documentation now so I do not know if it works on all versions.

UPDATE

Tested on 6.2.2 version:

http://localhost:9200/_doc/_search?source={"query":{"match_all":{}}}&source_content_type=application/json

Works as expected. source_content_type is required with source since ES 6.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 9, 2018 at 10:54

Piotr Pradzynski

4,5555 gold badges30 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Piotr Pradzynski Over a year ago

@Naila please take a look at my update. It works for me on the newest ES (6.2.2) version.

Collectives™ on Stack Overflow

Elastic Search query string request

1 Answer 1

UPDATE

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

UPDATE

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related