- 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-18-2017 05:14 AM
You want to populate the managed by field with custom field on incident form?
if so in the dictionary override of managed by of impacted services, put the default value as javascript:parent.<custom_field>
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 06:38 AM
Hi Balaji,
In the override table which table has to be mentioned??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 06:39 AM
Tell me one thing,
you need based on related list values changes incident custom fields need to populate or other scenario??????
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 06:55 AM
I will explain you clearly. Like we have a custom field in INC form that needs to store the value of "managed by" field present in the related list "impacted services". and now if i remove the user from managed by then automatically the custom field should also get blank