AnsweredAssumed Answered

PI ODBC For 'PI Integrator For Business Analytics' - DateTime Filter

Question asked by Bhikadiya Champion on Aug 17, 2016
Latest reply on Aug 17, 2016 by Bhikadiya



We have configured DSN using driver - 'PI Integrator For Business Analytics'. It successfully connects to Server. No Issues.


Now, I am trying to configure the SQL statement against published views - 'PI Views'. The requirement is to filter records by TimeStamp range. like Where TimeStamp betweeen '*-30h' AND '*'. Any thoughts ?


Without Filter:


With TimeStamp Filter (Error):

Any suggestions will kindly appreciated. Thanks.