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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2016 02:54 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2017 10:05 AM
Ok - sorry - how do I call these scripts to populate the field mentioned above (Count Number).
Thanks
Jay