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