question How to set value in workflow in Developer forum

How to set value in workflow

RudhraKAM — Tue, 04 Jun 2019 19:49:41 GMT

Can some one help me with this script

I have a table u_test_results in which there is a record XYZ1 ( with name as u_name)

I have a catalog item on which we have a variable which is reference field of above table , when a user picks the above record and place a request we need to set a current time on other table

in the workflow i am writing this script and its not setting the time . Can you please help me fixing this issue .

The other table is u_solution which has 2 fields

1 closed date and 2.record for (this field contains XYZ record and its a reference field too)

var GOT= parseInt(current.variables.u_name.getDisplayValue());
var gr = new GlideRecord('u_solution ');
gr.addQuery(u_recorded_for, GOT);
gr.query();

if (gr.next()) {
gr.u_closed_date = current.opened_at;
gr.update();
}

Re: How to set value in workflow

Mike Patel — Tue, 04 Jun 2019 19:52:52 GMT

try

var GOT= parseInt(current.variables.u_name.getDisplayValue());
var gr = new GlideRecord('u_solution');
gr.addQuery('u_recorded_for', GOT);
gr.query();
if (gr.next()) {
	gr.u_closed_date = current.opened_at;
	gr.u_recorded_for = current.sys_id;
	gr.update();
}

Re: How to set value in workflow

RudhraKAM — Tue, 04 Jun 2019 20:20:21 GMT

Thanks Mike ,, the end date didnt populated ( its not working )

Re: How to set value in workflow

Mike Patel — Tue, 04 Jun 2019 20:27:18 GMT

Did it update below field ?

u_recorded_for

Re: How to set value in workflow

Prateek kumar — Tue, 04 Jun 2019 20:28:18 GMT

//var GOT= parseInt(current.variables.u_name.getDisplayValue()); //Why this line??

var GOT= current.variables.u_name;
var gr = new GlideRecord('u_solution ');
gr.addQuery('u_recorded_for', GOT);
gr.query();

if (gr.next()) {
gr.u_closed_date = current.opened_at;
gr.update();
}

Re: How to set value in workflow

RudhraKAM — Wed, 05 Jun 2019 13:32:01 GMT

Thanks Prateek , The code didnt work 😞

Re: How to set value in workflow

RudhraKAM — Wed, 05 Jun 2019 13:33:17 GMT

yes that is same as u_name

Re: How to set value in workflow

Mike Patel — Wed, 05 Jun 2019 13:38:24 GMT

try

var GOT= current.variables.u_name.getDisplayValue();
var gr = new GlideRecord('u_solution');
gr.addQuery('u_recorded_for', GOT);
gr.query();
if (gr.next()) {
	gr.u_closed_date = current.opened_at;
	gr.u_recorded_for = current.sys_id;
	gr.update();
}

Re: How to set value in workflow

hvrdhn88 — Wed, 05 Jun 2019 13:38:58 GMT

var GOT= current.variables.u_name.getDisplayValue();
gs.log('The Value is'+GOT);
var gr = new GlideRecord('u_solution');
gr.addQuery('u_recorded_for',GOT);
gr.query();
gs.log('Row Count'+gr.getRowCount());
if (gr.next()) {
	gr.u_closed_date = current.opened_at;
	gr.u_recorded_for = current.sys_id;
	gr.update();
}

try now and let me know the log details.

Re: How to set value in workflow

RudhraKAM — Wed, 05 Jun 2019 15:27:35 GMT

Thanks Harsh

its showing some error message in workflow activity ( u_recorded_for is not defined

logs returning the name and rowcount returns some sys_id

I double check the name in the table it is correct

Re: How to set value in workflow

RudhraKAM — Wed, 05 Jun 2019 15:32:11 GMT

its showing run script error

stating that u_recorded_for is not defined

Re: How to set value in workflow

hvrdhn88 — Wed, 05 Jun 2019 15:38:05 GMT

"u_recorded_for" it is on which table ?

can you put the screenshot here of workflow and the field

Re: How to set value in workflow

RudhraKAM — Wed, 05 Jun 2019 17:17:21 GMT

U_recorded_for is on u_solution tables which is reference of cmdb_ci

current.variables.u_name.getDisplayValue();

is a reference of u_delegate table both the records have same sys_id

Re: How to set value in workflow

RudhraKAM — Thu, 06 Jun 2019 13:14:31 GMT

Hello Harsh

please see this post this is similar to existiing issue

https://community.servicenow.com/community?id=community_question&sys_id=01865a6edb35bb80d58ea345ca96197a

Re: How to set value in workflow

hvrdhn88 — Thu, 06 Jun 2019 14:31:16 GMT

is it possible , if you can connect me on webex and share your screen, this way i can quickly try to help you .

Re: How to set value in workflow

RudhraKAM — Thu, 06 Jun 2019 14:45:11 GMT

sure

Re: How to set value in workflow

RudhraKAM — Thu, 06 Jun 2019 14:51:05 GMT

https://us04web.zoom.us/j/6889975608

Re: How to set value in workflow

hvrdhn88 — Thu, 06 Jun 2019 14:55:37 GMT

joining ..

Re: How to set value in workflow

RudhraKAM — Thu, 06 Jun 2019 15:10:14 GMT

Hi harsh are you joining ?

Re: How to set value in workflow

hvrdhn88 — Thu, 06 Jun 2019 15:10:19 GMT

i tried to connect you and seems like you are on another zoom meeting.