Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Problem
"I'm a project manager and want to see all issues in my project where the work logged has exceeded the original estimate"
"I want to be able to understand why our estimates are off and be able to estimate more accurately in the future"
"I want to see which developers routinely exceed expectations and which developers routinely exceed budgets"
We'll show you how to do all of this using Power Scripts™ for Jira, a powerful scripting tool to help automate your Jira.
What These Scripts Do
This is a pretty simple one-scripter. The user provides a project via the advanced JQL search bar, and the script scans all issues, calculates time logged by group for each issue, and compares it to the original estimate. If the work logged is greater than the original estimate, it is returned via JQL.
Prerequisites
You have Jira Core or Jira Software installed
You have Power Scripts™ for Jira installed
Your users are in groups titled "jira-developers" and "jira-administrators". You may need to tweak this for your specific needs.
Copy or Create File in Root silprograms Directory
This is a JQL script that will return all issues that have more work logged than the original estimate for a user-supplied project.
Code Block |
---|
string [] keys = selectIssues("project = " + argv[0]); string [] ret; for(string k in keys) { if(%k%.originalEstimate !="") { interval developerTimeSpent = getTimeSpent(k, "jira-developers"); interval administratorTimeSpent = getTimeSpent(k, "jira-administrators"); interval totalTimeSpent = developerTimeSpent + administratorTimeSpent; if(totalTimeSpent > %k%.originalEstimate) { ret += k; } } } |
Execute the JQL
In the advanced JQL search bar, you would simply type this (and tweak the project key to your specific needs).
Code Block |
---|
key in silJQLList("silJQL_LoggedGreaterThanEstimate.sil", "PROJ") |
Table of Contents
Table of Contents |
---|