2 Replies Latest reply on Dec 27, 2012 12:58 PM by Bannikov

    AF Table Lookup DR - WHERE clause




      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




      What can I do?