# Dropdown filter didn't work

**URL:** <https://discuss.elastic.co/t/dropdown-filter-didnt-work/218115>\
**Category:** Kibana\
**Created:** [February 6, 2020, 8:40am UTC](https://discuss.elastic.co/t/dropdown-filter-didnt-work/218115 "2020-02-06T08:40:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![McSaesch](https://avatars.discourse-cdn.com/v4/letter/m/3bc359/32.png) [@McSaesch](https://discuss.elastic.co/u/McSaesch)\
**Post date:** [February 6, 2020, 8:40am UTC](https://discuss.elastic.co/t/dropdown-filter-didnt-work/218115/1 "2020-02-06T08:40:17Z")

</div>

Hi,  
my dropdown filter  
essql query="SELECT fields.FileType as fileType FROM "test\_index-\*" where fields.FileType is not null group by fields.FileType"  
| dropdownControl valueColumn="fileType" filterColumn="fileType" filterGroup="moin"  
| render

My data table  
filters group="moin" ungrouped=true  
| essql query="SELECT fields.FileName as File, fields.FileType as Type, fields.MessageType as Action, "@timestamp" as Date FROM "test\_index-\*" WHERE fields.FileType is not null and fields.MessageType = 'NewFile'"  
| table  
| render

If i select a filter value other than --ANY-- the data table will be empty....  
Is it the group by function in the dropdown filter ?  
Regards

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [February 12, 2020, 8:18am UTC](https://discuss.elastic.co/t/dropdown-filter-didnt-work/218115/2 "2020-02-12T08:18:07Z")

</div>

Hi @McSaesch,

The `filterColumn` parameter of the `dropdownControl` function has to be set to the full field name you want to filter by on the actual document - not the column name in the generated data table. It looks like the field name is `fields.FileType`, so could you try the following expression for the dropdown:

```auto
essql query="SELECT fields.FileType as fileType FROM "test_index-*" where fields.FileType is not null group by fields.FileType"
| dropdownControl valueColumn="fileType" filterColumn="fields.FileType" filterGroup="moin"
| render

```

---

<div class="post-metadata">

**Author:** ![McSaesch](https://avatars.discourse-cdn.com/v4/letter/m/3bc359/32.png) [@McSaesch](https://discuss.elastic.co/u/McSaesch)\
**Post date:** [March 4, 2020, 7:13am UTC](https://discuss.elastic.co/t/dropdown-filter-didnt-work/218115/3 "2020-03-04T07:13:37Z")

</div>

I've change the controls, but it won't work.

essql  
query="SELECT fields.FileType as fileType FROM "test-\*" where fields.FileType is not null group by fields.FileType"  
| dropdownControl valueColumn="fileType" filterColumn="fields.FileType" filterGroup="moin"  
| render

filters group="moin" ungrouped=true  
| essql  
query="SELECT fields.FileName as Datei, fields.FileType as Typ, fields.MessageType as Grund, "@timestamp" as Datum FROM "test-\*" WHERE fields.FileType is not null and fields.MessageType = 'NewFile' ORDER BY "@timestamp" desc"  
| table  
font={font family="'Open Sans', Helvetica, Arial, sans-serif" size=16 align="left" color="#444444" weight="bold" underline=false italic=false}  
| render  
containerStyle={containerStyle border="2px solid #FFFFFF" borderRadius="2px" backgroundColor="#BBBBBB"}

What did i wrong?

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [March 10, 2020, 9:11am UTC](https://discuss.elastic.co/t/dropdown-filter-didnt-work/218115/4 "2020-03-10T09:11:48Z")

</div>

Could you share your mapping and an example document? That will make it easier to reproduce your specific problem.

---

<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:** [April 7, 2020, 9:11am UTC](https://discuss.elastic.co/t/dropdown-filter-didnt-work/218115/5 "2020-04-07T09:11:50Z")

</div>

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