This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Building reverse relationships query

CycleOp - Monday, May 17, 2010 2:34 AM:

Hi All,

I followed Bill's workbench document on creating reverse relationship views.

I tried to create a tab on the part where it would show 'Simple ECO' processes in which the part is a member of.

I did all the steps, and I get the Tab in place, but no actual data is returned. 

My guess is that Simple ECO ItemType is not the parent of parts, but rather connected to 'Effected Items' ItemType, and from there we can get to the parts being modified.

So I figured that my query string  (written in the grid I created ) is not right. Here what I have today:
<Item type="Simple ECO Affected Item" action="get" select="source_id(item_number)"> <related_id>{id}</related_id> </Item>

Can you help me modify the query to point from the Simple ECO to the actual part being modify ? Or maybe there's someplace else that needs tweaking ?
Thanks.
Sagi