Dashboard variable not working

Grafana Data Links
1

In my dashboard, I have three elements. one dashboard variable and two panels.

the first panel has the following sql code

SELECT DISTINCT

TransportPlatte

FROM [dbo].[TR]

WHERE MeasurementDateUtc BETWEEN $__timeFrom() AND $__timeTo()

GROUP BY TransportPlatte

ORDER BY TransportPlatte;

it returns all the plates produced within the time period. I have added a data link with the following URL

d/d14229ce69ef/${__dashboard}?orgId=1&var-Platte=${__value.raw}

The second element is the dashboard variable with type custom. In the values separated by commas field, I have entered ${Platte}

This part works as expected. When I click on one of the plates, the value for the dashboard variable gets updated to the new plate number. The problem is the next part

SELECT

v.[Position],

v.[Thickness]

FROM [dbo].[TR] m

JOIN [dbo].[dataTR] v

ON m.MeasId = v.MeasId

WHERE MeasurementDateUtc BETWEEN $__timeFrom() AND $__timeTo()

AND [ThisPlate] = $Platte

ORDER BY m.MeasurementDateUtc DESC;

Here, the panel is just continuously loading. Instead of $Platte when I type in the actual plate number, then it works instantly.

2

What data type are ThisPlatte and TransportPlatte

3

I believe it is INT. I have already tried ‘${Platte}’, ${Platte} and $Platte. When I type in the number directly, it works regardless of with quotes or without quotes. Thank you for the response.

1 Like