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:
|..Testing(Event frame triggers here)
My table is straight forward:
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.