- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 12:47 AM
Can anyone help me @Vasantharajan N @Ankur Bawiskar
As I need to display change request number in ritm description filed once change request is created
Tried with Business Rule and the condition is when the change state is in New.
But not able to get the Change Request number.
Business Rule:
var chnGr_sysId = current.change_request.toString();
var riTs = new GlideRecord('sc_req_item');
riTs.addQuery('parent', chnGr_sysId);
riTs.addActiveQuery();
riTs.query();
if (riTs.next()) {
riTs.description = current.number.toString();
chGr.update();
}
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 03:41 AM
@Arjun Reddy Yer - Please try this code and let us know.
var chnGr_sysId = current.sys_id.toString();
var riTs = new GlideRecord('sc_req_item');
riTs.addQuery('parent', chnGr_sysId);
riTs.addActiveQuery();
riTs.query();
if (riTs.next()) {
riTs.description = current.number.toString();
riTs.setWorkflow(false);
riTs.update();
}
Thanks & Regards,
Vasanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 12:59 AM
Dear @Arjun Reddy Yer
Please try using the below code
var riTs = new GlideRecord('sc_req_item');
riTs.addQuery('parent', current.sys_id);
riTs.addActiveQuery();
riTs.query();
if (riTs.next()) {
riTs.description = current.number;
riTs.update();
}
- Kailas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 01:00 AM
Hi @Arjun Reddy Yer ,
Try writing insert BR without any condition on "change_request" table and update your code as below:
var chnGr_sysId = current.sys_id;
var riTs = new GlideRecord('sc_req_item');
riTs.addQuery('parent', chnGr_sysId);
riTs.addActiveQuery();
riTs.query();
if (riTs.next()) {
riTs.description = current.number.toString();
riTs.update();
}
Please Mark it as correct/helpful if this helps you.
Thanks,
Akshay
