Hello, APerson
With GetPoints method, you can do simple queries. With GetPointsSQL query can by more complex. But, if python can not work with GetPointsSQL method, you can not use it.
With GetPoints you can build query, like
(x AND y) OR (z AND t AND p) OR ... etc.
You can write query, like:
Code:PointList points = _piServer.GetPoints("changedate > '21-Dec-2011 15:52:30' AND tag = 'b*'");
Maybe, it will enough for Your needs, i don't know...
Differences (from pisdk.chm ver1.3.6):
GetPoints vs. GetPointsSQL
GetPointsSQL can implement complex queries, including joins with other PI tables. GetPoints cannot do such complex queries, but it is faster, and can use custom point attributes, which GetPointsSQL cannot. To convert between equivalent GetPoints and GetPointsSQL queries, note that GetPointsSQL uses attribute names as defined by PI ODBC, but GetPoints uses attribute names as defined internally in the PI Point Database. These names differ in some instances.
If no points are found by this method it returns an empty PointList collection. The Server.GetPointsSQL returns an error of pseNoPointsFound in this case.
Tell, if you can use GetPoints
Good luck
Kind Regards,
Efim
