I'm using the AVEVA interface to FoxBatch to pull in data from the FoxBatch Batch Execute System in Event Frames.
SELECT * FROM[Master].[EventFrame].[FindEventFrames](N' ElementName:"xxxx" End:>="20-may-2024 03:00" AllDescendants:True ')
Using the AFSDK interface in PI SQL Client, this will pull in all the top level Procedure template Event Frames and all their descendants (UnitProcedures, Operations, Phase, etc.) Depending the timeframe, this may pull in multiple top level batches.
Is there a method to query for all the descendants of a single Procedure?
If I use [FindEventFrames](N' ID:"<ID-of-the-Procedure-Event-Frame>" AllDescendants:True '), it returns just the Procedure, but none of the descendant sub-EFs.