Report for time logged using search filter criteria gives wrong results

Question

Purpose : Generate consolidated time spent report for a version for all project team

How i generated report :

Using basic search filter with PROJECT, ALL ITEM TYPE (EPIC, USER STORY, SUB-TASK, TASK, DEFECTS), variable type SUM (time spent), Version (affected version=fixed version) & Project users gives me the data dump of time spent for a release.

Here since it's a flat query, the relation between EPIC > USER STORY > SUB-Task is lost. (Btw we add estimate and time logged for sub-task).

Now when i try to analyze the data, it doesnt show correct details.

Reason : In many scenario, a user story developer works in pair with multiple development members and create a list of tasks based on requirement, so in this case that person becomes a REPORTER and them sub-tasks will be pulled and assigned to respective team members. In such scenario the respective task owners log their efforts and once task is closed, it gets back to the reporter as per jira functionality.

So in report time calculated for logged time goes to the reporter and not to the assignee. This appears to be a culprit in generating precise data for report.

Question :

JIRA DEVELOPMENT TEAM. Is there way to extract data for efforts logged time added by assignee ?

Mayuresh Athalekar · Answer

Thank you for responding.

In my company we are not allowed to install external apps on jira instance. So the app that you have suggested will not be a viable option.

Any pointers about Rest API based approach ?

Trudy P Claspill · Answer

There is not a way to do that through the built in Search functionality in Jira natively.

You could use the Rest API to pull the time logged data for your issues and manipulate the output yourself to group it by the user that logged the time.

Alternately you can use a third-party app to get the information.

I found the Worklogs - Time Tracking and Reports app to be useful for generating reports of time logged per user.