workflow editor

Govind Bysani
Tera Contributor

var grpnameFinal='admin group';

var gr=new GlideRecord('sys_user_group');
gs.info('Entering into filter with contain');
gs.log('in line 21 '+typeof(grpnameFinal));
gr.addQuery('name','CONTAINS',grpnameFinal);
gs.info('Query to run '+encodedquery_1);
//gr.addEncodedQuery('nameLIKE'+grnameFinal);
//gs.info('After contain');
gr.query();
gs.log('Query done');

 

I have written this code in workflow editor script, when this script triggers, I cannot able to see the log which was mentioned in last line(gr.query()) of script. can anyone help me on this.

6 REPLIES 6

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

encodedquery_1 is not defined. Fix this.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

Hi,

Just ignore that line which was related to encodedquery_1, My issue was the last line in the script which was a log, it was not getting generated in logs table, a[art from that all info and logs are generating.

Please then post your correct code so we can properly have a look. Because your code breaks due to the encodedquery_1 and it won't proceed further.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

Hi,

below one is the complete please look into it.

 

var answer = [];

gs.info("Entered");
var grpname='admin group';
var grpnameFinal=grpname.slice(4);
gs.info('Group name after slice is'+' '+grpnameFinal);
var managerName="";
var encodedquery_1='nameLIKE'+grpnameFinal.toString();
gs.info("Group name is"+" "+grpnameFinal);
gs.info('Started glide');
var gr=new GlideRecord('sys_user_group');
gs.info('Entering into filter with contain');
gs.log('in line 21 '+typeof(grpnameFinal));
gr.addQuery('name','CONTAINS',grpnameFinal);
gs.info('Query to run '+encodedquery_1);
//gs.info('After contain');
gr.query();
gs.info('Query done');
gs.info('row count after filter '+gr.getRowCount());
if(gr.hasNext()){
managerName=gr.manager;
gs.info('Manager name is'+' '+gr.manager);
}
gs.info('Manager name is'+' '+managerName);
answer.push(managerName);
//current.approver=managerName;