question Re: Create multiple tasks for one catalog item in ServiceNow AI Platform forum

Create multiple tasks for one catalog item

dibeenapearl — Thu, 14 Sep 2017 07:05:36 GMT

Hi,

I have created a catalog item which has a list variable. This list variable is used to select users from the user table.

What I am trying to achieve: when the RITM gets approved, it should create a task for each user in the list variable.

Attempts did: I tried to create the task from the workflow using "Run Script". It did create the required number of tasks for one RITM, but I cannot see any variables of the RITM in the Variable tab of TASK.

The script I used to create task is:

//users = list variable

var a=current.variables.users;

var a_split=a.toString().split(',');

for(var i=0;i<a_split.length;i++)

{

var gt=new GlideRecord('sc_task');

gt.initialize();

gt.short_description='task created: '+i;

gt.request_item=current.sys_id;

gt.assignment_group.setDisplayValue('Client Support');

gt.parent = current.sys_id;

gt.insert();

}

Please find the RITM and TASK screenshot attached.

I would prefer the variables to appear on the variable Tab, but also the "Requested for:" should have only the user from the list variable. Is it possible?

Thanks,

Dibeena

Re: Create multiple tasks for one catalog item

gdd — Thu, 14 Sep 2017 07:21:17 GMT

requested for field on the RITM and Task is coming from request, it will be always dot walk field.

check global checkbox on the variables it will show on the task

Re: Create multiple tasks for one catalog item

PrashantLearnIT — Thu, 14 Sep 2017 07:22:03 GMT

Hi Dibeena,

Can you please share Run Script code you have used?

Re: Create multiple tasks for one catalog item

dibeenapearl — Thu, 14 Sep 2017 07:32:02 GMT

//users = list variable

var a=current.variables.users;

var a_split=a.toString().split(',');

for(var i=0;i<a_split.length;i++)

{

var gt=new GlideRecord('sc_task');

gt.initialize();

gt.short_description='task created: '+i;

gt.request_item=current.sys_id;

gt.assignment_group.setDisplayValue('Client Support');

gt.parent = current.sys_id;

gt.insert();

}

Re: Create multiple tasks for one catalog item

gdd — Thu, 14 Sep 2017 07:46:07 GMT

i think it should be working properly

Re: Create multiple tasks for one catalog item

dibeenapearl — Thu, 14 Sep 2017 12:40:47 GMT

Thanks, Girish. I made the variables global and now I can see the variables in the TASK.

Re: Create multiple tasks for one catalog item

dibeenapearl — Thu, 14 Sep 2017 12:43:16 GMT

Thanks for that.

One issue is still there. Each TASK shows all the users.I selected two users and it is preferable to see only one user as "Requested For:" in one TASK. Is it possible

Is it possible to show only one user in each TASK as "Requested For:"?

Re: Create multiple tasks for one catalog item

gdd — Thu, 14 Sep 2017 12:49:18 GMT

i think for that you will have to create seperate request since requestedfor is always inherited from request.

Re: Create multiple tasks for one catalog item

dibeenapearl — Sun, 17 Sep 2017 23:18:49 GMT

Thanks for the help. I am now able to show the user's name in the short description field.

I created a field (user) in the item and was wondering whether I can populate that field with the corresponding username along with the creation of tasks?

Thanks,

Dibeena

Re: Create multiple tasks for one catalog item

dibeenapearl — Mon, 18 Sep 2017 06:06:56 GMT

I have modified my script as below:

var a=current.variables.users.getDisplayValue();

var a_split=a.split(',');

for(var i=0;i<a_split.length;i++)

{

var gt=new GlideRecord('sc_task');

gt.initialize();

gt.short_description='task created: '+a_split[i];

gt.description='task created for SAP access' +a_split[i];

gt.request_item=current.sys_id;

gt.assignment_group.setDisplayValue('Client Support');

gt.parent = current.sys_id;

gt.start_date = current.u_request_date;

gt.due_date = current.due_date;

//fill user field with the correspondign user's name

current.variables.usr = a_split[i];

//Can perform additional functionalities if u want

gt.insert();

}

------------------------------------------------------------------------------------------------------------------

I used "current.variables.usr = a_split[i];" to fill my user variable of the task with relevant user's name, but it is filling up with the last selected user's name in all TASKS.

Will anyone be able to tell me on what I could be missign/doing wrong?

Thanks,

Dibeena

Re: Create multiple tasks for one catalog item

dibeenapearl — Thu, 21 Sep 2017 03:45:23 GMT

I have found the solution finally.

I was able to update each user's name in the short description.

I created the below client script which applies only to Catalog Tasks when the tasks are loaded

************************************************************************

function onLoad() {

//Type appropriate comment here, and begin script below

var desc = g_form.getValue('short_description');

var short_desc = desc.split(':');

g_form.setValue('usr',short_desc[1]);

}

*******************************************************************

I split the short description of the Task and copied the user's name on the field. It is getting updated accordingly.

my short description was "Access requested for: Bailey Asher". I split with ':' and copied "Bailey Asher" to the catalog field "usr".

Please close this conversation as "Answered" as I am not able to close it.

Thanks,

Dibeena