Dashboard CSV Variable and DQL filter in query

[almog50]

Hi,

I have the following DQL 

fetch dt.entity.cloud_application, from: -30m 
| fields workload.name = entity.name, workload.labels = cloudApplicationLabels
| filter in(workload.name,array( $workload_name ))
| fields service = workload.name, version = workload.labels[`app.kubernetes.io/version`]

$workload_name is a CSV variable

I want the query to list every to find every value in the $workload_name but it return only the first value in the CSV variable

[sia_h · Accepted solution]

This should work if you use the multi-select option:

fetch dt.entity.cloud_application, from: -30m 
| fields workload.name = entity.name, workload.labels = cloudApplicationLabels
| filter in(workload.name, $workload_name)
| fields service = workload.name, version = workload.labels[`app.kubernetes.io/version`]

[almog50]

Thank you,

The solution works as intended. I did not want the variable to be displayed on the dashboard, it should remain a static variable. Additionally, I was unaware that the Multi-select option under display settings would impact the results.