How do I "edit"/"update" a Relationship instance using js or AML.

Question

All,
I am trying to "edit"/"update" the properties on a Non-Related Relationship; "rh_OraMfgMaster_ProdNumNomen".
I must be missing something.

I tried the following AML from AML Studio:
&lt;AML&gt;&nbsp;&nbsp; &nbsp;&lt;Item type="rh_Oracle_Manuf_Master_Item" action="edit" id="C323F3AB54D84E70B54D895158EE3CB7"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&lt;Relationships&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;Item type="rh_OraMfgMaster_ProdNumNomen" action="edit"&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; where="[rh_OraMfgMaster_ProdNumNomen].source_id = 'C323F3AB54D84E70B54D895158EE3CB7'"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;RH_PRODUCT_CATEGORY_CODE&gt;Z&lt;/RH_PRODUCT_CATEGORY_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;RH_TRADE_BRAND_CODE&gt;F&lt;/RH_TRADE_BRAND_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Relationships&gt;&nbsp; &lt;/Item&gt;&lt;/AML&gt;

&lt;AML&gt;&nbsp;&nbsp; &nbsp;&lt;Item type="rh_Oracle_Manuf_Master_Item" action="edit" id="C323F3AB54D84E70B54D895158EE3CB7"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&lt;Relationships&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;Item type="rh_OraMfgMaster_ProdNumNomen" action="edit" id="3A40258510F24D1685B044270F4B296A"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &lt;RH_PRODUCT_CATEGORY_CODE&gt;Z&lt;/RH_PRODUCT_CATEGORY_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;RH_TRADE_BRAND_CODE&gt;F&lt;/RH_TRADE_BRAND_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Relationships&gt;&nbsp; &lt;/Item&gt;&lt;/AML&gt;

This does not work.
I tried [Item type="rh_OraMfgMaster_ProdNumNomen" action="update"] and that did not work.
I can delete the existing Relationship using:
&lt;AML&gt;&nbsp;&nbsp; &nbsp;&lt;Item type="rh_Oracle_Manuf_Master_Item" action="edit" id="C323F3AB54D84E70B54D895158EE3CB7"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&lt;Relationships&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;Item type="rh_OraMfgMaster_ProdNumNomen" action="delete" id="A9BB4FEB593F4D09A5427B108937B216"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Relationships&gt;&nbsp; &lt;/Item&gt;&lt;/AML&gt;
And then Add a new Relationship instance (with 'hasProdNomen ' = "NO") with the updated data.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; let hasProdNomen = HasProductNomenclature(parentId);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; let arasAction = "edit";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(hasProdNomen === "NO"){ arasAction = "add";}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //let oracleMasterItem = inn.getItemById("rh_Oracle_Manuf_Master_Item",parentId);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; let prodNumNomen = inn.newItem("rh_OraMfgMaster_ProdNumNomen", arasAction);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(hasProdNomen === "YES"){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomen.setAttribute("Where", "[rh_OraMfgMaster_ProdNumNomen].source_id = " + parentId);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomen.setProperty(itemProductNumberPropName, prodNumItemNumber);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomen.setProperty(tradeBrandPropName, tradeBrand);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomen.setProperty(tradeBrandCodePropName, tradeBrandCode);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomen.setProperty(productCategoryPropName, prodCategory);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomen.setProperty(productCategoryCodePropName, prodCatCode);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomen.setProperty(numberOfPositionsPropName, numberOfPositions);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //let prodNumNomenCnt = prodNumNomen.getItemCount();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //debugger;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; let cnt = -1;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; let prodNumNomenCheck = null;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(hasProdNomen === "NO"){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //debugger; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item.addRelationship(prodNumNomen);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; item.apply();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } else if(hasProdNomen === "YES"){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prodNumNomenCheck = prodNumNomen.apply();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt = prodNumNomenCheck.getItemCount();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }

But I would rather update the properties on the Relationship item.
Thanks for the help.
Scott

alaxala · Answer

Is there any error in the result?&nbsp;At least second AML should work, although the source item edit is&nbsp;unnecessary. If you know the relationship id the
&lt;Item type="rh_OraMfgMaster_ProdNumNomen" action="edit" id="3A40258510F24D1685B044270F4B296A"&gt;&nbsp; &nbsp;&lt;RH_PRODUCT_CATEGORY_CODE&gt;Z&lt;/RH_PRODUCT_CATEGORY_CODE&gt;&nbsp; &nbsp;&lt;RH_TRADE_BRAND_CODE&gt;F&lt;/RH_TRADE_BRAND_CODE&gt;&lt;/Item&gt;
should be enough.

srmorrison · Answer

alaxala,
Thanks for responding.
That's what is confusing, there are no errors thrown.
No system feedback at all.
Scott

srmorrison · Answer

alaxala,
Sorry ... I closed the reply before I completed the comment.
Using the following AML:
&lt;AML&gt;&nbsp;&nbsp; &nbsp;&lt;Item type="rh_Oracle_Manuf_Master_Item" action="edit" id="C323F3AB54D84E70B54D895158EE3CB7"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&lt;Relationships&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;Item type="rh_OraMfgMaster_ProdNumNomen" action="edit"&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; where="[rh_OraMfgMaster_ProdNumNomen].source_id = 'C323F3AB54D84E70B54D895158EE3CB7'"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;RH_PRODUCT_CATEGORY_CODE&gt;K&lt;/RH_PRODUCT_CATEGORY_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;RH_TRADE_BRAND_CODE&gt;T&lt;/RH_TRADE_BRAND_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Relationships&gt;&nbsp; &lt;/Item&gt;&lt;/AML&gt;

When I look at the AML server response I get ....
&lt;SOAP-ENV:Envelope xmlns:SOAP-ENV=""&gt;schemas.xmlsoap.org/.../"&gt;&nbsp; &lt;SOAP-ENV:Body&gt;&nbsp;&nbsp;&nbsp; &lt;Result&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Item type="rh_Oracle_Manuf_Master_Item" typeId="8C4C0C666B564C928824E229F4476D1E" id="C323F3AB54D84E70B54D895158EE3CB7"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;classification&gt;Finished good&lt;/classification&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;config_id keyed_name="18287161" type="rh_Oracle_Manuf_Master_Item"&gt;C323F3AB54D84E70B54D895158EE3CB7&lt;/config_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;created_by_id keyed_name="Manufacturing Batch Loader" type="User"&gt;7F42F026A2BC4EE99066DD094F3610D5&lt;/created_by_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;created_on&gt;2023-09-10T22:06:01&lt;/created_on&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_mfg_weight_code&gt;LB&lt;/rh_mfg_weight_code&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_plm_cre_by_div&gt;AC&lt;/rh_plm_cre_by_div&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_plm_description&gt;SMALL - 26 TUBE - 1.5 TON&lt;/rh_plm_description&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_plm_has_change_pending&gt;0&lt;/rh_plm_has_change_pending&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_plm_major_rev&gt;00&lt;/rh_plm_major_rev&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_plm_make_buy&gt;Make&lt;/rh_plm_make_buy&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_plm_part keyed_name="RA14AZ18AJ1NA" type="Part"&gt;BB42DF0F494D415288532C2323D388B0&lt;/rh_plm_part&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_plm_plm_created_by_div&gt;AC&lt;/rh_plm_plm_created_by_div&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rh_oracle_item_id&gt;18287161&lt;/rh_oracle_item_id&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp;&nbsp; &lt;/Result&gt;&nbsp;&nbsp;&nbsp; &lt;Message&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;event name="ids_modified" value="C323F3AB54D84E70B54D895158EE3CB7|3A40258510F24D1685B044270F4B296A" /&gt;&nbsp;&nbsp;&nbsp; &lt;/Message&gt;&nbsp; &lt;/SOAP-ENV:Body&gt;&lt;/SOAP-ENV:Envelope&gt;

If I look at the SQL Server Table the only thing that has changed is the [modified_on] property.
&nbsp;
I also tried using the ID of the relationship:
&lt;AML&gt;&nbsp;&nbsp; &nbsp;&lt;Item type="rh_Oracle_Manuf_Master_Item" action="edit" id="C323F3AB54D84E70B54D895158EE3CB7"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&lt;Relationships&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;Item type="rh_OraMfgMaster_ProdNumNomen" action="edit" id="3A40258510F24D1685B044270F4B296A"&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;RH_PRODUCT_CATEGORY_CODE&gt;K&lt;/RH_PRODUCT_CATEGORY_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;RH_TRADE_BRAND_CODE&gt;T&lt;/RH_TRADE_BRAND_CODE&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Item&gt;&nbsp;&nbsp; &nbsp;&nbsp; &lt;/Relationships&gt;&nbsp; &lt;/Item&gt;&lt;/AML&gt;
Same result.

alaxala · Answer

The property names in the AML are case sensitive. So you&nbsp;must specify them exactly as they are defined in the Aras itemType, not in the SQL table.

srmorrison · Answer

alaxala,
Wow I can't believe I missed that.
Good catch. Its the simple stuff that ....s me.
Thank you
Scott

Forum Discussion

How do I "edit"/"update" a Relationship instance using js or AML.

5 Replies

Recent Discussions

Tech Docs - 'Zoom'

How to populate 'this' properties?

What causes the command bar buttons 'Save' and 'Done' to be greyed out?

Searching against a multi value list data type

Notify User When a Relationship is Added when the Source ItemType and Related ItemType have matching properties