AnsweredAssumed Answered

How to use PI OLEDB Enterprise View to determine the change in tag value between a Start Time and End Time

Question asked by stevensnashall on Dec 12, 2019

A downstream java based application needs to use PI JDBC via a PI SQL DAS middleware deployment to query AF Attributes to determine:

  1. Current Value of a set of PI AF Attributes
  2. "Delta" or change in PI AF Attribute tag value between a given Start Time and End Time

 

Both of these queries need to be able to parse the query time (Start and End Time for query 2 above) as they will be dynamic.

 

Questions:

  1. Is it possible to have parameters in an OLEDB Enterprise View?
  2. Do you have any tips / examples of using Stored Procedures via a Linked SQL Server with PI SQL DAS?

 

Appreciate any help anyone can provide.

Outcomes