I have an email notification that Innovator sends when the change notice has been approved. It currently only has the CN number, engineer's name, business unit, etc. but does not have the affected items with their part dispositions. I need to add this information to the email notification. My message uses Body Html and a AML query string. How do I modify these to include all of the affected items table information?
I am able to get data from the CN such as the id, cn_number, businessunit, top_assy_pn, etc.
What I need is how to script to get the related source_id of the Affected Items. Is it something like this?
</Item>
<Item type="a_CN_Affected_Item" action="get" where=[a_CN_Affected_Item].<source_id>{id}</source_id> select="affected_name">
</Item>
I am able to get data from the CN such as the id, cn_number, businessunit, top_assy_pn, etc.
What I need is how to script to get the related source_id of the Affected Items. Is it something like this?
</Item>
<Item type="a_CN_Affected_Item" action="get" where=[a_CN_Affected_Item].<source_id>{id}</source_id> select="affected_name">
</Item>
