Page Comparison

Create a Calculated (scripted) Date custom field type, Sprint End Date, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula in the editor

for (Object sprint : issue.get("Sprint")) {
  if (sprint.isActive())
    return sprint.getEndDate().toDate();
}

Click on “Save”

Add this field in the statistics gadgets

Create a Calculated (scripted) Date/Time custom field type, Probable resolution, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula in the editor

Click on Save.

Click on Edit Date Format and select DATE_TIME_PICKER.

Click on Save.

Create a Calculated (scripted) Date/Time custom field type, Sprint end date from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula in the editor

for (Object sprint : issue.get("Sprint")) {
  if (sprint.isActive())
    return sprint.getEndDate().toDate();
} 

Click on Save.

Click on Edit Date Column Format and select RELATIVE.

Click on Save.

Create a Calculated (scripted) Duration custom field type, Open since, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy formula and write the following formula.

return ((new Date()).getTime() - issue.created.getTime())/1000L

Click on Save.

Create a Calculated (scripted) Duration custom field type, Flagged since, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy formula and write the following formula.

if(issue.get("Flagged")){
  return (new Date().getTime() - issue.getFieldHistory("Flagged").last().created.getTime())/1000L
}
else{
  return null
}

Click on Save.

Create a Calculated (scripted) duration custom field type, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

if(issue.get("resolutiondate") == null){
  return null
}
return issue.get("resolutiondate") - issue.get("created")

Click on Save.

Create a Calculated (scripted) Duration custom field type, Due change, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

import java.text.SimpleDateFormat;

Date curDueDate = issue.get("duedate");
if (curDueDate == null)
  return null;

if (issue.getFieldHistory("duedate").size() == 0)
    return null;
oldVal = issue.getFieldHistory("duedate")[-1].getFrom()

if (oldVal==null)
 return null;

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date oldDueDate = sdf.parse(oldVal);
return (curDueDate.getTime() - oldDueDate.getTime())/1000L;

Click on Save.

Create a Calculated (scripted) Duration custom field type: Total Original Estimate, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula.

def totalOE = 0
	issue.getStories().each{
    totalOE += it.get("timeoriginalestimate",0)   
}
return totalOE

Click on Save.

Select the Duration in the configuration as Duration (Time Tracking Format)

Create a Calculated (scripted) Number custom field type: Total Remaining Estimate, from the Custom fields administration page.

Click on Configure.

Click on Edit Groovy Formula and write the following formula.

def totalRE = 0
issue.getStories().each{
    totalRE += it.get("timeestimate",0)    
}
return totalRE

Click on Save.

Select the Duration in the configuration as Duration (Time Tracking Format)

Create a Calculated (scripted) Multi-select custom field type, "Access to" from the Custom fields administration page.

Click on Configure

Click on Edit Options

Add the options to the custom field.

Click on Edit Groovy Formula and write the following formula.

if(issue.get("New user")== null)
return null
def user = issue.get("New user")
def roles = []
def project = issue.get("project")
if(user.isInProjectRole("Customer Support",project)){
  roles += "Jira Service Desk"
}
if(user.isInProjectRole("Document writer",project)){
  roles += "Confluence"
}
if(user.isInProjectRole("Project Manager",project)){
  roles += "Jira Software"
}
return roles

Click on Save.

Create a Calculated (scripted) Number custom field type: Total Stories, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula.

if (issue.stories){
  return issue.getStories().size() 
}
else{
  return 0
}

Click on Save.

Create a Calculated (scripted) Number custom field type: Number of Blocking Issues, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

return issue.getLinkedIssues("is blocked by").findAll{
  it.get("resolution") == null
}.size() 

Click on Save.

Create a Calculated (scripted) Number custom field type, Expected Delivery Date updated, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

return issue.getFieldHistory("Expected Delivery Date").size() 

Click on Save.

Create a Calculated (scripted) Number custom field type, Link count, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula.

def issues = issue.getLinkedIssues("Interface")
return issues.findAll{
  it.getSourceObject().get("versions")*.name.contains("Platform")
}.size()

Click on Save.

Create a Calculated (scripted) Single-select custom field type:

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

import com.google.common.net.InternetDomainName;
import java.net.URL;
import org.apache.commons.validator.routines.UrlValidator;

if (issue.get("URL field")==null)
return null;

def urlString = issue.get("URL field")
def urlValidator = new UrlValidator()
if(urlValidator.isValid(issue.get("URL field")) == false)
return null;

def url = new URL(urlString)
def host = url.getHost()
def name = InternetDomainName.from(host).topPrivateDomain();
return name.parts()[0].toUpperCase()

Click on Save.

Click on Edit Velocity template and write the following template

#if ($value == "AMAZON")
	<img src='https://images-na.ssl-images-amazon.com/images/I/31YAf-cs2oL._AC_UL160_.jpg'  width=30px >$value
#elseif ($value == "MYNTRA")
	<img src='https://images-na.ssl-images-amazon.com/images/I/31YAf-cs2oL._AC_UL160_.jpg'  width=30px >$value
#else
	return $value
#end

Create a Calculated (scripted) Single-user custom field type: Last Commented by, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula.

if(issue.get("comment")){
  return issue.get("comment").last().authorApplicationUser
}
else{
  return null
}

Click on Save.

Create a Calculated (scripted) Single-user custom field type: Last Modified by, from the Custom fields administration page.

Click on Configure

Click on Edit Groovy Formula and write the following formula.

def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def changeItems = changeHistoryManager.getAllChangeItems(issue)
 
if (changeItems?.size() > 0) {
def userManager = ComponentAccessor.getUserManager() ;
def userkey = changeItems.sort(false).last().getUserKey();
userManager.getUserByKey(userkey);
} else {
null
}

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Last comment details, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

if(issue.get("comment")){
  return "Comment body: " + issue.get("comment").last().getBody() + "\n" +
    "Comment Author: " + issue.get("comment").last(). getAuthor() + "\n" + "Comment timestamp: " + issue.get("comment").last().getUpdated()
}
else{
  return null
}

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Blocking issues, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

return issue.getLinkedIssues("is blocked by").findAll{
  it.get("status").name!= "Resolved" || it.get("status").name!= "Closed"
}*.key.join(",")

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Previous Due dates, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

def dueDates = ""
issue.getFieldHistory("duedate").each{
  if(it.getFrom()){
    dueDates += it.getFrom() + "\n"
  }
}
return dueDates

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Daily estimates, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

import org.apache.commons.lang.StringUtils;
import java.text.SimpleDateFormat;
 
dateStrings = new ArrayList();
dateFormat = new SimpleDateFormat("yyyy-MM-dd");
 
dueDate = issue.get("duedate");
estimate = issue.get("timeoriginalestimate");
 
if (dueDate != null && estimate != null && estimate > 0) {
  calendar = Calendar.getInstance();
  calendar.setTime(dueDate);
  hours = estimate / 3600.0;
 
  while (hours > 0) {
    dateHours = hours > 8 ? 8 : hours;
    dateStrings.add(
      dateFormat.format(calendar.getTime()) + "," +
      String.valueOf(dateHours) + " hours"
    );
    hours -= dateHours;
    calendar.add(Calendar.DATE, -1);
    if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY)
    	calendar.add(Calendar.DAY_OF_MONTH, -1)
    if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY)
    	calendar.add(Calendar.DAY_OF_MONTH, -1)
  }
}
 
if (dateStrings.isEmpty()) return null;
return StringUtils.join(dateStrings, "\n");

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Location, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

def currentUserProps = ComponentAccessor.getUserPropertyManager().getPropertySet(issue.get("reporter"));
def metaLoc = currentUserProps.getType("jira.meta.location")
return currentUserProps.getString(metaLoc,"jira.meta.location");

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Comment from John Doe, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

String s = "";
issue.get("comment").each{
  if (it.getAuthorApplicationUser().getName().equals("jdoe")) {
	s += "On "+ it.getCreated().toLocaleString() + " Dashboard meeting.\n";
	s += "Comment by " + it.getAuthorFullName() + ":\n";
    s += it.getBody() + "\n";
  }
}
return s;

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Project Category, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

issue.get("project").getProjectCategoryObject().getName()

Click on Save.

Create a Calculated (scripted) Text/Html custom field type: Flag, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

return issue.get("Flagged")

Click on Save.

Click on Edit Velocity template and write the following template

#if ($value != null)
<div class="ghx-iconfont aui-icon aui-icon-small aui-iconfont-flag">
    $formattedValue
</div>
#else
    $value
#end

Create a Calculated (scripted) Text/Html custom field type: Last comment details, from the Custom fields administration page.

Click on Configure 

Click on Edit Groovy Formula and write the following formula.

if(issue.get("comment")){
  return "Comment body: " + issue.get("comment").last().getBody() + "\n" +
    "Comment Author: " + issue.get("comment").last(). getAuthor() + "\n" + "Comment timestamp: " + issue.get("comment").last().getUpdated()
}
else{
  return null
}

Click on Save.

Create a Last Field Value Change Author custom field type: Moved to Sprint by, from the Custom fields administration page.

Click on Edit Field to look for

Select the Sprint field.

Click on Save

Create a Last Field Value Change Date/Time custom field type: Last Flagged, from the Custom fields administration page.

Click on Edit Field to look for

Select the Flagged field.

Click on Save

Create a Parent Status custom field type: Parent Status field, from the Custom fields administration page.

Click on Edit Velocity Template

Write the following template

#if ($issue.assignee.name)
	$formattedValue and assigned to $issue.assignee.displayName
#else
	$formattedValue
#end

Create a Status entered by user custom field type, First Approved on, from the Custom fields administration page.

Click on Edit Statuse(s) to look for.

Select the Approval status.

Select Earliest from Which transition execution field

Click on Save.

Create a Status entered on date/time custom field type, First Approved on, from the Custom fields administration page.

Click on Edit Statuse(s) to look for.

Select the Approval status.

Select Earliest from Which transition execution field

Click on Save

Create a Time in status custom field type, Time in Pull request, from the Custom fields administration page.

Click on Edit Statuse(s) to look for.

Select the statuses you would like the calculated field to look for.

Click on Save.

Create a Time in status custom field type, Total resolution time, from the Custom fields administration page.

Click on Edit Statuse(s) to look for.

Select In Progress from the list of statuse(s)

Click on Save.

Click on Edit Velocity Template

Write the following template

#if ($value > 252900)
<div class="aui-banner aui-banner-error">
	$formattedValue
</div>
#else
	$formattedValue
#end

Create a Time in status custom field type, Total resolution time, from the Custom fields administration page.

Click on Edit Statuse(s) to look for.

Select Current Status from the list of statuse(s)

Click on Save.

Create a Transition caller custom field type, Last fixed by, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Provide the transition name or ID of the transition to Fixed status, either manually or using the Transition picker

Click on Add.

Click on Save.

Select Latest from the Transition Execution field.

Create a Transition caller custom field type, Last fixed by, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Click on the Transition picker.

Select the workflow name and the transition that leads to the Resolved status

Click on Add

Repeat the same with all the other transitions that lead to Resolved status.

Click on Save.

Select Latest from the Transition Execution field.

Create a Transition Caller Custom field type, Owner from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Provide the Create transition name or ID either manually or using the Transition picker

Click on Add.

Click on Save.

Click on Edit Velocity Template.

Input the following template.

#if ($value)
	$formattedValue - $value.name
#end

Click on Save.

Create a Transition callers custom field type, Approved by, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Select the "Approve" transition using the Transition picker

Click on Add.

Click on Save.

Create a Transition callers custom field type, Reviewed and Approved by, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Select the "Approve" and "Review" transitions using the Transition picker

Click on Add.

Click on Save.

Create a Transition Count Custom field type, Rejected, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Provide the transition name or ID of the transition "Reject" either manually or using the Transition picker

Click on Add.

Click on Save.

Create a Transition Count Custom field type, Revisions, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Provide the transition name or ID of the transition "Needs revision" either manually or using the Transition picker

Click on Add.

Click on Save.

Create a Transition Date/Time Custom field type, Last Approved on, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Provide the transition name or ID either manually or using the Transition picker

Click on Add.

Click on Save.

Select Latest from the Transition Execution field.

Click on Edit Date Format

Select RELATIVE

Click on Save

Create a Transition Date/Time Custom field type, Fix date, from the Custom fields administration page.

Click on Edit Transition(s) to look for.

Click on the Transition picker.

Select the workflow name and the transition that leads to the respective status

Click on Add

Repeat the same with the other transitions of the workflows.

Click on Save.

Select Earliest from the Transition Execution field