5 Replies Latest reply on Mar 15, 2017 6:50 PM by nbonillo

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

    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