- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-04-2023 12:36 PM
i have added a filter as shown below and copied the query and now i am trying to use the same query in my scheduled job and getting
filter: Updated between 1st March 2023 to 31st March 2023, copied query is - u_region=NA^sys_updated_onBETWEENjavascript:gs.dateGenerate('2023-03-01','00:00:00')@javascript:gs.dateGenerate('2023-03-31','23:59:59')
now below is the error in my scheduled job, when i am copy pasting same query, please help me fix this "unexpected token 2023" error
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-04-2023 12:49 PM
gr.addEncodedQuery("u_region=NA^sys_updated_onBETWEENjavascript:gs.dateGenerate('2023-03-01','00:00:00')@javascript:gs.dateGenerate('2023-03-31','23:59:59')")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-04-2023 12:44 PM
Hi @servicenow begi ,
Can you try with
gr.addEncodedQuery('u_region=NA^sys_updated_onBETWEEN' + javascript:gs.dateGenerate('2023-03-01','00:00:00') + '@' + javascript:gs.dateGenerate('2023-03-31','23:59:59'));
Thanks and Regards,
Rahul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-04-2023 12:48 PM
Hello @servicenow begi
1. replace ' with double quotes " before u_region.
2. replace ' with double quotes " before );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-04-2023 12:49 PM
gr.addEncodedQuery("u_region=NA^sys_updated_onBETWEENjavascript:gs.dateGenerate('2023-03-01','00:00:00')@javascript:gs.dateGenerate('2023-03-31','23:59:59')")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-04-2023 01:39 PM
thank you so much, it worked