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 - AML query to retrieve the Changes tab data.

オフライン Archive User 12 年以上前

tin - Thursday, March 13, 2014 11:15 PM:

Dear Team,

<Item type="Part" id="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" action="get" select ="item_number,name,remarks">

<Relationships>

<Item type="Part Changes" action="get" select="item_number,"title">

</Item>

</Relationships>

</Item>

But i unable to fetch the ECN0001 item_number for Part 'A'.

Tin.

zahar - Friday, March 14, 2014 11:22 AM:

The right AML to pull all processes your part is in not so simple. Actually Part Changes is relationship just for View purpose. Try someting like this:

<AML>

<Item type='Express ECO Affected Item' action="get" select="related_id(new_item_id(item_number),affected_id(item_number)), source_id(keyed_name)">

<related_id>

<Item type='Affected Item' action='get'>

<OR>

<new_item_id>

<Item action="get" type='Part'>

<item_number>PART PN</item_number>

</Item>

</new_item_id>

<affected_id>

<Item action="get" type='Part'>

<item_number>PART PN</item_number>

</Item>

</affected_id>

</OR>

</Item>

</related_id>

</Item>

</AML>