AnsweredAssumed Answered

PI-ODBC SQL query using piavg does not return tag status

Question asked by nbonillo on Mar 14, 2017
Latest reply on Mar 15, 2017 by nbonillo

I'm running a SQL query using piavg as the example of the ODBC PI manual, but it does not return the status of the tag:

SELECT status, value, pctgood
FROM piavg
WHERE tag = 'sinusoid'
AND time> = DATE ('*-8h')
AND time <= DATE ('*')
AND timestep = RELDATE ('1h')

If I execute the query without specifying status in the SQL statement, the SQL query is executed correctly, otherwise the SQL query is not executed...

 

I really appreciate your help,

Regards,

 

Nelson Bonillo

Outcomes