Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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;