Calculating logged time to include linked tickets from other projects

Question

Two Jira projects: one client/business, other software.

Support and various other client-related tasks are tracked on the client project. If a code change is required in the platform then this results in a linked ticket in the software project. Dev logs their hours under the software project.

We have the Timetracker plugin from EverIT.

Accounting now wants a report showing all hours related to the client which includes dev time to the platform from the linked tickets.

I'm sure this has been done before, I wasn't successful in finding an example.

Any thoughts/recommendations?

Yevgen Lasman_v96izq · Answer

If you would use Power Custom Fields or Power Scripts the code is even simpler (you may remove issue for custom field as it will be in the current issue context already):

interval total_worklog = %issue%.timeSpent;

for(string i in getLinkedIssues(issue)){
    total_worklog += %i%.timeSpent;
}

And getLinkedIssues method has other options where you can adjust particular linking type and/or direction.

Bjoern Veith · Answer

I have to admit I didn't understand your current architecture to 100.

But to sum up the hours there are various options.

Use an addon to retrieve the logged hours from the linked issued and post them on the main issue. You may already have an addon which can do this, JMWE, Scriptrunner or Automation for jira will do the job.

Ravi Sagar _Sparxsys_ · Answer

Hi @Chris DeLess

You would need an app to do that at least on server. ScriptRunner for Jira can help you achieve that. Take a look at a similar example here.