Sorting on elastic search with node js

Question

For some reason, when I trying to search and sort from an index

This works:

GET indexName/_search
{      
    "sort": [{
      "_uid": { "order": "desc" }
    }],
    "size": 1

}

But, when using node js like this:

elasticClient.search({
     index: indexName,
     type: id,
     sort: [{ "_uid": { "order": "desc" } }],
     size: 1
 })

It returns an error:

No mapping found for [[object Object]] in order to sort on


status :400

I've tried JSON.stringify and all kind of other things, but none of them works

Please, can anyone help me?

Answer 1

Try this instead:

elasticClient.search({
     index: indexName,
     type: id,
     body: {
        sort: [{ "_uid": { "order": "desc" } }],
        size: 1,
        query: { match_all: {}}
     }
 })

Answer 2

This also works with the square brackets around it so you can add more than one sort criteria like ['_uid:desc', 'id:asc']

elasticClient.search({
         index: indexName,
         sort: ['_uid:desc'],
         type: id,
         body: {
            size: 1,
            query: { match_all: {}}
         }
     })

Answer 3

This also works :

elasticClient.search({
     index: indexName,
     sort: '_uid:desc',
     type: id,
     body: {
        size: 1,
        query: { match_all: {}}
     }
 })