Regarding priority in incident form

[SNOW24]

I want to calculate the count of all the p1,p2 and p3  incidents in last 3 months. please provide script for this.

[Gopal Allu]

Hi @SNOW24 ,

Please try this code for getting the required row count.

var grc = new GlideRecord('incident');
grc.addEncodedQuery('active=true^priorityIN1,2,3^sys_created_onONLast 3 months@javascript:gs.beginningOfLast3Months()@javascript:gs.endOfLast3Months()');
grc.query();
if(grc.next())
{
	gs.addInfoMessage(grc.getRowCount());
}​

If it is helpful please mark it correct.

Thanks and Regards,

Allu Gopal.

[Anirudh Pathak]

Hi @SNOW24 ,

Please use the below code - 

var count = 0;
var inc = new GlideAggregate('incident');
inc.addEncodedQuery('priority=1^ORpriority=2^ORpriority=3^sys_created_onONLast 3 months@javascript:gs.beginningOfLast3Months()@javascript:gs.endOfLast3Months()');
inc.addAggregate('COUNT');
inc.query();
if(inc.next()){
count = inc.getAggregate('COUNT');

}
gs.info(count);

[BalaG]

Here is a simpler version of the encodedQuery

inc.addEncodedQuery('active=true^priority=1^ORpriority=2^ORpriority=3^sys_created_on>javascript:gs.beginningOfLast3Months()');

hope this helps

--

Bala

[AndersBGS]

Hi @SNOW24 ,

Why do you want to create a script for what there can be done through the report designer? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders