I Create a query to be alerted
and format us set table and no data show up
only show error 「Failed to evaluate queries and expressions: failed to execute conditions: input data must be a wide series but got type not (input refid)」
here is my query
SELECT statusId as "ID" ,
substring(stateValue,1,1) AS 'STATUS'
FROM numberofState
WHERE substring(stateValue,1,1) = 'ERROR';
Is any way can fix it?