# Fetch list in dropdown from newest in index

**URL:** <https://discuss.elastic.co/t/fetch-list-in-dropdown-from-newest-in-index/276009>\
**Category:** Kibana\
**Created:** [June 15, 2021, 1:40pm UTC](https://discuss.elastic.co/t/fetch-list-in-dropdown-from-newest-in-index/276009 "2021-06-15T13:40:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mik\_a](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mik_a/32/78256_2.png) [@Mik\_a](https://discuss.elastic.co/u/Mik_a)\
**Post date:** [June 15, 2021, 1:40pm UTC](https://discuss.elastic.co/t/fetch-list-in-dropdown-from-newest-in-index/276009/1 "2021-06-15T13:40:07Z")

</div>

I made a drop down for the filter with the Controls type in kibana visualizations.  
however it seem like this is starting the fetch from the beginning of the index, and if a keyword/value is indexed for the first time yesterday it will not find it.  
Certain keywords was found only after i put in kibana.yml

```auto
kibana.autocompleteTerminateAfter: 6000000 

```

That is 6million. However the first 4million doc or so are quite old.  
How can I rerverse the fetch for the dropdown?  
Unique values are only a few hundreds or thousand.

---

<div class="post-metadata">

**Author:** ![Mik\_a](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mik_a/32/78256_2.png) [@Mik\_a](https://discuss.elastic.co/u/Mik_a)\
**Post date:** [June 16, 2021, 12:29pm UTC](https://discuss.elastic.co/t/fetch-list-in-dropdown-from-newest-in-index/276009/2 "2021-06-16T12:29:07Z")

</div>

anyone knows if this is even possible?

---

<div class="post-metadata">

**Author:** ![dosant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dosant/32/64489_2.png) [@dosant](https://discuss.elastic.co/u/dosant)\
**Post date:** [June 17, 2021, 10:38am UTC](https://discuss.elastic.co/t/fetch-list-in-dropdown-from-newest-in-index/276009/3 "2021-06-17T10:38:58Z")

</div>

Don't think this is possible to reverse.

But you might want try `use time filter` option. This will filter list results using current dashboard's time range, hence should be faster for smaller time ranges.

 ![Screen Shot 2021-06-17 at 12.36.49](https://us1.discourse-cdn.com/elastic/original/3X/9/e/9eaa60ba456f8095542a9a237386cd3d79f435e8.png)

---

<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 15, 2021, 10:39am UTC](https://discuss.elastic.co/t/fetch-list-in-dropdown-from-newest-in-index/276009/4 "2021-07-15T10:39:43Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.