- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 05:09 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2017 05:25 AM
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);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2017 11:39 PM
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??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2017 05:25 AM
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);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2017 11:42 AM
Thanx Niklas it worked out perfectly....