Name
global.TeamVelocityUtil
Description
No description available
Script
var TeamVelocityUtil = Class.create();
TeamVelocityUtil.prototype = {
initialize: function(){
},
getName: function(teamId) {
var teamGR = new GlideRecord("scrum_pp_team");
if (teamGR.get(teamId))
return teamGR.team_name;
return teamId;
},
hasData: function(teamNameId){
for (var id in this.getSprintData(teamNameId))
return true;
return false;
},
getSprintData: function(teamId){
var teamName = this.getName(teamId);
var teams = {};
var tm = new GlideRecord("scrum_pp_team");
tm.addQuery("team_name", teamName);
tm.query();
while (tm.next())
teams[tm["sys_id"]] = tm.getValue("sys_id");
var releases = [];
var gr = new GlideRecord("rm_release_scrum");
gr.orderBy("start_date");
gr.query();
while(gr.next()) {
var sprints = [];
var count = 0;
var sp = new GlideRecord("rm_sprint");
sp.addQuery("release", gr["sys_id"]);
sp.addQuery("state", 3);
sp.orderBy("start_date");
sp.query();
while(sp.next())
if (teams[sp["release_team"]] != null) {
sprints.push([sp.getValue("sys_id"), sp.getValue("short_description"), sp.getValue("actual_points")]);
count++;
}
if (count > 0)
releases.push([gr.getValue("sys_id"), count, gr.getValue("short_description"), sprints]);
}
return releases;
}
}Sys ID
7781a57237202000dadaa3549dbe5deb