I would like to create a new script to query when field resolved time greater than 3 days.
I've tried to wrote a script, here are the details:
var finc = new SCFile("incidents");
var q = "alz.resolved.time>tod()-'3 00:00:00'";
var rc = finc.doSelect(q);
print("no interaction ticket found");
But the result showing null values or no interaction ticket found from the query. I've tried also (date(tod))>'3 00:00:00' but still doesn't work.
Can anyone suggest the best solution?