AnsweredAssumed Answered

Event Frame SQL Query with Child Event Frames

Question asked by afontenot on Jan 29, 2019
Latest reply on Jan 31, 2019 by afontenot

I'm attempting to create a sql query in SQL Commander Lite to return Event Frames along with snapshot attribute values and all of the associated child event frames and attribute values similar to how EventFrame Compare works in PI DataLink. I'm able to create the Dynamic Transpose Functions for the Parent and Child Event Frame Templates and have been able to join the subqueries using the EventFrame.EventFrameReference Table which contains the ParentID ChildID relationships. I'm curious if this is the preferred method for returning such a data set or if there is a better method?

 

Thanks in advance,

Andrew

Outcomes