GlideAggregate – Get Count – Reusable Code

var gaCountReusable = Class.create();
gaCountReusable.prototype = {
    initialize: function() {
    },

	aggregateCount: function(table, query) {
        /*
		table = tableName [string]
		query = encodedQuery [string]
		*/

        var gaCount = new GlideAggregate(table);
        gaCount.addEncodedQuery(query);
        gaCount.addAggregate('COUNT');
        gaCount.query();
        var count = 0;
        if (gaCount.next()) {
            count = gaCount.getAggregate('COUNT');
            return count;
        }
    },

    type: 'gaCountReusable'
};

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {

    var table = 'incident';
    var query = 'stateIN1,2,3^assignment_group!=NULL';
    var fieldLabels = ['Number', 'Short Description', 'State','Assignment Group', 'Assigned To'];
    var fields = ['number', 'short_description','state','assignment_group', 'assigned_to'];
    var results = new gaCountReusable().aggregateCount(table, query, fieldLabels, fields);

    template.print(results);


})(current, template, email, email_action, event);

Number of Incidents: ${mail_script:getIncidentCountGA}