sergey.kukushkin

SQL-query of Event Frames with all attributes.

Discussion created by sergey.kukushkin on Aug 15, 2013
Latest reply on Sep 3, 2013 by sergey.kukushkin

Dear All,

 

Is there any example of SQL-query of how to select Event Frames with all attributes?

 

For example I can select just Event Frames with using such a query

 

SELECT TOP 100 *

 

FROM [Database1].[EventFrame].[EventFrame] ef

 

JOIN [Database1].[Asset].[ElementHierarchy] eh ON ef.PrimaryReferencedElementID=eh.ElementID

 

ORDER BY StartTime DESC

 

OPTION (FORCE ORDER, EMBED ERRORS)

 

 But I don’t understand how to attach attributes to my Event Frames within one recordset.

 

There should be 9 attributes for each EF…

 

Thank you in advance!

Outcomes