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

Hi,

 

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.

Outcomes