Script

[BharatiK]

Hi,  

I want to show the result like below using script.

How to achieve this?

Script:

var inc = new GlideRecord ('incident');

inc.query();

while (inc.next())

{

gs.print (inc.state);

gs.getRowCount (inc.state);

}

[Ankur Bawiskar]

@BharatiK 

something like this using GlideAggregate

var gaInc = new GlideAggregate('incident');
gaInc.addAggregate('count');
gaInc.orderByAggregate('count');
gaInc.groupBy('state'); 
gaInc.query();
while(gaInc.next()){
var count = gaInc.getAggregate('count');
gs.info('State: ' + gaInc.state.getDisplayValue() + ' has incidents : ' + count);
}

Output:

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@BharatiK 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@BharatiK 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[MadisonFlores]

Looks good! Just adjust the print statement for the desired output.