Copy Reference field value from RITM to ScTasks

[Ben42]

Hello Guys,

For all existing catalog tasks, I want to copy "request_item.requested_for" field on RITM to "user" (custom) field on ScTasks. How can I achieve this? and How does the script look like?

We have few hundreds of catalog tasks, So, I wanted to do a bulk update using script.

Any help is appreciated.

Thanks,

Ben.

[Mohith Devatte]

BEN,

CAN YOU POST YOUR SCRIPT HERE PLEASE ? LETS DEBUG

[Ben42]

Mohith,

I used the script you provided.

var sc = new GlideRecord('sc_task');
sc.addQuery('u_end_user','!=','');
sc.query();
while(sc.next())
{
sc.u_end_user =sc.request_item.request.requested_for;
sc.update();
}

Thanks,

Ben.

[Mohith Devatte]

is the RITM being stored on request item field ?for all the tasks?

also try putting logs and check 

var sc = new GlideRecord('sc_task');
sc.addQuery('u_end_user','!=','');
sc.query();
while(sc.next())
{

gs.info('found the tasks'+sc.request_item.request.requested_for);
sc.u_end_user =sc.request_item.request.requested_for.toString();
sc.update();
}

Can you try with this script

[Ben42]

Yes, we use request_item.requested_for on ScTasks.

Thanks,

Ben.

[Mohith Devatte]

var sc = new GlideRecord('sc_task');
sc.addQuery('u_end_user','!=','');
sc.query();
while(sc.next())
{

gs.info('found the tasks'+sc.request_item.request.requested_for);
sc.u_end_user =sc.request_item.request.requested_for.toString();
sc.update();
}

 can you try this  and check for logs if its going inside the loop