Not able to generate query for date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2020 09:18 PM
Need help for generating an encoded query.
The query which I generated from filter is
"requested_for=8cc54160dbd82f4061ca8d37489619e2^state=3^startON2020-08-17@javascript:gs.dateGenerate('2020-08-17','start')@javascript:gs.dateGenerate('2020-08-17','end')"
var requester = "8cc54160dbd82f4061ca8d37489619e2";
var dateCheck = "2020-08-17";
Need help in creating a query where I need to replace the bold items with requester and dateCheck.
Tried this in background script but always getting the error. The part where I am getting error is in the second and third bold dates. Error - Unexpected token start
var requestor = '8cc54160dbd82f4061ca8d37489619e2'; //sysID of the user
var datecheck = '2020-08-18'; //Date to put
var gr = new GlideRecord("sn_wsd_core_workplace_request"); //Query the table
gr.addEncodedQuery("requested_for="+requestor+"^state=3^startON"+datecheck+"@javascript:gs.dateGenerate("+datecheck+","start")@javascript:gs.dateGenerate('2020-08-17','end')");
gr.query();
while(gr.next()){
gs.print("test");
}
gs.print(gr.getRowCount());
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2020 12:15 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2020 01:16 AM
Hi Ashutosh,
Issue with quotes. Can you try replacing
gr.addEncodedQuery("requested_for="+requestor+"^state=3^startON"+datecheck+"@javascript:gs.dateGenerate("+datecheck+","start")@javascript:gs.dateGenerate('2020-08-17','end')");
with
gr.addEncodedQuery("requested_for="+requestor+"^state=3^startON"+datecheck+"@javascript:gs.dateGenerate("+datecheck+",'start')@javascript:gs.dateGenerate('2020-08-17','end')");