1 of 1 people found this helpful
Understanding that within your event frame, your data is usually presented as desired, you can simply access it via the Data.EventFrameSnapshot table. here is a gross example:
SELECT efa.Name, efs.Value
FROM [YourAFDatabase].EventFrame.EventFrameTemplate eft
INNER JOIN [YourAFDatabase].EventFrame.EventFrameHierarchy efh ON efh.EventFrameTemplateID =eft.id
INNER JOIN [YourAFDatabase].EventFrame.EventFrameReferencedElement efre ON efre.EventFrameID = efh.ID
INNER JOIN [YourAFDatabase].EventFrame.EventFrameAttribute efa ON efa.EventFrameID = efh.ID
INNER JOIN [YourAFDatabase].Data.EventFrameSnapshot efs ON efs.EventFrameAttributeID = efa.ID
WHERE efa.Name='Recipe Name Attribute' or efa.Name='Product Name Attribute'
Did Alexandre comment helped you?
As an alternative, if your event frame creation is based on a template ( recommended) , you may want to create a transpose function that will expose all the Event Frame template attribute as collumns. And this will avoid having to create all those joins.
You may look into the documentation to see how transpose function works, manual is available here: