AML Error
Can some help me on the formatting of this AML command.
Here is the SQL version that work:
SELECT Item_number,name FROM innovator.PART
WHERE ID IN
(SELECT AFFECTED_ID FROM innovator.AFFECTED_ITEM
w...
Forum Discussion
If anyone is interested, I figured it out.
<Item type ="Part"
action="get"
select = "item_number,name">
<id condition="in">
(SELECT AFFECTED_ID FROM innovator.AFFECTED_ITEM
where ID IN
(SELECT RELATED_ID FROM innovator.EXPRESS_ECO_AFFECTED_ITEM
where SOURCE_ID IN
(SELECT ID FROM innovator.EXPRESS_ECO
WHERE (id = '${Item/@id}'))))
</id>
</Item>
