# The value in this field is too long and cannot be searched or filtered

**URL:** <https://discuss.elastic.co/t/the-value-in-this-field-is-too-long-and-cannot-be-searched-or-filtered/360699>\
**Category:** Kibana\
**Tags:** discover\
**Created:** [June 3, 2024, 9:39am UTC](https://discuss.elastic.co/t/the-value-in-this-field-is-too-long-and-cannot-be-searched-or-filtered/360699 "2024-06-03T09:39:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Subrahmanyam\_Veerank](https://avatars.discourse-cdn.com/v4/letter/s/d78d45/32.png) [@Subrahmanyam\_Veerank](https://discuss.elastic.co/u/Subrahmanyam_Veerank)\
**Post date:** [June 3, 2024, 9:39am UTC](https://discuss.elastic.co/t/the-value-in-this-field-is-too-long-and-cannot-be-searched-or-filtered/360699/1 "2024-06-03T09:39:23Z")

</div>

In the kibana discover the sql\_query field is there which is of type keyword and it is not displaying in the dashboard and when i checked in the discover it is showing as ignored value. How to resolve this issue? Kindly guide

---

<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:** [July 12, 2024, 5:00pm UTC](https://discuss.elastic.co/t/the-value-in-this-field-is-too-long-and-cannot-be-searched-or-filtered/360699/2 "2024-07-12T17:00:44Z")

</div>

Hi @Subrahmanyam_Veerank,

Looks like you would need to update the mapping and increase `ignore_above` setting [ignore\_above | Elasticsearch Guide [8.14] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/ignore-above.html)