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

See i did not know what about if your related list contains multiple records, If it contains single record



The BR should be,


insert/update


condition: current.cmdb_ci_service.managed_by.changes()


script:


var gr = new GlideRecord('incident');


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


gr.query();


if(gr.next()){


gr.<custom_field>=current.cmdb_ci_service.managed_by;


gr.update();


}


Abinash
Kilo Contributor

the BR should be written on cmdb_ci_service table ryt???


and one more qn using BR shall it populate the value in the form??


The BR should be on "task_cmdb_ci_service" table.


Abinash
Kilo Contributor

okk i will try that. and will this value populate in the client form..because i think in BR we only store the value in database. so will it show in the form??


If you change in the field in the related list it will update in incident form, just try the above one