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

[Bozhidar Dimitr]

But which table is the workflow running on?

[Rakhesh]

sc_req_item

[Bozhidar Dimitr]

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();
}

How many records has the query found when logging their count (first line)?

[Rakhesh]

found 0 records

[Bozhidar Dimitr]

Ah, there is the issue - it does not enter the if-block because there are simply no records found to update.

Now, can you take a screenshot or give context about your workflow process? Perhaps you are trying to run this script before creating the actual approval? Or perhaps you are trying to assign the approval to an invalid user?