Bannikov

AF Table Lookup DR - WHERE clause

Discussion created by Bannikov on Dec 26, 2012
Latest reply on Dec 27, 2012 by Bannikov

Hello!

 

I've tried implement new AF Table Lookup and have some difficultes. I need use attribute value from parent element (please see picture). I haven't a clue how to implement this in WHERE clause. For attributes in my element WHERE should look like this:

 

WHERE [PowerPlaneNumber] = @[PowerPlaneNumber] AND [TurbineNumber] = @[TurbineNumber]

 

I suggest that for attribute from parent element this should look like:

 

WHERE [PowerPlaneNumber] = @[..\|PowerPlaneNumber] AND [TurbineNumber] = @[TurbineNumber]

 

But this doesn't work

 

1212.Table-Lookup.png

 

What can I do?

 

 

 

 

Outcomes