The CreatorCon Call for Content is officially open! Get started here.

How to count number of incident closed by particular user in current day and number to set at "Count Number" field

Rajababu
Giga Guru

Hi All,

As I asked how to count the number of incident closed by particular user in 1 day(current or past) .And that count I want to set on one I field created to "Count Number " to repersent field.

Note :

Is any table that have count the number of incident closed as like Metrics.

How to count the number that closed .

and How to set that number on mentioned field.

What i tried is

"

function onLoad() {

  var get = new GlideRecord('incident');

  //get.addQuery('priority', 1);

//gr.addQuery('caller_id',caller);

get.addQuery('state','7');

get.query();

//var count=0;

if (get.next()){

//while (get.next()){

count=count+1;

}//

  alert ("Its working as per requirement");

}

alert ("it going to set the value");

g_form.setValue('u_count_number',Count_number);

   

}

"

So Please help in this .

Regards,

Gaurav Rai

DHall david.a.messler@diageo.com ctomasi wilsmi

5 REPLIES 5

Ok - sorry - how do I call these scripts to populate the field mentioned above (Count Number).



Thanks



Jay