Can someone please tell me when I'm getting this error: "The given key was not present in the dictionary."
<AML>
<Item type="MIN_RMA" action="get" select="rma_no">
<Relationships>
<Item type="MIN_RMA_PARTS" action="get" select="related_id">
<item_number>
<Item type="MIN_DELIVERED_COMPONENT" action="get" select="item_number"><id>@Parameter</id></Item>
</item_number>
</Item>
</Relationships>
</Item>
</AML>
It's not a typical source_id/related_id relationship. I'm trying to combine the following AML, If I run them separately they work, but when I try to combine them is when I get the error.
// (code1) get id from min_delivered_component
<AML>
<Item type="MIN_DELIVERED_COMPONENT" action="get" select="item_number">
<id>@Parameter</id>
</Item>
</AML>
// (code2) get rma_no from the relationship of min_rma_parts and min_rma
<AML>
<Item type="MIN_RMA" action="get" select="rma_no">
<Relationships>
<Item type="MIN_RMA_PARTS" action="get" select="related_id">
<item_number>@Parameter</item_number>
</Item>
</Relationships>
</Item>
</AML>
// combine AML from (code1) and (code2)
<AML>
<Item type=”MIN_RMA” action=”get” select=”rma_no”>
<Relationships>
<Item type=”MIN_RMA_PARTS” action=”get” select=”related_id”>
<item_number>
<Item type=”MIN_DELIVERED_COMPONENT” action=”get” select=”item_number”><id>@Parameter</id></Item>
</item_number>
</Item>
</Relationships>
</Item>
</AML>
Hi,
Does this query returns item which matches this condition <item_number>@Parameter</item_number> alone ?? I was trying to test it in OOTB, and <item_number>@Parameter</item_number> doesn't have any impact and it return all item of MIN_RMA.
// (code2) get rma_no from the relationship of min_rma_parts and min_rma
<AML>
<Item type=”MIN_RMA” action=”get” select=”rma_no”>
<Relationships>
<Item type=”MIN_RMA_PARTS” action=”get” select=”related_id”>
<item_number>@Parameter</item_number>
</Item>
</Relationships>
</Item>
</AML>
Could you please help with some more inputs on what you are trying to achieve in this AML.
Hi,
Is MIN_RMA_PARTS is related to MIN_DELIVERED_COMPONENT ? I was trying to fetch all the Part which has the Manufacturer Part '222' using below query and I'm able to get all the parts. Could you please help with how MIN_RMA_PARTS , MIN_DELIVERED_COMPONENT and MIN_RMA are related..
<AML>
<Item action='get' type='Part' select='item_number'>
<Relationships>
<Item action='get' type='Part AML' select='related_id'>
<related_id>
<Item type='Manufacturer Part' action='get' select='item_number'>
<item_number condition="eq">222</item_number>
</Item>
</related_id>
</Item>
</Relationships>
</Item>
</AML>
I have a @parameter that is passing the MIN_DELIVERED_COMPONENT.id, then this needs to happen:
MIN_DELIVERED_COMPONENT.item_number = to MIN_RMA_Parts.item_number and
MIN_RMA_Parts.source_id = related to MIN_RMA.id
.. which gives me the MIN_RMA.rma_no