Range calculator scripts

Release version: Australia

Updated March 12, 2026

2 minutes to read

Summarize

Summarized using AI

Summary of Range Calculator Scripts

The Range Calculator Scripts allow ServiceNow customers to manage range restrictions and update parent records efficiently when child records are modified within a timeline page. This functionality ensures accurate date management across project management records.

Show full answer Show less

Key Features

ExampleUpdateParentsRangeCalculator: Updates parent records based on changes to child record spans, ensuring parent timelines reflect accurate start and end dates.
ExampleMinRangeCalculator: Calculates the earliest start date and latest end date for a specified span, helping to define range limits for project management.
ExampleMaxRangeCalculator: Similar to the Min Range Calculator, it also identifies the earliest start date and latest end date, specifically for sprint records.

Key Outcomes

By implementing these scripts, ServiceNow customers can achieve:

Accurate updates to parent records based on child record changes, enhancing project planning.
Defined date ranges that prevent scheduling conflicts and support effective project timeline management.
Efficient logging and processing of date ranges, improving overall project visibility and control.

You can specify a script include that calculates range restrictions and processes parent updates in a timeline page.

Range Calculator Scripts

Following are three examples of script includes that help specify range restrictions.

ExampleUpdateParentsRangeCalculator

Updates parent records when a child record span is moved or resized in the timeline.

var ExampleUpdateParentsRangeCalculator = Class.create();
ExampleUpdateParentsRangeCalculator.prototype = {
initialize: function() { },
updateParents: function(id, table, startDate, endDate){
 if (table == "rm_sprint"){
   var releaseID;
   var sprint = new GlideRecord(table);
   sprint.addQuery('sys_id', id);
   sprint.query();
   if (sprint.next())
     releaseID = sprint.release + "";
   if (releaseID) {
         var now_GR = new GlideRecord("rm_release_scrum");
         gr.addQuery("sys_id", releaseID);
         gr.query();
         if (gr.next()) {
           if (startDate  && startDate < this.getTimeMs(gr.start_date))
               gr.start_date = this.getTimeObject(startDate); 
           if (endDate && endDate > this.getTimeMs(gr.end_date))
              gr.end_date = this.getTimeObject(endDate);
              gr.update();
         }
    }
  }
},  
getMinRangeDetails: function(id, table){ return [-1, -1, "", ""]; },
getMaxRangeDetails: function(id, table){ return [-1, -1, ""]; },
getTimeMs: function(date){ 
  return new GlideScheduleDateTime(date).getMS(); },
getTimeObject: function(timeMS) { 
  var gdt = new GlideDateTime(); 
  gdt.setNumericValue(timeMS); 
  return gdt; },
logMessage: function(message){ gs.log(message); },
type: 'ExampleUpdateParentsRangeCalculator'
}

In this example, the span is identified based on the id and table from function(id, table, startDate, endDate).

ExampleMinRangeCalculator

Defines the earliest start date and the latest end date for a specified span.

var ExampleMinRangeCalculator = Class.create();
  ExampleMinRangeCalculator.prototype = {
      initialize: function() { },
      updateParents: function(id, table, startDate, endDate){ },
      getMinRangeDetails: function(id, table){
           var min = -1;
           var max = -1;
           var minID = "";
           var maxID = "";
           if (table == "rm_release_scrum"){
                    var now_GR = new GlideRecord("rm_sprint");
                    gr.addQuery("release", id);
                    gr.query();
                    while(gr.next()){
                         var start = this.getTimeMs(gr["start_date"]);
                         var end = this.getTimeMs(gr["end_date"]);
                         var id = gr["sys_id"];
                         if (min == - 1 || start <= min){
                                if (start != min)
                                     minID = "";
                         min = start;
                         minID += "," + id;
                         }
                         if (max == -1 || end >= max){
                                    if (end != max)
                                            maxID = "";
                                    max = end;
                                    maxID += "," + id;
                            }  
                     }
            }
        return [min, max, minID, maxID];
},
getMaxRangeDetails: function(id, table){ return [-1, -1, ""]; },
getTimeMs: function(date){ return new GlideScheduleDateTime(date).getMS(); },
getTimeObject: function(timeMS) { 
  var gdt = new GlideDateTime(); 
  gdt.setNumericValue(timeMS); 
  return gdt; },
logMessage: function(message){ gs.log(message); },
type: 'ExampleUpdateParentsRangeCalculator'
}

ExampleMaxRangeCalculator

Defines the earliest start date and the latest end date for a specified span.

var ExampleMaxRangeCalculator = Class.create();
ExampleMaxRangeCalculator.prototype = {
   initialize: function() { },
   updateParents: function(id, table, startDate, endDate){ },
   getMinRangeDetails: function(id, table){ return [-1, -1, "", ""]; },
   getMaxRangeDetails: function(id, table){
      if (table == "rm_sprint"){
         var sprint = new GlideRecord(table);
         sprint.addQuery('sys_id', id);
         sprint.query();
         if (sprint.next())
            releaseID = sprint.release + "";
         if (releaseID) {
            var now_GR = new GlideRecord("rm_release_scrum");
            gr.addQuery("sys_id", releaseID);
            gr.query();
            if (gr.next())
               return [this.getTimeMs(gr.start_date),
                this.getTimeMs(gr.end_date), gr.sys_id];
         }
      }
      return [-1, -1, ""];
   },
   getTimeMs: function(date){ return new ScheduleDateTime(date).getMS(); },
   getTimeObject: function(timeMS) { 
     var gdt = new GlideDateTime();
     gdt.setNumericValue(timeMS); 
     return gdt; },
   logMessage: function(message){ gs.log(message); },
   type: 'ExampleUpdateParentsRangeCalculator'
}

Use the following two functions to obtain the correct start and end dates in the three example script includes provided for reference.

getTimeMs: function(date){
        return new ScheduleDateTime(date).getMS();
    }

getTimeObject: function(timeMS) {
        var gdt = new GlideDateTime();
        gdt.setNumericValue(timeMS);
        return gdt;
    }