mhamel

Is there a query that would return all summary calculations in one call?

Discussion created by mhamel Employee on Dec 17, 2009
Latest reply on Dec 17, 2009 by spilon

I would like to know if the PI OLEDB provider exposes a query that would be translated into a PI SDK call involving: Data.Summaries2 (<StartTime>, <EndTime>, <Duration>, asAll, <Calculation Basis>)?

 

The goal is to retrieve different summary calculations for one or many tags in only one round-trip to ther server. With the actual query, it seems this can be done only with binding different PIAVG, PIMIN, PIMAX, etc. tables with a UNION keyword. This method involves many hundred or thousand calls to perform the same operation.

Outcomes