From CSV, How to filter multiple values using Infinity Data source

  1. i have a CSV file having below data

PTNO,TEST1,Status,Resource,Description
1,Test1-1,Closed,Raj,Test3-1
2,Test1-2,Open,Ravi,Test3-2
3,Test1-3,In-Progress,Linga,Test3-3
4,Test1-4,Open,Chitra,Test3-4
5,Test1-5,Closed,Ajay,Test3-5
6,Test1-6,Open,Raj,Test3-6
7,Test1-7,Closed,Ravi,Test3-7
8,Test1-8,In-Progress,Ajay,Test3-8

#2. I have created a Variable as Status filter - Multiple check box

#3. When we select 1 status say Closed, i could see the table data reflecting with closed status

#4. When we select Closed & Open when we dont see data reflecting on the table.

Welcome @rajasekhar1480

Which plugin are you using

Hi Yoiasz - i m using "yesoreyeram-infinity-datasource " add-in

What does your filter look like

See if this helps Filtering data | Grafana Enterprise plugins documentation

1 Like


Hi Yosiasz - uploaded the snapshot… kindly take a look and advise

Thanks Yesoreyeram for sharing the link… ll review and see if i can resolve

1 Like

Thanks a lot @joachimschiewek for providing the solution… But i see 1 problem now.

The filter works fine when we set multiple options where as fails when we set with single option instead of Multiple option.

for multiple selection - pls refer attached working_status.png file - working fine as expected
with single selection - pls refer attached failed_status.png file

Could you pls assist the fix for single selection aswell


please try the UQL Parser…

Jo

1 Like

Works like a charm using UQL … Thanks @joachimschiewek for your time in resolving the issue… Appreciate it !!

Sorry you were having issues but glad you find the workaround.

I am able to reproduce this by meself. Seems there is an issue with the underlying library. I created a github issue to track this.

Hello,
It works well when i use inline source
but when i switch to url source i got this error :

Bests regards

Click or hover on fhat warning :warning: icon and see what it says

i was able to fix the issue and now i have a dashboard with chained variable setup.

Sorry for the inconvenience

1 Like