Grafana dashboard: Db query error: sql: expected 30 arguments, got 0

92 Views Asked by At

I have a constant variable Shift1_StartTime whose value is '7:30:00' and I have a SQL query

WITH DataLogKWH AS (
    SELECT
        SourceID,
        TimestampUTC,
        Value - LAG(value, 1, 0) OVER (PARTITION BY SourceID ORDER BY TimestampUTC) AS actual_value
    FROM [ION_Data].[dbo].[vDataLogKWH]
)
SELECT SUM(actual_value)
FROM DataLogKWH
WHERE SourceID IN (${Compressors})
AND TimestampUTC >= CAST(CAST(DATEADD(DAY, -1, GETDATE()) AS DATE) AS DATETIME) + CAST(${Shift1_StartTime} AS TIME)

Here is my variable

enter image description here

and here is my SQL query in Grafana screenshot

enter image description here

however I try use Shift1_StartTime variable in this query, this gives me an error:

Db query error: sql: expected 30 arguments, got 0

Need help please. Thanks .

0

There are 0 best solutions below