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; } } }

What would be the best way to get a cummulated work log summary

Christian Schlaefcke

Hi,

one of my company s PO asked me if there is a way to sum up all efforts for a certain epic and all linked stories and sub-tasks.

I searched in the report area of the projects but there are only reports on a user or version basis available. I also tried to find a plugin but found nothing obviuos. I know I could probably do with JQL and MS Excel export, but the PO definetely wants an integrated solution.

We are using Jira Agile and Tempo. I hope that somebody can point me in the right direction. Any help is very appreciated.

Best Regards,

Christian

Accepted answers

Christian Schlaefcke

Hi All,

I actually found a solution myself. I played around with the Script Runner Plugin/Scripted Custom Field - thank you Jamie for this Swiss Army Knife for JIRA :-)

I just wrote a script that crawls over a specific link type ("has Story") linked issues and their sub tasks summing up the time spent fields if any work logs have been provided.

It is a little bit hard-coded at the moment so there still is room for improvement:

import com.atlassian.jira.ComponentManager

def componentManager = ComponentManager.getInstance()
def issueLinkManager = componentManager.getIssueLinkManager()

def totalTimeSpent = 0

def resultHTML = "&lt;ul&gt;"

def epicTimeSpentString = "No Work Logs"
def epicTimeSpent = issue.timeSpent
if(epicTimeSpent) {
    epicTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(epicTimeSpent)
    totalTimeSpent += epicTimeSpent
}
resultHTML += "&lt;li&gt;&lt;b&gt;This " + issue.issueTypeObject.name + ": " + epicTimeSpentString + "&lt;/b&gt;&lt;/li&gt;"

if(issue.getSubTaskObjects().size &gt; 0) {
    resultHTML += "&lt;ul&gt;"
    issue.getSubTaskObjects().each {epicSubTask -&gt;
        def epicSubTaskTimeSpentString = "No Work Logs"
        def epicSubTaskTimeSpent = epicSubTask.timeSpent
        if(epicSubTaskTimeSpent) {
            epicSubTaskTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(epicSubTaskTimeSpent)
            totalTimeSpent += epicSubTaskTimeSpent
        }
        resultHTML += "&lt;li&gt;" + epicSubTask.issueTypeObject.name + " - " + epicSubTask.key + " - " + epicSubTask.summary + " - &lt;b&gt;" + epicSubTaskTimeSpentString + "&lt;/b&gt;&lt;/li&gt;"
    }
    resultHTML += "&lt;/ul&gt;"
}

issueLinkManager.getOutwardLinks(issue.id).each {issueLink -&gt;
    if (issueLink.issueLinkType.name == "Epic to User Story") {
        def linkedIssue = issueLink.destinationObject
        def linkedIssueTimeSpent = linkedIssue.timeSpent
        def linkedIssueTimeSpentString = "No Work Logs"
        if(linkedIssueTimeSpent) {
            linkedIssueTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(linkedIssueTimeSpent)
            totalTimeSpent += linkedIssueTimeSpent
        }
        //resultHTML += "&lt;li&gt;" + issueLink.issueLinkType.name + " - " +  linkedIssue.key + " - " + linkedIssueTimeSpentString +"&lt;br/&gt;&lt;/li&gt;"
        resultHTML += "&lt;li&gt;" + linkedIssue.issueTypeObject.name + " - " +  linkedIssue.key + " - " + linkedIssue.summary + " - &lt;b&gt;" + linkedIssueTimeSpentString +"&lt;/b&gt;&lt;/li&gt;"

        if(linkedIssue.getSubTaskObjects().size &gt; 0) {
            resultHTML += "&lt;ul&gt;"
            linkedIssue.getSubTaskObjects().each {linkedIssueSubTask -&gt;
                def linkedIssueSubTaskTimeSpentString = "No Work Logs"
                def linkedIssueSubTaskTimeSpent = linkedIssueSubTask.timeSpent
                if(linkedIssueSubTaskTimeSpent) {
                    linkedIssueSubTaskTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(linkedIssueSubTaskTimeSpent)
                    totalTimeSpent += linkedIssueSubTaskTimeSpent
                }
                resultHTML += "&lt;li&gt;" + linkedIssueSubTask.issueTypeObject.name + " - " + linkedIssueSubTask.key + " - " + linkedIssueSubTask.summary + " - &lt;b&gt;" + linkedIssueSubTaskTimeSpentString + "&lt;/b&gt;&lt;/li&gt;"
            }
            resultHTML += "&lt;/ul&gt;"
        }
    }
}

resultHTML += "&lt;/ul&gt;&lt;br/&gt;"

def totalTimeSpentString = totalTimeSpent ? componentManager.getJiraDurationUtils().getFormattedDuration(totalTimeSpent) : "No Work Logs"
resultHTML += "&lt;h4&gt;" + totalTimeSpentString + "&lt;/h4&gt;"

return resultHTML

I use two variants of this full output script to just provide a formatted string with the calculated sum and a plain number output so that further calculations are possible with escel exports.

I realize that this could produce a lot of output for complex relationships (one epic with a lot of stories and a lot of sub tasks) and that this could be quite permormance consuming. But in general it is doing what was requested and I will have an eye on performance issues. My PO is happy now :-)

Please feel free to re-use and let me know of any improvements! :-)

Best Regards,

Christian

All comments

Christian Schlaefcke

Ah - and the Script Runner Plugin is also available ;-)

Christian Schlaefcke

Hi All,

I actually found a solution myself. I played around with the Script Runner Plugin/Scripted Custom Field - thank you Jamie for this Swiss Army Knife for JIRA :-)

I just wrote a script that crawls over a specific link type ("has Story") linked issues and their sub tasks summing up the time spent fields if any work logs have been provided.

It is a little bit hard-coded at the moment so there still is room for improvement:

import com.atlassian.jira.ComponentManager

def componentManager = ComponentManager.getInstance()
def issueLinkManager = componentManager.getIssueLinkManager()

def totalTimeSpent = 0

def resultHTML = "&lt;ul&gt;"

def epicTimeSpentString = "No Work Logs"
def epicTimeSpent = issue.timeSpent
if(epicTimeSpent) {
    epicTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(epicTimeSpent)
    totalTimeSpent += epicTimeSpent
}
resultHTML += "&lt;li&gt;&lt;b&gt;This " + issue.issueTypeObject.name + ": " + epicTimeSpentString + "&lt;/b&gt;&lt;/li&gt;"

if(issue.getSubTaskObjects().size &gt; 0) {
    resultHTML += "&lt;ul&gt;"
    issue.getSubTaskObjects().each {epicSubTask -&gt;
        def epicSubTaskTimeSpentString = "No Work Logs"
        def epicSubTaskTimeSpent = epicSubTask.timeSpent
        if(epicSubTaskTimeSpent) {
            epicSubTaskTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(epicSubTaskTimeSpent)
            totalTimeSpent += epicSubTaskTimeSpent
        }
        resultHTML += "&lt;li&gt;" + epicSubTask.issueTypeObject.name + " - " + epicSubTask.key + " - " + epicSubTask.summary + " - &lt;b&gt;" + epicSubTaskTimeSpentString + "&lt;/b&gt;&lt;/li&gt;"
    }
    resultHTML += "&lt;/ul&gt;"
}

issueLinkManager.getOutwardLinks(issue.id).each {issueLink -&gt;
    if (issueLink.issueLinkType.name == "Epic to User Story") {
        def linkedIssue = issueLink.destinationObject
        def linkedIssueTimeSpent = linkedIssue.timeSpent
        def linkedIssueTimeSpentString = "No Work Logs"
        if(linkedIssueTimeSpent) {
            linkedIssueTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(linkedIssueTimeSpent)
            totalTimeSpent += linkedIssueTimeSpent
        }
        //resultHTML += "&lt;li&gt;" + issueLink.issueLinkType.name + " - " +  linkedIssue.key + " - " + linkedIssueTimeSpentString +"&lt;br/&gt;&lt;/li&gt;"
        resultHTML += "&lt;li&gt;" + linkedIssue.issueTypeObject.name + " - " +  linkedIssue.key + " - " + linkedIssue.summary + " - &lt;b&gt;" + linkedIssueTimeSpentString +"&lt;/b&gt;&lt;/li&gt;"

        if(linkedIssue.getSubTaskObjects().size &gt; 0) {
            resultHTML += "&lt;ul&gt;"
            linkedIssue.getSubTaskObjects().each {linkedIssueSubTask -&gt;
                def linkedIssueSubTaskTimeSpentString = "No Work Logs"
                def linkedIssueSubTaskTimeSpent = linkedIssueSubTask.timeSpent
                if(linkedIssueSubTaskTimeSpent) {
                    linkedIssueSubTaskTimeSpentString = componentManager.getJiraDurationUtils().getFormattedDuration(linkedIssueSubTaskTimeSpent)
                    totalTimeSpent += linkedIssueSubTaskTimeSpent
                }
                resultHTML += "&lt;li&gt;" + linkedIssueSubTask.issueTypeObject.name + " - " + linkedIssueSubTask.key + " - " + linkedIssueSubTask.summary + " - &lt;b&gt;" + linkedIssueSubTaskTimeSpentString + "&lt;/b&gt;&lt;/li&gt;"
            }
            resultHTML += "&lt;/ul&gt;"
        }
    }
}

resultHTML += "&lt;/ul&gt;&lt;br/&gt;"

def totalTimeSpentString = totalTimeSpent ? componentManager.getJiraDurationUtils().getFormattedDuration(totalTimeSpent) : "No Work Logs"
resultHTML += "&lt;h4&gt;" + totalTimeSpentString + "&lt;/h4&gt;"

return resultHTML

I use two variants of this full output script to just provide a formatted string with the calculated sum and a plain number output so that further calculations are possible with escel exports.

Please feel free to re-use and let me know of any improvements! :-)

Best Regards,

Christian

Administrator_ahed0x

This might excatly what i was looking for. I try it out and give you some feedback how it worked for me.

Any chance you could post your second variant? Since i am lazy ;-)

Felix Gebhard1

Hi Riad,

this would be the version with the plain number:

import com.atlassian.jira.ComponentManager

import java.text.DecimalFormat

def componentManager = ComponentManager.getInstance()
def issueLinkManager = componentManager.getIssueLinkManager()

def totalTimeSpent = 0.0d

def epicTimeSpent = issue.timeSpent
if(epicTimeSpent) {
    totalTimeSpent += epicTimeSpent
}

if(issue.getSubTaskObjects() != []) {
    issue.getSubTaskObjects().each {epicSubTask -&gt;
        def epicSubTaskTimeSpent = epicSubTask.timeSpent
        if(epicSubTaskTimeSpent) {
            totalTimeSpent += epicSubTaskTimeSpent
        }
    }
}

if(issueLinkManager.getOutwardLinks(issue.id) != []) {
    issueLinkManager.getOutwardLinks(issue.id).each {issueLink -&gt;
        if (issueLink.issueLinkType.name == "Epic to User Story") {
            def linkedIssue = issueLink.destinationObject
            def linkedIssueTimeSpent = linkedIssue.timeSpent
            if(linkedIssueTimeSpent) {
                totalTimeSpent += linkedIssueTimeSpent
            }

            //if(linkedIssue.getSubTaskObjects().size &gt; 0) {
            if(linkedIssue.getSubTaskObjects() != []) {
                linkedIssue.getSubTaskObjects().each {linkedIssueSubTask -&gt;
                    def linkedIssueSubTaskTimeSpent = linkedIssueSubTask.timeSpent
                    if(linkedIssueSubTaskTimeSpent) {
                        totalTimeSpent += linkedIssueSubTaskTimeSpent
                    }
                }
            }
        }
    }
}

if(totalTimeSpent &gt; 0) {
    totalTimeSpent = totalTimeSpent / 60.0d / 60.0d / 8.0d //Seconds to Hours
}

//formatNumber(number: totalTimeSpent, Locale.ENGLISH, format: '##0.0')
//new DecimalFormat("#.#").format(totalTimeSpent);

totalTimeSpent

Please keep in mind that this can cause high load on your jira instance - so handle with care! Meanwhile I would recomment evaluating the Structure-Plugin or EazyBI.

Kind Regards,

Christian

Christian Schlaefcke

Hi Riad,

this would be the version with the plain number:

import com.atlassian.jira.ComponentManager

import java.text.DecimalFormat

def componentManager = ComponentManager.getInstance()
def issueLinkManager = componentManager.getIssueLinkManager()

def totalTimeSpent = 0.0d

def epicTimeSpent = issue.timeSpent
if(epicTimeSpent) {
    totalTimeSpent += epicTimeSpent
}

if(issue.getSubTaskObjects() != []) {
    issue.getSubTaskObjects().each {epicSubTask -&gt;
        def epicSubTaskTimeSpent = epicSubTask.timeSpent
        if(epicSubTaskTimeSpent) {
            totalTimeSpent += epicSubTaskTimeSpent
        }
    }
}

if(issueLinkManager.getOutwardLinks(issue.id) != []) {
    issueLinkManager.getOutwardLinks(issue.id).each {issueLink -&gt;
        if (issueLink.issueLinkType.name == "Epic to User Story") {
            def linkedIssue = issueLink.destinationObject
            def linkedIssueTimeSpent = linkedIssue.timeSpent
            if(linkedIssueTimeSpent) {
                totalTimeSpent += linkedIssueTimeSpent
            }

            //if(linkedIssue.getSubTaskObjects().size &gt; 0) {
            if(linkedIssue.getSubTaskObjects() != []) {
                linkedIssue.getSubTaskObjects().each {linkedIssueSubTask -&gt;
                    def linkedIssueSubTaskTimeSpent = linkedIssueSubTask.timeSpent
                    if(linkedIssueSubTaskTimeSpent) {
                        totalTimeSpent += linkedIssueSubTaskTimeSpent
                    }
                }
            }
        }
    }
}

if(totalTimeSpent &gt; 0) {
    totalTimeSpent = totalTimeSpent / 60.0d / 60.0d / 8.0d //Seconds to Hours
}

//formatNumber(number: totalTimeSpent, Locale.ENGLISH, format: '##0.0')
//new DecimalFormat("#.#").format(totalTimeSpent);

totalTimeSpent

Please keep in mind that this can cause high load on your jira instance - so handle with care! Meanwhile I would recomment evaluating the Structure-Plugin or EazyBI.

Kind Regards,

Christian

Administrator_ahed0x

Btw: Worked for me except that our Epic Links have different name. So i had to use the line

issueLink.issueLinkType.name == "Epic-Story Link"

Administrator_ahed0x

Uh Thanks very much that was fast.

Yeah i figured that this link traversing might have performance issues. But having to count the worklog manually is a even bigger performance issue ;-)

Christian Schlaefcke

Perfect! I am glad this helped you! :-)

Christian Schlaefcke

Perfect! I am glad this helped you! :-)

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration