- 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 07:27 AM
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();
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 07:31 AM
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??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 07:33 AM
The BR should be on "task_cmdb_ci_service" table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 07:38 AM
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??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 07:41 AM
If you change in the field in the related list it will update in incident form, just try the above one