last X days incidents

[sravankumar9637]

how can i get last x days incidents in background scripts. 

[jaheerhattiwale]

@sravankumar9637 Please write below code in background script

var numberOfDays = 10;

var inc = new GlideRecord("incident");

inc.addQuery("sys_created_onRELATIVELT@dayofweek@ahead@"+numberOfDays);

inc.query();

while(inc.next()){

    gs.info(inc.number.toString());

}

Please mark as correct answer if this solves your issue.

[sravankumar9637]

ok fine nice , But how to get without encoded Query

[jaheerhattiwale]

@sravankumar9637 Without encoded query means?

[laszloballa]

Here's an example script you can use (obviously doing whatever you'd like in the while loop):

var daysAgo = 7; // update accordingly

var latestIncidents = new GlideRecord('incident');
latestIncidents.addEncodedQuery('sys_created_onRELATIVEGT@dayofweek@ago@' + daysAgo.toString());
latestIncidents.query();
while(latestIncidents.next()) {
  gs.print(latestIncidents.getValue('number'));
}