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

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.

2 answers

1 accepted

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>

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

 

 

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

226 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you