workflow editor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 08:01 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 08:07 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 08:16 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 08:38 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2024 12:30 AM
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;