glide created record and store field value in workflow scratchpad

Hitesh targe · ‎04-06-2018

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

Ashutosh Munot1 · ‎04-09-2018

HI,

This is the problem, You are trying to set reference field with String or Number value and that will not work here.

What should you do it save sys_id in scratchpad and use that to save it to u_position field. And That u_post table should have display value true for Number field. hence it will show number automatically there. Use below code:

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 = id;

And the use this scratchpad. This will show you record in this u_position field as this is a reference field.

Thanks,
Ashutosh Munot

View solution in original post

Ashutosh Munot1 · ‎04-06-2018

HI,

Show me your code?

Thanks,
Ashutosh Munot

Hitesh targe · ‎04-06-2018

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;

Ashutosh Munot1 · ‎04-06-2018

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

Hitesh targe · ‎04-08-2018

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

Ashutosh Munot1 · ‎04-08-2018

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