elasticsearch query by array of id result returned is not sorted by the array of id pass in

Question

I am using elastica and below is my query :

    $query = new Query();

    $query->setSize(5);

    $qb = new \Elastica\Query\Ids();

    $qb->addId("id_5");
    $qb->addId("id_3");
    $qb->addId("id_4");
    $qb->addId("id_1");
    $qb->addId("id_2");

    return $query->setQuery($qb)

I want the result return in the same order as what I passed in for example in this case it will be "id_5, id_3, id_4, id_1, id_2"

however what i get is the sorting is not the same as what I wanted

Do you have id as part of document?

Vova Bilyachat
– Vova Bilyachat

2016-03-03 11:08:29 +00:00
Commented Mar 3, 2016 at 11:08 — Vova Bilyachat
– Vova Bilyachat, Commented Mar 3, 2016 at 11:08

Vova Bilyachat · Accepted Answer · 2016-03-03 11:14:28Z

1

I see this as two solution 1. if you have id as part of document then you can do

POST indexName/_search
{
  "sort": [
    {
      "_script": {
        "type": "number",
        "script": "sortOrder.indexOf(doc['Id'].value)",
        "params": {
          "sortOrder": [
            "AVMX9sHTyNVr4SjF3oRt",
            "AVMTc1fSyNVr4SjF3WpF",
            "AVMYuGLOyNVr4SjF3rKm"
          ]
        },
        "order": "asc"
      }
    }
  ],
  "query": {
    "ids": {
      "values": [
        "AVMX9sHTyNVr4SjF3oRt",
            "AVMTc1fSyNVr4SjF3WpF",
            "AVMYuGLOyNVr4SjF3rKm"
      ]
    }
  }
}

If not then you need to update mapping for your type to be

{
  "mappings": {
    "YOUR_TYPE": {
      "_id": {
        "index": "not_analyzed"
      }
    }
  }
}

Then you can use "script": "sortOrder.indexOf(doc['_id'].value)"

answered Mar 3, 2016 at 11:14

Vova Bilyachat

19.5k4 gold badges60 silver badges88 bronze badges

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

3 Comments

MinFu Over a year ago

how can i do this with elastica?

MinFu Over a year ago

i had this error failed to run inline script [sortOrder.indexOf(doc["Id"].value)] using lang [groovy]

Vova Bilyachat Over a year ago

Can you post example of any of you documetns in index?

Collectives™ on Stack Overflow

elasticsearch query by array of id result returned is not sorted by the array of id pass in

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related