# Field sorting in discover

**URL:** https://discuss.elastic.co/t/field-sorting-in-discover/373530
**Category:** Kibana
**Tags:** discover
**Created:** [January 22, 2025, 5:29pm UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530 "2025-01-22T17:29:54Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![venxxx](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/venxxx/32/140864_2.png) [@venxxx](https://discuss.elastic.co/u/venxxx)
#### Post date: [January 22, 2025, 5:29pm UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/1 "2025-01-22T17:29:54Z")

</div>

i am trying to sort on the 'field' column but the sorting is disabled somehow. i checked the dataview and it shows 38 fields available, but in discover there are only 18 fields.

 ![Screenshot 2025-01-22 123104](https://us1.discourse-cdn.com/elastic/original/3X/f/8/f82868e1edca372af11bbd6f0995cf460e98cecd.png)

---

<div class="post-metadata">

### Author: ![jughosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jughosta/32/107160_2.png) [@jughosta](https://discuss.elastic.co/u/jughosta)
#### Post date: [January 23, 2025, 8:56am UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/2 "2025-01-23T08:56:24Z")

</div>

Hi @venxxx and welcome to the community!

Looks like the currently selected `seq_number` field has text type. Text fields are not sortable, only fields with keyword, number etc types.

---

<div class="post-metadata">

### Author: ![venxxx](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/venxxx/32/140864_2.png) [@venxxx](https://discuss.elastic.co/u/venxxx)
#### Post date: [January 23, 2025, 4:59pm UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/3 "2025-01-23T16:59:59Z")

</div>

Hi there,

thank you for your reply. yes, I did notice this. there is seq\_number.keyword in data view settings, but it didn't show up on discover view.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/6/b60acdbaf92c87cc3fa08f44ba61c28161c6a01f.png)

---

<div class="post-metadata">

### Author: ![venxxx](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/venxxx/32/140864_2.png) [@venxxx](https://discuss.elastic.co/u/venxxx)
#### Post date: [January 23, 2025, 5:00pm UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/4 "2025-01-23T17:00:50Z")

</div>

this is discover view

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/9/59b8cd000a670628ed509dcd6559305fa54b0fbb.png)

---

<div class="post-metadata">

### Author: ![jughosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jughosta/32/107160_2.png) [@jughosta](https://discuss.elastic.co/u/jughosta)
#### Post date: [January 23, 2025, 5:33pm UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/5 "2025-01-23T17:33:20Z")

</div>

When you press on `seq_number` in the fields sidebar, it should open a popover. Inside that popover I would expect to see `seq_number.keyword` which you can then add to the table.

---

<div class="post-metadata">

### Author: ![venxxx](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/venxxx/32/140864_2.png) [@venxxx](https://discuss.elastic.co/u/venxxx)
#### Post date: [January 23, 2025, 6:02pm UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/6 "2025-01-23T18:02:16Z")

</div>

Thank you so much! Added seq\_number.keyword to the view, but how to sort it based on the value of number? now it seems like it's sorting on text.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/7/07ccb1df8e4c5b02bb40ca037a73bbcebcc7837a.png)

---

<div class="post-metadata">

### Author: ![venxxx](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/venxxx/32/140864_2.png) [@venxxx](https://discuss.elastic.co/u/venxxx)
#### Post date: [January 23, 2025, 6:34pm UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/7 "2025-01-23T18:34:10Z")

</div>

got this issue now after I changed the grok filter as %{INT:field:int}

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/0/c033d7740cd25a32da7734444f31446405aff849.png)

---

<div class="post-metadata">

### Author: ![jughosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jughosta/32/107160_2.png) [@jughosta](https://discuss.elastic.co/u/jughosta)
#### Post date: [January 24, 2025, 9:25am UTC](https://discuss.elastic.co/t/field-sorting-in-discover/373530/8 "2025-01-24T09:25:02Z")

</div>

Does your data view target multiple indices? Then mapping should be changed for all of them.

Also, mapping changes might require reindexing of the data.