Dropdown select filter not working

Elastic Stack Kibana
1

Working with v7.14.1.

I'm trying to add a dropdown select filter to my workpad in Canvas, but it is not giving me the list of items in the dropdown. The preview data shows the list.

essql query="SELECT appId FROM \"oe.clickstream\"
group by appId"
| dropdownControl valueColumn="appId" filterColumn="appId" filterGroup="group1"
| render

I also tried below, but that doesn't work and the preview data does not show a unique list of appIds.

esdocs index="oe.clickstream" fields="appId"
| dropdownControl valueColumn="appId" filterColumn="appId" filterGroup="group1"
| render
2

Hi, checked on 7.14, I don't see any filterGroup parameter in the expression editor. Here's a example using the kibana_sample_data_flights and a similar SQL statement. Can you try it and see if it renders?

2021-11-15_16:28:50
2021-11-15_16:28:501009×997 65.7 KB

3

@jsanz I removed the filterGroup and it's working now. Thanks!

4

@jsanz I noticed I had to remove a table element that was on the page before the Dropdown select would work. Is that expected?

5

Not sure, but if you could open a new discussion, elaborating the steps you followed, ideally with one of the sample datasets, we can try to reproduce and eventually create an issue in our Github. Feel free to directly open the issue yourself if you can:

6

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