AnsweredAssumed Answered

Table Lookup Using Element in Event Frame

Question asked by JeremyGeorge on Aug 21, 2017
Latest reply on Aug 23, 2017 by kfong

I am trying to use a table lookup to find the data using the SiteName and UnitName of parent elements where the event frame is ran.  I cannot seem to get my query right, however, when trying to filter the table using the elements.

 

Here is my structure:

 

Region

|..Site(SiteAbbr here)

   |..Unit(UnitAbbr here)

      |..Testing(Event frame triggers here)

 

My table is straight forward:

 

'GenInfo'

MW | SiteName | UnitName | etc...

 

Here is my query:

SELECT NetGen FROM GenInfo WHERE SiteName = @[..\..\|SiteAbbr] AND UnitAbbr = @[..\|UnitAbbr];RWN=No Data

 

I assume that I am referencing the elements wrong, especially since they are in the event fram and not another child element.

Outcomes