formerpigeek

PI SDK GetPointsSQL

Discussion created by formerpigeek on Jan 19, 2011
Latest reply on Jan 20, 2011 by andreas

Hi,

 

We are using GetPointsSQL method to get the list of points matching our where clause, something like "tag in ('A','B','C')". This query is working fine when the number of tagnames in the where clause is less, but when the list grows big I am getting an exception saying "invalid where clause".

 

Is there a limitation on the number of characters for the where clause string or on the number of tagnames that can be passed for the where clause?

 

Thanks & Regards

 

Kavita

Outcomes