question glide created record and store field value in workflow scratchpad in ITSM forum

glide created record and store field value in workflow scratchpad

Hitesh targe — Fri, 06 Apr 2018 07:43:40 GMT

Hi All,

How can we pass created record value into workflow scratch pad.

I am creating a record via catalog item workflow script and once the record is created, number will be auto generated in table.

I want to pass generated number into my same workflow scratch pad in next activity.

can anyone suggest me with the script please.

Thanks

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Fri, 06 Apr 2018 07:49:40 GMT

Hi,

We use workflow scratchpad as below:

Suppose you have created a Record using script you might have a use var id = gr.insert(); where id will store sys id of newly created record.

Then you will have to gliderecord that table to fetch number of newly created record.

and get that number and store in workflow as below:

workflow.scratchpad.num = gr.number;

Then where ever you want to access this you can directly use workflow.scratchpad.num to assign or use number.

Thanks,
Ashutosh Munot

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Fri, 06 Apr 2018 07:52:52 GMT

HI,

See below links:

https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/administer/using-workflows/concept/c_WorkflowScratchpadVariables.html

https://community.servicenow.com/community?id=community_question&sys_id=05660be1db1cdbc01dcaf3231f96196c

Thanks,
Ashutosh

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Fri, 06 Apr 2018 08:23:08 GMT

HI Ashtosh,

My number will generate after inserting the record.

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Fri, 06 Apr 2018 08:48:42 GMT

if i user var id = gr.insert();

record is inserting 2 times

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Fri, 06 Apr 2018 09:29:39 GMT

HI,

Show me your code?

Thanks,
Ashutosh Munot

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Fri, 06 Apr 2018 13:55:28 GMT

please find the script below

var gr = new GlideRecord('u_posts');
gr.initialize();
gr.pos_desc = workflow.scratchpad.desc;
gr.pos_type = workflow.scratchpad.type;

gr.insertWithReferences();

var id = gr.insert():

var mem = new GlideRecord('u_posts');

gr.addQuery('sys_id', id);

workflow.scratchpad.number = mem.u_number;

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Sat, 07 Apr 2018 06:31:48 GMT

HI,

Use below Script:

var gr = new GlideRecord('u_posts');
gr.initialize();
gr.pos_desc = workflow.scratchpad.desc;
gr.pos_type = workflow.scratchpad.type;

gr.insertWithReferences();

var id = gr.insert():

var mem = new GlideRecord('u_posts');

mem.addQuery('sys_id', id);

mem.query();

mem.next();

workflow.scratchpad.number = mem.u_number;

Thanks,
Ashutosh Munot

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Mon, 09 Apr 2018 02:17:25 GMT

I tried with your script,

Still record is inserting 2 times(duplicate)

if I remove below script, it is inserting only one time

var id = gr.insert():

var mem = new GlideRecord('u_posts');

mem.addQuery('sys_id', id);

mem.query();

mem.next();

workflow.scratchpad.number = mem.u_number;

please suggest

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Mon, 09 Apr 2018 04:10:34 GMT

HI,

I Know why!

Use below script now. We are insert it twice using gr.insert and gr.insertWithReference

var gr = new GlideRecord('u_posts');
gr.initialize();
gr.pos_desc = workflow.scratchpad.desc;
gr.pos_type = workflow.scratchpad.type;

var id = gr.insertWithReferences();

var mem = new GlideRecord('u_posts');

mem.addQuery('sys_id', id);

mem.query();

mem.next();

workflow.scratchpad.number = mem.u_number;

Thanks,
Ashutosh

Re: glide created record and store field value in workflow scratchpad

Ujjawal Vishnoi — Mon, 09 Apr 2018 04:41:08 GMT

Hi Hitesh,

You can use script as mentioned below

var gr = new GlideRecord('u_posts');
gr.initialize();
gr.pos_desc = workflow.scratchpad.desc;
gr.pos_type = workflow.scratchpad.type;

var id = gr.insert();

workflow.scratchpad.number = gr.u_number;

You need not to glide again.

Hope this helps.

Regards

Ujjawal

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Mon, 09 Apr 2018 04:55:05 GMT

HI Ashutosh,

Thanks for the reply.

now it is capturing in scratch pad.

Now the value is coming in list view but if I open the record, field value is blank

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Mon, 09 Apr 2018 04:55:44 GMT

We tried this but Here number is generating after inserting the record.

Re: glide created record and store field value in workflow scratchpad

Ujjawal Vishnoi — Mon, 09 Apr 2018 04:58:10 GMT

ok then try this.

var gr = new GlideRecord('u_posts');
gr.newRecord();
gr.pos_desc = workflow.scratchpad.desc;
gr.pos_type = workflow.scratchpad.type;

var id = gr.insert();

workflow.scratchpad.number = gr.u_number;

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Mon, 09 Apr 2018 05:15:48 GMT

HI Ujjawal,

Thanks for the reply. This is not working. The code which ashuthosh gave is working fine but the issue is, value is visble in list view. If I open the record, field is blank. please find my screenshots posted in my previous comment

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Mon, 09 Apr 2018 05:36:09 GMT

HI,

We are not setting this field anywhere which you have highlighted.

We are only moving it to scratchpad. Where are you setting this field can you tell me?

Thanks,
Ashutosh Munot

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Mon, 09 Apr 2018 05:37:21 GMT

HI,

If your work is done close this thread by marking answer as helpful or correct.

Thanks,
Ashutosh

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Mon, 09 Apr 2018 06:01:28 GMT

HI Ashutosh,

we are setting number to scratchpad and in next run script I am setting this value. Please find my script below

workflow.scratchpad.number = mem.u_number;

var gr = new GlideRecord("sys_user");
gr.addEncodedQuery("sys_idIN"+current.variables.user);
gr.query();

var gr_names = "";

while (gr.next()) {

var grm = new GlideRecord('u_user_post');
grm.initialize();

grm.u_position = workflow.scratchpad.number;
grm.u_active = 'true';
grm.u_user=gr.sys_id;
grm.query();
grm.insert();

//grm.insertWithReferences();

}

Re: glide created record and store field value in workflow scratchpad

Ashutosh Munot1 — Mon, 09 Apr 2018 06:33:09 GMT

HI,

Can you tell me type of this field?

grm.u_position

Thanks,
Ashutosh Munot

Re: glide created record and store field value in workflow scratchpad

Hitesh targe — Mon, 09 Apr 2018 07:08:34 GMT

This is reference field to u_posts and number (u_number) from u_posts will save in u_position.