- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2017 05:39 AM
var qry ="stateNOTIN3,6,7,10";
qry += "^business_service=44fb09b16fa96a00e40e0f1aea3ee42c";
qry += "^sys_created_onBETWEEN";
qry += "javascript:gs.dateGenerate('2016-09-01','00:00:00')";
qry += "@javascript:gs.dateGenerate('2016-12-31','23:59:59')";
qry+= "^sys_updated_onRELATIVELE@dayofweek@ago@14";
var gr = new GlideRecord('incident');
gr.addEncodedQuery(qry);
gr.query();
Whats wrong in this script?
Bu URL it works fine but when I Glide Record, it does not work.
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2017 06:02 AM
Hi Vinitha, I think the issue is with "NOTIN" vs "NOT IN". Please give a space in "NOTIN" query and see if that works. Regards, Chirag Bagdai
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2017 06:22 AM
I concur with Chirag,NOT IN should be two words..also business service should be a field name such as below:
stateNOT IN3,7^sys_created_onBETWEENjavascript:gs.dateGenerate('2016-09-01','00:00:00')@javascript:gs.dateGenerate('2016-12-31','23:59:59')^sys_updated_onRELATIVELE@dayofweek@ago@14^u_service_affected=24eb74132d93d400a6f73100202fabd3