Alert is not working when variables is used the query

What happened:I created an alert on one of the dashboards but it giving the error

ALERTING
Error: tsdb.HandleRequest() response error &{invalid: error @1:17-1:23: undefined identifier Bucket A <nil> [] [] 0xc000ebef60}
Feb 18, 2021 08:48:01

PENDING
Error: tsdb.HandleRequest() response error &{invalid: error @1:17-1:23: undefined identifier Bucket A <nil> [] [] 0xc000b13e90}
Feb 18, 2021 07:12:01

What you expected to happen : I expected to get the alert on my email after one hour or specified time period.

How to reproduce it (as minimally and precisely as possible) :
I have used Influx DB 2.0 as data source and used flux query for creating the dashboards and set up the alert for it. I have used the variable in my flux query.

Anything else we need to know? :
Query is running fine and its updating the values as well.

Environment :

  • Grafana version: 7.4.0
  • Data source type & version: InfluxDB 2.4.0
  • OS Grafana is installed on: Docker Image
  • User OS & Browser: Windows 10 and Mozilla firefox

I am mentioning my Influxdb flux query as well.

from(bucket: "${Bucket}")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "cu_kpi")
  |> filter(fn: (r) => r["_field"] == "field_provided")
  |> aggregateWindow(every: 24h, fn: last, createEmpty: false)
  |> yield(name: "last")

from(bucket: "${Bucket}")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "cu_kpi")
  |> filter(fn: (r) => r["_field"] == "field_provided")
  |> aggregateWindow(every: 1s, fn: last, createEmpty: false)
  |> yield(name: "last")


Annotations you can see it showing on Grafana dashboard panel.

Same here :

Grafana : v8.1.1 (90c87a52f7)
Datasource : MS SQL
Alerting : Webhook

When using a variable in the query WHERE clause

point IN(${varname})

the grafana log shows lines lik this

t=2021-08-17T09:34:33+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name="Trending Server 1 alert" error="request handler response error {db query error: mssql: Incorrect syntax near '{'.  A 0xc0014a5770 [] [] 0xc001412990}" changing state to=alerting
t=2021-08-17T09:34:35+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name="Trending Server 1 alert" error="request handler response error {db query error: mssql: Incorrect syntax near '{'.  A 0xc001616f00 [] [] 0xc001413bf0}" changing state to=alerting
t=2021-08-17T09:34:37+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=1 name="Trending Server 1 alert" error="request handler response error {db query error: mssql: Incorrect syntax near '{'.  A 0xc0018164c0 [] [] 0xc001441050}" changing state to=alerting

When I remove the variable and replace it with a fixed value that exists and has data

point IN('VALID VALUE')

Grafana logging is like this

t=2021-08-17T09:39:53+0000 lvl=info msg="New state change" logger=alerting.resultHandler ruleId=1 newState=ok prev state=alerting
t=2021-08-17T09:39:53+0000 lvl=info msg="Sending webhook" logger=alerting.notifier.webhook
t=2021-08-17T09:40:33+0000 lvl=info msg="New state change" logger=alerting.resultHandler ruleId=1 newState=pending prev state=ok
t=2021-08-17T09:40:39+0000 lvl=info msg="New state change" logger=alerting.resultHandler ruleId=1 newState=alerting prev state=pending
t=2021-08-17T09:40:39+0000 lvl=info msg="Sending webhook" logger=alerting.notifier.webhook

https://community.grafana.com/t/template-variables-are-not-supported-in-alert-queries-while-setting-up-alert/2514/16

Seems to be a long discussion already.