How to get populate "incident" creation date on "incident_task" one date/time field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-27-2019 08:01 AM
HI all,
I am getting struck with populating "incident" cretion date/time in to another table "incident_task"
for this i have written after BR .Please find the below script
@I have checked that gs.log('incident creation date:' +current.sys_created_on); in this log current.sys_created_on is not comming on logs
(function executeRule(current, previous /*null when async*/) {
current.sys_created_on = current.u_original_date;
gs.log('incident creation date:' +current.sys_created_on);
var inc_dte = new GlideRecord('incident_task');
inc_dte.addQuery('incident',current.sys_id);
inc_dte.query();
gs.log('incident records match:' +current.sys_id);
if(inc_dte.next()){
current.u_original_date = inc_dte.u_original_date;
gs.log('incident original date:' +inc_dte.u_original_date);
inc_dte.update();
}
})(current, previous);
Can anyone help on this

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-27-2019 08:10 AM
Please make sure that your BR is AFTER and NOT before.
Regards,
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-27-2019 08:14 AM
Please share your BR settings. On my developer instance your script was working.
Table: incident
Insert: True
Update:true(this won't be necessary)
When: After
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-27-2019 08:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-27-2019 08:19 AM