Name
global.VelocityUtil
Description
No description available
Script
var VelocityUtil = Class.create();
VelocityUtil.prototype = {
initialize: function(){
},
addData: function(releaseSysId, data, teamId, teamName, previousCount, names){
var count = 0;
for (var j = 0; j < previousCount; j++){
data.addValue(0, teamName, names[j]);
count++;
}
var gr = this.getGR(releaseSysId, teamId);
while (gr.next()) {
var points = gr["actual_points"];
var name = gr["short_description"];
data.addValue(points, teamName, name);
count++;
}
for (var j = count; j < names.length; j++)
data.addValue(0, teamName, names[j]);
return count;
},
getDataNames: function(releaseSysId, teamId){
var names = [];
var gr = this.getGR(releaseSysId, teamId);
while (gr.next())
names[names.length] = gr.getValue("short_description");
return names;
},
getTeams: function(releaseSysId){
var teams = {};
var gr = this.getGR(releaseSysId, null);
while(gr.next()) {
var team = gr["release_team"];
if (team != null && team != "") {
var tr = new GlideRecordSecure("scrum_pp_team");
tr.addQuery("sys_id", team);
tr.query();
if (tr.next())
teams[tr["sys_id"]] = tr.team_name.getDisplayValue();
}
}
return teams;
},
getGR: function(releaseSysId, teamId, teamNotNull){
var data = CategoryChart.getNewDataset();
var gr = new GlideRecordSecure("rm_sprint")
if (releaseSysId)
gr.addQuery("release", releaseSysId);
if (teamId)
gr.addQuery("release_team", teamId);
else if (teamNotNull)
gr.addNotNullQuery("release_team");
gr.addQuery("state", 3);
gr.orderBy("start_date");
gr.query();
return gr;
},
hasData: function(releaseSysId, teamId){
if (teamId == null || teamId == "") {
var teams = this.getTeams(releaseSysId);
for (var key in teams)
return true;
}else if (releaseSysId == null || releaseSysId == "") {
var gr = this.getGR(null, teamId);
if (gr.next())
return true;
}
return false;
}
}
Sys ID
7a6b11ea37202000dadaa3549dbe5d25