set a value by using runscript in workflow

[Rakhesh]

Hi ALL,

I want to set a field value(string) in approval table by using runscript in Workflow. I wrote one runscript but it did not works. Guys, please have a look once.

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('sysapproval', current.sys_id);
gr.query();
if(gr.next()){
gr.u_approval_type='First leval Approval';// u_approval_type is a field name
}

Regards,

Rakhesh

[Dubz]

If the workflow is running on the RITM table then you should be able to reference the current.sys_id in the glide query. Put an initial gs.log to confirm the workflow is reaching the run script activity and what the current record is:

gs.log('run script activated!');
gs.log('this is the current record: ' + current.number);

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id', current.sys_id);
gr.query();
gs.log('found ' + gr.getRowCount() + ' records');
if(gr.next()){    //change this line to while(gr.next()){ to loop through records
gs.log("TEST FOUND APPROVAL RECORD");
gr.u_approval_type='First level Approval';
gr.update();
}

[Rakhesh]

gs.log('run script activated!');
gs.log('this is the current record: ' + current.number);

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id', current.sys_id);
gs.log('query checking!!');
gr.query();
gs.log('found ' + gr.getRowCount() + ' records');
if(gr.next()){ //change this line to while(gr.next()){ to loop through records
gs.log('TEST FOUND APPROVAL RECORD');
gr.u_approval_type='First level Approval';
gr.update();
}

i tried the above code. here, 4 logs are coming. but inside of the if condition log is not coming 

[Dubz]

OK so the run script is triggering and the glide query is running, all good. Is it returning the current.number you are expecting? If so, also good, if not that's a problem.

How many records is it saying are being returned in the glide query? should be the 4th log.

[Bozhidar Dimitr]

getapprovar.u_approval_type='First level Approval';

^ this line should be modified to be:

gr.u_approval_type = 'First level Approval';

On a side note, if there is nothing logged (even just 'TEST FOUND APPROVAL RECORD : '), there is a chance that the approval has not yet been registered. Is the workflow running on the approvals table? If it is running on any other table, for instance request, requested item or whatever - perhaps try to modify the query to be as follows:

gr.addQuery('document_id', current.sys_id);

But that's a wild guess, if you'd like - provide some context on your task so that we know better what you're delaing with 🙂

[Rakhesh]

hi,

I tried this one also. it did not work for me.