nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA tally all logged work from linked issues and sub tasks to single issue

jeff singler

I have tried several different groovy script methods form various examples as I am not a coder, but have come close but no real success. I have thrown my hands up and am wondering if some smart person out there knows how to do this.

I simply need to show all total work logged for a specific link type of parent issues and their sub tasks to a single issue as a grand total. See diagram. Untitled Diagram.png

Accepted answers

Radek Dostál

When you say groovy script methods it's a bit ambiguous what you are trying to do exactly, but, if I understood this right I've set it up with a Script Field which fingers crossed gets you closer.

This seems to work in my tests and I'm getting expected values on the Asset Record in your pic:

// Template: Duration (either of the 2)

import com.atlassian.jira.component.ComponentAccessor

def issueLinkmanager = ComponentAccessor.getIssueLinkManager()
def subtaskManager = ComponentAccessor.getSubTaskManager()
def workLogManager = ComponentAccessor.getWorklogManager()

def linkName = "Work"


def linkCollection = issueLinkmanager.getLinkCollectionOverrideSecurity(issue)
def linkedIssues = linkCollection?.getOutwardIssues(linkName) //Inward or Outward? Verify and change if needed.

if (!linkedIssues) {
    // no linked issues
    return null
}

def totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks = []

for (def linkedIssue:linkedIssues) {
def worklogList = workLogManager.getByIssue(linkedIssue)
for (def worklog:worklogList) {
def timeSpent = worklog.getTimeSpent()
        totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks.add(timeSpent)
    }

def subTasks = subtaskManager.getSubTaskObjects(linkedIssue)
for (def subTask:subTasks) {
def worklogListSubTask = workLogManager.getByIssue(subTask)
for (def worklogSubTask:worklogListSubTask) {
def timeSpent = worklogSubTask.getTimeSpent()
            totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks.add(timeSpent)
        }
    }
}

return totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks?.sum()

All comments

Radek Dostál

When you say groovy script methods it's a bit ambiguous what you are trying to do exactly, but, if I understood this right I've set it up with a Script Field which fingers crossed gets you closer.

This seems to work in my tests and I'm getting expected values on the Asset Record in your pic:

// Template: Duration (either of the 2)

import com.atlassian.jira.component.ComponentAccessor

def issueLinkmanager = ComponentAccessor.getIssueLinkManager()
def subtaskManager = ComponentAccessor.getSubTaskManager()
def workLogManager = ComponentAccessor.getWorklogManager()

def linkName = "Work"


def linkCollection = issueLinkmanager.getLinkCollectionOverrideSecurity(issue)
def linkedIssues = linkCollection?.getOutwardIssues(linkName) //Inward or Outward? Verify and change if needed.

if (!linkedIssues) {
    // no linked issues
    return null
}

def totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks = []

for (def linkedIssue:linkedIssues) {
def worklogList = workLogManager.getByIssue(linkedIssue)
for (def worklog:worklogList) {
def timeSpent = worklog.getTimeSpent()
        totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks.add(timeSpent)
    }

def subTasks = subtaskManager.getSubTaskObjects(linkedIssue)
for (def subTask:subTasks) {
def worklogListSubTask = workLogManager.getByIssue(subTask)
for (def worklogSubTask:worklogListSubTask) {
def timeSpent = worklogSubTask.getTimeSpent()
            totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks.add(timeSpent)
        }
    }
}

return totalTimeSpentFromWorkLinkedIssuesAndTheirSubtasks?.sum()

jeff singler

You're a genius, that worked like a charm. No more head pounding. Thank you so much, here is a virtual beer on me!

jeff singler

Also yes, we are using scriptrunner using a scripted field.

Connie H Johnston

I've very interested in using this script however; I would like to be able to restrict the number of issues searched with a JQL query so that the entire instance is not searched. Any suggestions??

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server