Transferring relationship rows with a C# method

Question

Hi 
 
 I have a Request for quotation item type with an relationship to Parts. As well as a Purchase Order Item Type also with a relationship to Parts This allowing users to select the parts that the want on the RFQ and POR. I then created a method that transfers all the form fields from the RFQ to the POR. Now i would like it to include the relationship rows as well (meaning the part rows). So when you trigger the method from the RFQ it should fill in the POR form as well as the Parts relationship. 
 Does anyone perhaps have sample code on transferring relationship items to a new forms/item types relationship? 
 Thanks! 
 Wian

Gopikrishnan · Answer

Hi Wian le Roux You can add below code in your action C# method to copy the relationship from RFQ to POR This method will validate whether POR already has that relationship part or not and add if it does not exist. To Change in method : 1. Source ID is hard coded but you need to pass the POR ID which you might have got while copying the RFQ to POR form information. 2. Validate the relationship names (RFQ Parts and POR Parts - highlighted below) HashSet existingPORRel = new HashSet (); string sourceId = "DB2B0131FD70498BB456074471382EEA"; // POR ID to which the relationship to be copied Item PORRel = this.newItem(" POR Parts ", "get"); PORRel.setProperty("source_id", sourceId); PORRel.setAttribute("select", "related_id"); PORRel = PORRel.apply(); if (!PORRel.isError()) { for (int i = 0; i < PORRel.getItemCount(); i++) { existingPORRel.Add(PORRel.getItemByIndex(i).getProperty("related_id")); } } Item RFQfetchRel = this.fetchRelationships(" RFQ Parts "); Item RFQgetRel = RFQfetchRel.getRelationships(" RFQ Parts "); for (int j = 0; j < RFQgetRel.getItemCount(); j++) { Item RFQOneItem = RFQgetRel.getItemByIndex(j); string relatedId = RFQOneItem.getProperty("related_id"); if (!existingPORRel.Contains(relatedId)) { Item addPORItem = this.newItem(" POR Parts ", "add"); addPORItem.setProperty("source_id", sourceId); addPORItem.setProperty("related_id", relatedId); addPORItem = addPORItem.apply(); if (addPORItem.isError()) { return addPORItem; } } } return this; Thank You Gopikrishnan R