# Dropdown with fixed list

**URL:** <https://discuss.elastic.co/t/dropdown-with-fixed-list/271395>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [April 27, 2021, 2:21pm UTC](https://discuss.elastic.co/t/dropdown-with-fixed-list/271395 "2021-04-27T14:21:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)\
**Post date:** [April 27, 2021, 2:21pm UTC](https://discuss.elastic.co/t/dropdown-with-fixed-list/271395/1 "2021-04-27T14:21:16Z")

</div>

Hi,  
Is it possible to add a predefined list of fields to a dropdown without extracting them from a query?

Thank you

---

<div class="post-metadata">

**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\
**Post date:** [April 29, 2021, 5:37am UTC](https://discuss.elastic.co/t/dropdown-with-fixed-list/271395/2 "2021-04-29T05:37:59Z")

</div>

AFAIK  
No.

---

<div class="post-metadata">

**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\
**Post date:** [April 30, 2021, 4:24am UTC](https://discuss.elastic.co/t/dropdown-with-fixed-list/271395/3 "2021-04-30T04:24:19Z")

</div>

Well the result from a query is a datatable. You probably can define your own datatable (never tested just thinking).. but whats the target to do it?

---

<div class="post-metadata">

**Author:** ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)\
**Post date:** [April 30, 2021, 7:02am UTC](https://discuss.elastic.co/t/dropdown-with-fixed-list/271395/4 "2021-04-30T07:02:37Z")

</div>

How can I define my datatable?

I would create a dropbox with pre-defined value. Once I have selected the value, it modifies a query that allows the display of a graph.

I've already tried to do this .... but this changes all queries on all pages!

Thanks!

---

<div class="post-metadata">

**Author:** ![Felix\_Roessel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felix_roessel/32/41623_2.png) [@Felix\_Roessel](https://discuss.elastic.co/u/Felix_Roessel)\
**Post date:** [April 30, 2021, 1:56pm UTC](https://discuss.elastic.co/t/dropdown-with-fixed-list/271395/5 "2021-04-30T13:56:56Z")

</div>

What you need is the csv function. You add your data structure in csv format and the result is da datatable that can be used for the filter element.  
Take care that the name of your filter column equals the field name in the elastic index.

> **[Canvas function reference | Kibana Guide \[7.12\] | Elastic](https://www.elastic.co/guide/en/kibana/current/canvas-function-reference.html#csv_fn)**

---

<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:** [May 28, 2021, 1:57pm UTC](https://discuss.elastic.co/t/dropdown-with-fixed-list/271395/6 "2021-05-28T13:57:26Z")

</div>

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