# Sort by filed(count) problem

**URL:** <https://discuss.elastic.co/t/sort-by-filed-count-problem/13026>\
**Category:** Elasticsearch\
**Created:** [August 1, 2013, 2:27am UTC](https://discuss.elastic.co/t/sort-by-filed-count-problem/13026 "2013-08-01T02:27:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vincent\_park](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vincent_park/32/800_2.png) [@vincent\_park](https://discuss.elastic.co/u/vincent_park)\
**Post date:** [August 1, 2013, 2:27am UTC](https://discuss.elastic.co/t/sort-by-filed-count-problem/13026/1 "2013-08-01T02:27:02Z")

</div>

hi guys

The result I just wanted is (as mysql)  
" ORDER BY count DESC "

so I did this :

{  
"query" : { text" : { "word" : "_blah_" } },  
"sort" : { "count" : { "order" : "desc" } }  
}

This Query is working fine..But it return value is NOT order by count desc.

result :  
{  
...  
"\_score" : null, "\_source" : {"word":"....", "count" ; "8"},  
"sort" : [-9223372036854775808]  
}  
{  
...  
"\_score" : null, "\_source" : {"word":"....", "count" ; "33"},  
"sort" : [-9223372036854775808]  
}  
{  
...  
"\_score" : null, "\_source" : {"word":"....", "count" ; "75"},  
"sort" : [-9223372036854775808]  
}  
{  
...  
"\_score" : null, "\_source" : {"word":"....", "count" ; "29"},  
"sort" : [-9223372036854775808]  
}  
..........

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:23am UTC](https://discuss.elastic.co/t/sort-by-filed-count-problem/13026/2 "2017-07-06T02:23:26Z")

</div>