csv filter multi value not working

[yosiasz]

Greetings

I get the following error when using an IN filter

Department IN (${departments:singlequote})

error while performing the infinity inline query. error applying filter. error evaluating filter expression error: Value 'HR' cannot be used with the comparator 'in', it is not a number. row 0. Not applying filter

The UQL version of it works fine

parse-csv
| where "Department" in (${departments:singlequote})

Any idea what the issue might be?

[yesoreyeram]

hi @yosiasz - Can you post the actual/sample csv and complete query? Also see if https://grafana.com/docs/plugins/yesoreyeram-infinity-datasource/latest/query/filters/#with-multi-filter helps. ( note: IN is case sensitive. use in instead of IN when using UQL )

[yosiasz]

hello @yesoreyeram here is the community forum post I based it on

https://community.grafana.com/t/the-selection-of-one-variable-dynamically-filters-the-options-available-in-another/149766

[yosiasz]

Here is a dashboard demonstrating the issue 1st panel uses Backend Parser second one uses UQL

sample csv sorry did not include in original

Department,Team
Engineering,Backend
Engineering,Frontend
Engineering,DevOps
Sales,Inside
Sales,Field
HR,Recruiting
HR,Payroll

[yesoreyeram]

https://play.grafana.org/d/474f3ada-1c15-4e63-9c94-d10ec72f384b