AnsweredAssumed Answered

How do you search by digitalset status with GetPointsSQL?

Question asked by Jeevan on Dec 10, 2015
Latest reply on Dec 11, 2015 by Marcos Vainer Loeff

Hi,

 

Apologies if this is a noob question.

 

I'm trying to use the GetPointsSQL method to search by pointsource and the current value of the tags. All the tags belonging to the pointsource have get values in a digitalset. I've tried the following but they all result in an 'Invalid where clause' error.

 

GetPointsSQL("pointsource='myps' AND Status='valueOfDigitalSet' ")

GetPointsSQL("pointsource='myps' AND status='valueOfDigitalSet' ")

GetPointsSQL("pointsource='myps' AND Tag.Status='valueOfDigitalSet' ")

GetPointsSQL("pointsource='myps' AND PIpoint.Status='valueOfDigitalSet' ")

GetPointsSQL("pointsource='myps' AND PIcomp.Status='valueOfDigitalSet' ")

 

 

As an aside, when you use the 'Advanced Search' tab (in SMT Tag Search), you can see the SQL where clause which you can copy into your code. Is there a way to do the same with the 'Basic Search' tab?

Outcomes