Versions Compared

Old Version 8

changes.mady.by.user Cristina Szilágyi

Saved on

compared with

New Version 9

changes.mady.by.user Mark Kleinsmith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

"I'm

As 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 , you may encounter challenges in tracking issues where the logged work exceeds the original estimate. Understanding the reasons behind estimation discrepancies is crucial for future accuracy in project estimation. Additionally, identifying developers consistently surpassing expectations or budgets is essential for effective project management.

    This article guides you through achieving these objectives using Power Scripts™ for Jira, a robust scripting tool designed to automate Jira processes.

    What These Scripts Accomplish

    This script is straightforward. By inputting a project through the advanced JQL search bar, and the script scans all issues, calculates computes time logged by group for each issue, and compares it to the original estimate. If the work logged is greater than exceeds the original estimate, it is returned the script returns the relevant issues via JQL.

    Prerequisites

    1. You Ensure you have Jira Core or Jira Software installedSoftware installed.

    2. You have Power Scripts™ for Jira for Jira should be installedYour users are in groups titled .

    3. Users should be categorized into groups labeled "jira-developers" and "jira-administrators." . You may need to tweak this for Adjustments may be necessary based on your specific needsrequirements.

    Copy or Create File in Root silprograms Directory

    This is a The following JQL script that will return returns all issues that have with 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 simply input and customize the following (adjusting the project key to your specific needs).

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

    Table of Contents

    Table of Contents