question Re: Background script to update new field on Task with task related requested item field dont work in Developer forum

Background script to update new field on Task with task related requested item field dont work

Siddharth Parna — Thu, 08 May 2025 04:16:15 GMT

var taskgr = new GlideRecord('sc_task');

//taskgr.addQuery('assignment_group', 'Group id ');

taskgr.setLimit(5);

taskgr.query;

while (taskgr.next()) {

if(taskgr.request_item){

gs.info('Task Number:' + taskgr.number);

var reqItem = new GlideRecord('sc_req_item');

if (reqItem.get(taskgr.request_item)) {

var shortDesc = reqItem.variables.short_description;

if (shortDesc) {

taskgr.u_short_description = shortDesc.toString();

taskgr.update();

gs.info('Updated Task' + taskgr.number);

} else {

gs.info('No Short Description:' + taskgr.number);

}

Re: Background script to update new field on Task with task related requested item field dont work

Nilesh Pol — Thu, 08 May 2025 04:22:04 GMT

@Siddharth Parna

verify the updated script:

var taskgr = new GlideRecord('sc_task');
taskgr.setLimit(5);
taskgr.query(); // <-- Fix here

while (taskgr.next()) {
if (taskgr.request_item) {
gs.info('Task Number: ' + taskgr.number);

var reqItem = new GlideRecord('sc_req_item');
if (reqItem.get(taskgr.request_item.toString())) { // <-- Add .toString()

var shortDesc = reqItem.variables.short_description;
if (shortDesc) {
taskgr.u_short_description = shortDesc.toString();
taskgr.update();
gs.info('Updated Task: ' + taskgr.number);
} else {
gs.info('No Short Description for Task: ' + taskgr.number);
}

} else {
gs.info('Requested item not found for Task: ' + taskgr.number);
}
}
}

Re: Background script to update new field on Task with task related requested item field dont work

mohdarbaz — Thu, 08 May 2025 04:24:18 GMT

@Siddharth Parna

The query method should be called with parentheses to execute the query.
Ensure that the request_item field is correctly referenced and exists in the sc_task table.
Ensure that the short_description variable exists in the sc_req_item table.

try this corrected script:

var taskgr = new GlideRecord('sc_task');

// Uncomment and set the appropriate group ID if needed
// taskgr.addQuery('assignment_group', 'Group id');

taskgr.setLimit(5);
taskgr.query();

while (taskgr.next()) {
if (taskgr.request_item) {
gs.info('Task Number: ' + taskgr.number);

var reqItem = new GlideRecord('sc_req_item');
if (reqItem.get(taskgr.request_item)) {
var shortDesc = reqItem.variables.short_description;

if (shortDesc) {
taskgr.u_short_description = shortDesc.toString();
taskgr.update();
gs.info('Updated Task: ' + taskgr.number);
} else {
gs.info('No Short Description: ' + taskgr.number);
}
}
}
}

If my response helped, please hit the 👍Thumb Icon and accept the solution so that it benefits future readers.

Regards,

Mohd Arbaz.

Re: Background script to update new field on Task with task related requested item field dont work

Viraj Hudlikar — Thu, 08 May 2025 04:31:21 GMT

@Siddharth Parna

taskgr.query(); - You missed the parentheses, so the query was never executed.
reqItem.get(taskgr.request_item.toString()) - Ensures the correct sys_id is passed

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

Re: Background script to update new field on Task with task related requested item field dont work

Siddharth Parna — Thu, 08 May 2025 04:35:45 GMT

This works.Can you also let me know how to filter based on assignment group as mentioned in the comments.I tried giving the id ,but I see when added filter records dont get updated

Re: Background script to update new field on Task with task related requested item field dont work

Ankur Bawiskar — Thu, 08 May 2025 04:42:42 GMT

@Siddharth Parna

try this for your earlier question and subsequent question as well and give correct group sysId

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Background script to update new field on Task with task related requested item field dont work

Ankur Bawiskar — Thu, 08 May 2025 04:52:31 GMT

@Siddharth Parna

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

If my response helped please mark it correct as well so that it benefits future readers.

Re: Background script to update new field on Task with task related requested item field dont work

mohdarbaz — Thu, 08 May 2025 05:03:17 GMT

@Siddharth Parna If my response helped, please mark it as helpful and accept it as one more solution.

Re: Background script to update new field on Task with task related requested item field dont work

Nilesh Pol — Thu, 08 May 2025 05:48:19 GMT

@Siddharth Parna you just need to make sure you:

the correct sys_id of the group (not its name) used, Reference the field properly in your addQuery() condition. and Place the filter before the query() call.