AnsweredAssumed Answered

PI OLEDB Provider - Query past 32 days of flows for hundreds of meters

Question asked by Halenger Champion on Mar 18, 2015
Latest reply on Apr 9, 2015 by aseck

I have over a hundred flow meters I'd like to see total daily consumption for the past 32 days or so listed.  Using PI OLEDB Provider, how would I query this list of flow meters (tag names end typically *DomWtrFlow) and the description in the next column and then have 32 columns giving the total daily flow for past 32 days (plus current day if possible) for the meter?  To make it more exciting, of the 32 columns have the respective date as the header....  Not sure if this query would have to be a CTE?  Much help would be appreciated!

Outcomes