Send email to task assignee by field event

Question

Hi, We have a customized task request application in Aras and I want to build a method to send assignee an email when the task has been assigned to the person. I want to add the method to a field event, onChange. So, when the assignee changes value, an email will be sent. See attached screenshots. And my code: Innovator inn = this.getInnovator(); string str_body = ""; // Get assignee string assignee = this.getProperty("dlv_assignedto",""); //Get Url string str_actionID = this.getProperty("id",""); string str_actionReq = "DLV_ActionReq"; string link = string.Format(@"

Click here to open the ticket

",str_actionReq, str_actionID, CCO.Request.Url.ToString().Substring(0,CCO.Request.Url.ToString().IndexOf("/Server/"))); // Get Mail Item email = inn.newItem("Email Message", "get"); email.setID("11A395B11B3A4337AE24F539266E815D"); email = email.apply(); email.setProperty("subject", string.Format("The following Action Request {0} has been assigned to you",this.getProperty("item_number",""))); str_body = string.Format(@"The following Action Request {0} has been assigned to you.
{1}
Best regards,
Engineering Capability Office",this.getProperty("item_number",""), link); email.setProperty("body_html", str_body); // Get Identity for assignee if ( assignee != "" ) { string str_reqby = this.getPropertyAttribute("dlv_assignedto", "keyed_name"); Item iden = this.newItem("Identity", "get"); iden.setProperty("name", str_reqby); iden = iden.apply(); if ( iden.getItemCount() == 1) { Boolean result = this.email(email, iden); } } return this; --------------------------------------------------- Any idea why it does not work? Have tried with server events, onAfterUpdate and it works. But not working with onAfterUnlock, it will solve my problem as well. Best Regards, Jimmi

Gopikrishnan · Accepted Answer

Hi Jimmi I have few suggestions for you. 1. Based on your method, it seems you are doing apply action for 5 times but it can be reduced to 3 server calls. lesser the server call, more the application performance. 2. It is good practice to use the user ID to get the identity than using the user's first name and last name. If first name and last name is modified this method won't work. 3. Since on after unlock event is triggered on every unlock, the mail will trigger two times (assuming DLV is versionable) when you edit an existing item. Example : I have one DLV item with generation 1. If I edit then it will change to generation 2. So, when I click Unlock, this will unlock generation 1 and generation 2. So method will trigger two time (one for old dlv assigned to another for new dlv assigned to). This wont be a problem if DLV is not versionable and always have one generation Based on above suggestions, Modified code is below Innovator inn = this.getInnovator(); string str_body = ""; // Get existing assignee string existingassignee = this.getProperty("dlv_assignedto",""); // Get assignee Item thisItem = inn.newItem(this.getType(), "get"); thisItem.setAttribute("select", "dlv_assignedto,item_number"); thisItem.setID(this.getID()); thisItem = thisItem.apply(); string assignee = thisItem.getProperty("dlv_assignedto",""); if(existingassignee == assignee) { return this; } //Get Url string str_actionID = thisItem.getProperty("item_number",""); string str_actionReq = "DLV_ActionReq"; string link = string.Format(@"

Click here to open the ticket

",str_actionReq, str_actionID, CCO.Request.Url.ToString().Substring(0,CCO.Request.Url.ToString().IndexOf("/Server/"))); // Get Mail Item email = inn.newItem("Email Message", "get"); email.setID("35DF32E58F02491B99B0450DA70AF85E"); //DLV_ActionReq_Assignment email = email.apply(); email.setProperty("subject", string.Format("The following Action Request {0} has been assigned to you",str_actionID)); str_body = string.Format(@"The following Action Request {0} has been assigned to you.
{1}
Best regards,
Engineering Capability Office",str_actionID, link); email.setProperty("body_html", str_body); // Get Identity for assignee if ( assignee != "" ) { Item userItem = inn.newItem("User", "get"); userItem.setAttribute("select", "id"); Item aliasItem = inn.newItem("Alias", "get"); aliasItem.setAttribute("select", "related_id"); Item identity = inn.newItem("Identity", "get"); aliasItem.setPropertyItem("related_id", identity); userItem.addRelationship(aliasItem); userItem.setID(assignee); userItem = userItem.apply(); if (userItem.isError()) { return userItem; } aliasItem = userItem.getRelationships("Alias"); Item iden = aliasItem.getItemByIndex(0).getRelatedItem(); if (iden.getItemCount() == 1) { Boolean result = this.email(email, iden); } } return this; Thank You Gopikrishnan R

Gopikrishnan · Answer

Hi Yanjim I would propose some other solution than the one on After Unlock event. Follow below steps 1. Create new JavaScript method (name : ARAS_Community_JS )and add below code Update Server Method Name below ARAS_Community_Server var dlvAssignedTo = document.thisItem.getProperty('dlv_assignedto'); if (dlvAssignedTo) { if (!top.aras.confirm('Do you want to send mail to DLV Assigned to User ?')) { return; } var callServerMethod = aras.IomInnovator.newItem('Method', ' ARAS_Community_Server '); callServerMethod.setProperty('dlv_assignedto', dlvAssignedTo); callServerMethod.setProperty('item_number', document.thisItem.getProperty('item_number')); var result = callServerMethod.apply(); if (result.isError()) { aras.AlertError(result.getErrorString()); } else { aras.AlertSuccess('Email sent successfully.'); } } 2. Update your existing server method with below code Innovator inn = this.getInnovator(); string str_body = ""; // Get assignee string assignee = this.getProperty("dlv_assignedto",""); //Get Url string str_actionID = this.getProperty("item_number",""); string str_actionReq = "DLV_ActionReq"; string link = string.Format(@"

Click here to open the ticket

",str_actionReq, str_actionID, CCO.Request.Url.ToString().Substring(0,CCO.Request.Url.ToString().IndexOf("/Server/"))); // Get Mail Item email = inn.newItem("Email Message", "get"); email.setID("35DF32E58F02491B99B0450DA70AF85E"); //DLV_ActionReq_Assignment email = email.apply(); email.setProperty("subject", string.Format("The following Action Request {0} has been assigned to you",str_actionID)); str_body = string.Format(@"The following Action Request {0} has been assigned to you.
{1}
Best regards,
Engineering Capability Office",str_actionID, link); email.setProperty("body_html", str_body); // Get Identity for assignee if ( assignee != "" ) { Item userItem = inn.newItem("User", "get"); userItem.setAttribute("select", "id"); Item aliasItem = inn.newItem("Alias", "get"); aliasItem.setAttribute("select", "related_id"); Item identity = inn.newItem("Identity", "get"); aliasItem.setPropertyItem("related_id", identity); userItem.addRelationship(aliasItem); userItem.setID(assignee); userItem = userItem.apply(); if (userItem.isError()) { return userItem; } aliasItem = userItem.getRelationships("Alias"); Item iden = aliasItem.getItemByIndex(0).getRelatedItem(); if (iden.getItemCount() == 1) { Boolean result = this.email(email, iden); } } return this; 3. Open form where this dlv_assignedto property exist 4. Add Form field event on dlv_assignedto property (Method Name : ARAS_Community_JS and event : On Change) 5. Save and Unlock Form 6. Try testing. Expected Result: Whenever the dlv_assigned_to field is changed, it will ask for confirmation from user whether to send email to user, if user select Ok, then it will send email else it will not send email

Gopikrishnan · Answer

Below method should work. My changes are highlighted below Innovator inn = this.getInnovator(); string str_body = ""; // Get assignee Item thisItem = inn.newItem(this.getType(), "get"); thisItem.setAttribute("select", "dlv_assignedto"); thisItem.setID(this.getID()); thisItem = thisItem.apply(); string assignee = thisItem .getProperty("dlv_assignedto",""); //Get Url string str_actionID = this.getProperty("id",""); string str_actionReq = "DLV_ActionReq"; string link = string.Format(@"

Click here to open the ticket

",str_actionReq, str_actionID, CCO.Request.Url.ToString().Substring(0,CCO.Request.Url.ToString().IndexOf("/Server/"))); // Get Mail Item email = inn.newItem("Email Message", "get"); email.setID("11A395B11B3A4337AE24F539266E815D"); email = email.apply(); email.setProperty("subject", string.Format("The following Action Request {0} has been assigned to you",this.getProperty("item_number",""))); str_body = string.Format(@"The following Action Request {0} has been assigned to you.
{1}
Best regards,
Engineering Capability Office",this.getProperty("item_number",""), link); email.setProperty("body_html", str_body); // Get Identity for assignee if ( assignee != "" ) { string str_reqby = thisItem .getPropertyAttribute("dlv_assignedto", "keyed_name"); Item iden = this.newItem("Identity", "get"); iden.setProperty("name", str_reqby); iden = iden.apply(); if ( iden.getItemCount() == 1) { Boolean result = this.email(email, iden); } } return this; Thank You Gopikrishnan R

Send email to task assignee by field event

Top Replies