Related list field populated on a form field

Abinash
Kilo Contributor

I have this impacted services related list in my incident form.

I want the "managed by" field which is a reference field of user table to be populated to a custom field in my INC form. Kindly help me to

achieve this. Developer Community bawiskar

Thanks in advance

find_real_file.png

1 ACCEPTED SOLUTION

Not sure how you are going to pull that off but here is code for adding users to a list field that relates to the sys_user table. Adding or removing an Affected CI in the related list will trigger an update of the List field and add assigned to from all the related CI's to the u_service_owner field.



List field on Incident table called u_service_owner referencing sys_user table.


Business rule on task_ci table. Runs after on Insert, Update and Delete.



Script:


(function executeRule(current, previous /*null when async*/) {



  // Add your code here


  var inc = new GlideRecord('incident');


  inc.addQuery('sys_id',current.task);



  inc.query();


  if(inc.next()){


  inc.u_service_owner=''; //Clear service owner list



  var ci = new GlideRecord('task_ci');


  ci.addQuery('task',current.task);


  ci.query();


  while (ci.next()){


  inc.u_service_owner   += ',' + ci.ci_item.assigned_to;   //Add CI assigned to



  }



  inc.update();


  }


 


})(current, previous);


View solution in original post

27 REPLIES 27

It is to be used for sla breach condition and approvals thats why we need to push the owner of the ci's into that field.. can u plz guide me with the script lyk how to achieve that??


Not sure how you are going to pull that off but here is code for adding users to a list field that relates to the sys_user table. Adding or removing an Affected CI in the related list will trigger an update of the List field and add assigned to from all the related CI's to the u_service_owner field.



List field on Incident table called u_service_owner referencing sys_user table.


Business rule on task_ci table. Runs after on Insert, Update and Delete.



Script:


(function executeRule(current, previous /*null when async*/) {



  // Add your code here


  var inc = new GlideRecord('incident');


  inc.addQuery('sys_id',current.task);



  inc.query();


  if(inc.next()){


  inc.u_service_owner=''; //Clear service owner list



  var ci = new GlideRecord('task_ci');


  ci.addQuery('task',current.task);


  ci.query();


  while (ci.next()){


  inc.u_service_owner   += ',' + ci.ci_item.assigned_to;   //Add CI assigned to



  }



  inc.update();


  }


 


})(current, previous);


Thanx Niklas it worked out perfectly....