silJQL - Return All Issues Where Work Logged Exceeds Estimate

Scenario

• "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

1. You have Jira Core or Jira Software installed

2. You have Power Scripts™ for Jira installed

3. 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.

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).

key in silJQLList("silJQL_LoggedGreaterThanEstimate.sil", "PROJ")