topic Re: Dashboard CSV Variable and DQL filter in query in Dashboarding

Dashboard CSV Variable and DQL filter in query

almog50 — Tue, 24 Dec 2024 11:13:26 GMT

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

Re: Dashboard CSV Variable and DQL filter in query

sia_h — Tue, 24 Dec 2024 12:15:24 GMT

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`]

Re: Dashboard CSV Variable and DQL filter in query

almog50 — Tue, 24 Dec 2024 12:23:36 GMT

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.