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

Offical Documentation

Official Docs: