This section has use cases which help you understand the usage of the Calculated fields provided by JMCF.
On this page:
tocThis section has use cases which help you understand the usage of the Calculated fields provided by JMCF.
On this page:
Calculated (scripted) Date custom field type
A Calculated (scripted) Date custom field type represents a java.util.Date
calculated from a Groovy script.
Sample use cases:
Calculate and display the Sprint end date in the statistics
Expand |
---|
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 Code Block |
---|
for (Object sprint : issue.get("Sprint")) {
if (sprint.isActive())
return sprint.getEndDate().toDate();
} |
Click on “Save” Add this field in the statistics gadgets
|
Calculated (scripted) Date/Time custom field type
A Calculated A Calculated (scripted) Date/Time custom field type represents a java.util.Date
and is displayed as date+time.
Sample use cases:
...
Calculate and display the probable date of resolution (excluding weekends) for an issue based on its Priority
...
...
...
Calculate and display the Sprint end date as a relative date in the Issue Navigator.
...
...
Calculated (scripted) Duration custom field type
A Calculated A Calculated (scripted) Duration custom field type represents a represents a duration and is displayed either as a duration string or as a number in a Long format representing the the number of seconds.
Sample use cases:
Calculate and display how many days an issue has been open
...
...
...
Calculate the duration the field has been Flagged
...
|
Create a Calculated (scripted) Duration custom field type, Flagged since, from the Custom fields administration page. Click on Configure Click on Edit Groovy formula
|
...
Calculate and display the number of days from issue creation to resolution in a custom field
...
...
Calculate and display the difference between the current Due date and the last Due date.
...
...
...
. Code Block |
---|
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") |
|
...
...
oldVal==null)
return null;
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date oldDueDate |
|
...
...
return (curDueDate.getTime() - oldDueDate.getTime())/1000L; |
Click on Save .
|
Calculate and display the Total Original Estimate of all the Stories associated to the Epic.
Expand |
---|
|
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. Code Block |
---|
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)
|
Calculate and display the Remaining Estimate of all the Stories associated to the Epic.
...
...
...
...
...
...
...
...
...
timeestimate",0)
}
return |
|
...
...
Calculated (scripted) Multi-select custom field type
A Calculated (scripted) Multi-select custom field type represents a collection of Options and is displayed as a String representing the option values.
Sample use cases:
Calculate and display the access to be provided to the user in a custom field based on the project role the user belongs to.
...
...
...
, "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
|
...
...
Code Block |
---|
def totalRE = 0
issue.getStories().each{
totalRE += it.get("timeestimate",0)
}
return totalRE |
...
Code Block |
---|
| 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.
|
Calculated (scripted) Multi-
...
user custom field type
A A Calculated (scripted) Multi-select user custom field type represents a represents a collection of Options users and is displayed is displayed as a String representing the option values.user display names
Sample use cases:
Calculate and display the
...
assignees of the sub-tasks on the parent issue.
...
...
...
...
on Configure Click on Edit
|
...
...
...
Set users = []
issue.get("subtasks").each{
if(it.assignee)
{
users += it.assignee
}
}
return users |
Click on Save.
|
Calculated (scripted)
...
Number custom field type
A A Calculated (scripted) Multi-user Number custom field type represents represents a collection of users number and is displayed as a String representing the user display namesdisplayed in Double format.
Sample use cases:
...
Calculate the
...
sum of two number field and round off the result
...
...
...
...
...
...
...
(issue.get("customfield_16003") ? issue.get(" |
|
...
customfield_16003") : 0) + (issue.get("customfield_16004") ? issue.get("customfield_16004") : 0)
result == 0?0:result.round() //returns 0 when the result is 0 and rounds off the result when there is a value |
Click on Save .
|
Calculated (scripted) Number custom field type
A Calculated (scripted) Number custom field type represents a number and is displayed in Double format.
Sample use cases:
...
Calculate and display the number of
...
Stories associated to the Epic.
...
...
...
Calculate and display the number of unresolved issues blocking the current issue.
...
|
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. Code Block |
---|
return issue.getLinkedIssues("is blocked by").findAll{
it.get("resolution") == null
}.size() |
Click on Save .
|
Calculate and display the number of times "Expected Delivery Date" has been modified.
...
...
Calculate and display the number of issues linked to the current issue with link type "Interface" and the Affects Version/s "Platform".
...
...
...
Calculated (scripted) Single-select custom field type
A A Calculated (scripted) Single-select custom field type represents an type represents an Option and is displayed as a String representing an Option value.
Sample use cases:
Calculate and display the company name with logo based on the value provided in the text field holding the URL of the company
...
...
Calculated (scripted) Single-user custom field type
A A Calculated (scripted) Single-user custom field type represents an represents an ApplicationUser and is displayed as a String representing the display name of the user.
Sample use cases:
Calculate and display the user who last commented on the issue
...
|
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
|
...
Calculate and display the user who last modified the issue
...
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
|
...
Calculated (scripted) Text/Html custom field type
A A Calculated (scripted) Text/Html custom field displays text calculated using a Groovy script and supporting HTML formatting.
Sample use cases:
Calculate and display the last comment, its author, and timestamp in a text field.
...
...
Calculate and display the current issues' linked
...
issues with "is blocked by" link type
...
and are not in Resolved
or Closed
status.
...
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
|
...
Calculate and display all the previous due dates as comma-separated list with dates in YYYY-MM-DD format.
...
...
Calculate and display estimated hours for each day, using not more than 8 hours per day, until the due date.
...
|
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. Code Block |
---|
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 .
|
Calculate and display the location of the Assignee of the issue from the User properties
...
...
Calculate and display
...
all the comments of a specific user.
...
...
Calculate and display the Project category of the issue's project
...
...
Flag the issue on the issue view screen if the has been flagged.
...
...
Calculated (scripted) Wiki Text custom field type
A A Calculated (scripted) Wiki custom field displays text calculated using a Groovy script and optionally supporting wiki-style formatting.
Sample use cases:
Calculate and display the last comment, its author, and timestamp in a text field without escaping the formatting .
...
...
Last Field Value Change Author custom field type
A Last A Last Field Value change Author custom Author custom field type that represents the author represents the author of the last modification made to a field and is displayed as displayed as a String representing the display name of the user.
Sample use cases:
Calculate and display the author who has last added this issue to a Sprint
...
...
Last Field Value Change Date/Time custom field type
A A Last Field Value Change Date/Time custom field type represents a represents a java.util.Date
and is displayed as date+time.
Sample use cases:
Calculate and display the last time the issue was Flagged.
...
...
Parent Status custom field type
A Parent status calculated custom field type represents type represents the status of the issue's parent issue, if any, and is displayed as a String representing the status name.
Sample use cases:
...
Calculate and display the status of the parent issue and the name of the user to whom the issue is assigned.
...
...
Status entered by user custom field type
A Status entered by user custom field type represents a type represents a user who last (or first) moved the issue to the specified status and is displayed as a String representing the user display name.
Sample use cases:
Calculate and display the author name and the email address of the user who first Approved the issue
...
...
on Edit Statuse(s) to look for. Select the Approval status. Select Earliest from Which transition execution field Click on Save .
|
Status entered on date/time custom field type
A Status entered on Date/Time custom field type represents a type represents a date+time the issue has been last the issue has been last (or first) moved to the specified status and is displayed is displayed as date+time.
Sample use cases:
Calculate and display the date/time an issue entered the Approval status for the first time
...
...
on Edit Statuse(s) to look for. Select the Approval status. Select Earliest from Which transition execution field Click on Save
|
...
Time in status custom field type
A A Calculated Time in status custom field type represents a type represents a duration and is displayed either as a duration String or as a number in a Long format representing the the number of seconds.
Sample use cases:
Calculate and display the time spent in the Pull request status
...
...
Calculate and display the total resolution time for a ticket in an error banner if the time spent is more than 3 days
...
...
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 Code Block |
---|
#if ($value > 252900)
<div class="aui-banner aui-banner-error">
$formattedValue
</div>
#else
$formattedValue
#end |
|
Calculate and display the time spent in current status
...
...
Transition Caller custom field type
A A Transition Caller custom Caller custom field type returns returns the user who first/last executed a specific workflow transition and is and is displayed as a String representing the display name of the user.
Sample use cases:
...
Calculate and display the author who last fixed the issue
...
...
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
|
...
...
Calculate and display the author who has resolved the issue across different workflows with different transitions.
...
...
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
|
...
...
Calculate and display the creator of the issue along with his/her username.
...
...
...
...
Transition Callers custom field type
A A Transition Callers custom Callers custom field type r returns the users who triggered a specific workflow transition and is and is displayed as a String representing the display names of the users.
Sample use cases:
Calculate and display the authors who approved the ticket
...
...
Calculate and display the authors who have Reviewed and Approved the ticket
...
...
Transition Count custom field type
A A Transition Count custom field represents the number custom field represents the number of times a specified workflow transition(s) was executed and is displayed as a number in Double format.
Sample use cases:
...
Calculate and count the number of times an issue fix has been rejected
...
...
Calculate the number of revisions done on a story before moving into development.
...
...
Transition Date/Time custom field type
A A Transition Date/Time custom field type represents type represents a java.util.Date
and is displayed as date+time.
Sample use cases:
Calculate and display the date/time as a relative time when the issue has been last approved.
...
...
...
...
Calculate and display the "Fix date" when an issue is moved to Fixed/Checked-in status for the first time
...
...
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
|
...