I'm using the clickhouse connector and trying to use the ad-hoc filterable property ovverride for a field of a table.
This creates a lens logo on the rows of the table that when clicked creates the filters by excluding or including values.
When creating the filter by selecting the column and value from the dropdown on the classic grafana variables bar the filter works perfectly. The available columns shown in the dropdown are formatted as 'mytablename.mycolumnname'
When creating the filter by clicking on the lenses with the intention of excluding (or including) a certain value the data shown on dashboard remains untouched. I noticed that when interacting with filters by clicking on the lenses the filter grafana variable gets created without the table name ('mycolumname')
I'm using the clickhouse connector and trying to use the ad-hoc filterable property ovverride for a field of a table. This creates a lens logo on the rows of the table that when clicked creates the filters by excluding or including values.
When creating the filter by selecting the column and value from the dropdown on the classic grafana variables bar the filter works perfectly. The available columns shown in the dropdown are formatted as 'mytablename.mycolumnname'
When creating the filter by clicking on the lenses with the intention of excluding (or including) a certain value the data shown on dashboard remains untouched. I noticed that when interacting with filters by clicking on the lenses the filter grafana variable gets created without the table name ('mycolumname')