Group "User Timesheet" by "Account" and not "Project"

[Evan Stevens]

Is there a way to obtain a view (read-only is fine) of the "user timesheet", user timesheet dashboard widget, or a report that shows the same detail as the user timesheet grouped by Account instead of JIRA project?  Alternatively, is there a way to display the account on each row?

We have Microsoft project server where we must log our time against the projects managed outside the development group.  Our JIRA projects are related to the applications.  Therefore, issues in JIRA projects might relate to a particular project in project server but not all issues in the JIRA project relate to the same project in project server.  I want to find a way for our teams to log time only in JIRA and then copy/paste from a report in JIRA to the project server timesheet.

I'd like to use default reports if possible.  The approach I've taken now is to create an account for the project server project and associate the JIRA issue with the account.  The relationship to JIRA issues works perfectly.  The reports work great for reporting as a project manager but I need a solution for the team member.  I'd like for the team member to fetch this information weekly through the JIRA interface rather than a custom application or excel workbook.  They could use the default "User Timesheet" or user timesheet dashboard widget if it were grouped by account or if the account was displayed on each row.

[Evan Stevens · Accepted solution]

The report mode doesn't display the per-day hours.  I'm sure there's a more elegant way to do this but I got what I needed by placing a custom field on the screen using jQuery in ./atlassian-jira/WEB-INF/classes/templates/plugins/footer/footer.vm:

#set( $D = '$' )
<script>
    AJS.${D}(document).ready(function() {
        /* Add the project name to the tempo timesheet */
        AJS.${D}(".tempo-timesheet-table thead tr, .tempo-timesheet-table tfoot tr").each(function(){ 
            if(AJS.${D}("th.headerrow-summary", this).length > 0){
                // update the "summary" header to also cover the project column
                AJS.${D}("th.headerrow-summary", this).after('<th class="tt-end-of-week padding">Project</th>');
            } else {
                AJS.${D}("th:first", this).attr("colspan", (+AJS.${D}("th:first", this).attr("colspan") + 1));
            }
        });
        
        AJS.${D}(".tempo-timesheet-table tr.log-activity").find("td:eq(2)").attr("colspan", "2").addClass('tt-end-of-week');
        
        // add the project to the issue row
        AJS.${D}('.tempo-timesheet-table tr.log-issue').each(function(){
            var row = this;
            var issueKey = AJS.${D}(this).find("td.issuekey > a").attr('title');
            AJS.${D}.getJSON(AJS.contextPath() + '/rest/api/latest/issue/' + issueKey, function(data){
        //        console.log('Got data for - ' + issueKey);
        //        console.log(data);
                var value = data.fields.customfield_10601;
                if(value == null) value=" "
        //        console.log('Value - ' + value);
                var summary = AJS.${D}(row).find('td.summary');
                AJS.${D}(summary).after('<td class="nav tt-end-of-week">' + value + '</td>');
            });
        /* End - Add the project name to the tempo timesheet */
        });
    });
</script>

[Tempo Support]

Hi Evan

In the User Timesheet it is possible to see account information in the Report mode after choosing the Account column. However the worklogs will not be grouped by account. If you wish to see account grouping within the user timesheet you can create a new feature request within our support channel at: https://tempoplugin.jira.com/browse/JTMPO

For more information on User Timesheet please see: https://tempoplugin.jira.com/wiki/display/TEMPO0712/User+Timesheet

I hope this was helpful.

Best regards,

Heiða Dóra

Tempo Team