Fix script is getting compilation error

[Sivakumar7]

Hi Guys, 

My requirement: I need to update the incident records to close state from the created date with filter conditions as I have used in below fix script and I am getting the below error "Javascript compiler exception: missing ) after argument list (null.null.script; line 3) in:"

var inc = new GlideRecord('incident');

inc.addEncodedQuery('active=true^assignment_group=ba1859496f000200c0c334afae3ee406^sys_class_name=incident^short_descriptionLIKEPercent Used Space is too high::AlertKey^sys_created_on>=javascript:gs.dateGenerate('2019-04-24','10:00:00')');

inc.query();

gs.print(inc.getRowCount());

Regards, 

Sivakumar

[Lorenz · Accepted solution]

Here:

('active=true^assignment_group=ba1859496f000200c0c334afae3ee406^sys_class_name=incident^short_descriptionLIKEPercent Used Space is too high::AlertKey^sys_created_on>=javascript:gs.dateGenerate('2019-04-24','10:00:00')');

change to double quotes:

("active=true^assignment_group=ba1859496f000200c0c334afae3ee406^sys_class_name=incident^short_descriptionLIKEPercent Used Space is too high::AlertKey^sys_created_on>=javascript:gs.dateGenerate('2019-04-24','10:00:00')");

The single quotes surrounding your date is interfering with the quotes around your query.

[rajeshbxr19]

now my script is working fine Thanks

[vkachineni]

// This compiled on my PDI

var inc = new GlideRecord('incident');

inc.addEncodedQuery("active=true^assignment_group=ba1859496f000200c0c334afae3ee406^sys_class_name=incident^short_descriptionLIKEPercent Used Space is too high::AlertKey^sys_created_on>=javascript:gs.dateGenerate('2019-04-24','10:00:00')");

inc.query();

gs.print(inc.getRowCount());

//

*** Script: 0

[Sivakumar7]

Hi Lorenz, Code is compiled successfully but I am not getting the exact count of records but I have used the exact filter query copied to this code.. Do you have any idea? Regards, Sivakumar