Error while using multiple variable in Grafana

[DemPago]

What happened?

"When using Grafana, I am making a JQL query on Azure Monitor as a data source, and when I select 'multi-value,' the query does not return any values."
This is the query:
| where Nome_ente contains ("$Name") or "$Name" contains_cs "All"

Here the date about Name
$Name is a query variable.

It's something wrong?

What did you expect to happen?

"I would like to visualize a multi-value query."

Did this work before?

Never

How do we reproduce it?

1. Use Azure Monitor as Data Source
   2.| use a query like this where Nome_ente contains ("$Name") or "$Name" contains_cs "All"

2. Set multi value on the variable

Is the bug inside a dashboard panel?

no

Environment (with versions)?

Grafana: ver 10
OS: Mac OS Sonoma
Browser: Chrome

Grafana platform?

I use Grafana Cloud

Datasource(s)?

Azure Monitor

[aangelisc]

Hi @DemPago, thank you for opening this issue. To confirm:

• Do you see data when selecting a single value for the multi-value template variable?
• Do you see data when you select the All option?

[DemPago]

I see data with one value or all but not with multiple value Il mer 17 apr 2024, 21:38 Andreas Christou ***@***.***> ha scritto:

…

Hi @DemPago <https://github.com/DemPago>, thank you for opening this issue. To confirm: - Do you see data when selecting a single value for the multi-value template variable? - Do you see data when you select the All option? — Reply to this email directly, view it on GitHub <#84838 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A53VOJALNHN2EXQFF5AEGK3Y53FS7AVCNFSM6AAAAABE7XUPYOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRSGA4DCNJYHE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[bossinc]

@DemPago The contains operator does not work with a list of values. https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/contains-operator

I think you are looking for the in operator. https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/in-cs-operator

[DemPago]

Thanks but doesent work the in operator. Il mar 7 mag 2024, 00:37 Andrew Hackmann ***@***.***> ha scritto:

…

@DemPago <https://github.com/DemPago> The contains operator does not work with a list of values. https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/contains-operator I think you are looking for the in operator. https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/in-cs-operator — Reply to this email directly, view it on GitHub <#84838 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A53VOJCMDS3HEKFSXMQBCPLZBAA3LAVCNFSM6AAAAABE7XUPYOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJXGA2DIMBXGI> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[bossinc]

@DemPago What do you expect the query to look like after executing the template variables?

| where Nome_ente contains ("name1", "name2") is not valid KQL. contains expects only 1 value.

[bossinc]

I am closing this issue for now. Let me know if you have more questions or if this wasn't resolved.

[DemPago]

Hi Andrew the problem is up & running. From a kusto query is impossibile to use the multi selection on a variable. Il mer 29 mag 2024, 03:20 Andrew Hackmann ***@***.***> ha scritto:

…

I am closing this issue for now. Let me know if you have more questions or if this wasn't resolved. — Reply to this email directly, view it on GitHub <#84838 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/A53VOJHKICSNOQXIAANHDQDZEUUPHAVCNFSM6AAAAABE7XUPYOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMZWGM2DQNRSGM> . You are receiving this because you were mentioned.Message ID: ***@***.***>