Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the "Time Tracking Report" using a custom JQL filter and no additional plugin?

carlos_marin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 6, 2021

Hi,

 

Is there a way to get a report like the "Time Tracking Report" but using a custom JQL filter with the jira native support? (no additional plugins)

Currently, the "Time Tracking Report" only ise the "Fix version" field.

 

Best regards,

1 answer

3 votes
Brant Schroeder
Community Champion
February 9, 2022

@carlos_marin 

You would need a time tracking app for that.  You can view the different apps in the marketplace here: https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=time%20tracking

Neelanjan Sinha
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 16, 2023

I am looking for a JQL which gives me Time Spent by user per ticket across all projects. Is this possible? I can't access third-party apps for my organization access restrictions.

e.g. I want a table with following columns. (I say user, not assignee, because Multiple users are working on a same issue many times. I can run a query per assignee but it gives total time spent (sum of work logged by multiple users) per issue).

I want something like following:

Key    Summary     User        Time Spent

X-11   Issue1          user1       20m

X-11   Issue1          user2       30m

X-22   Issue2          user1       30m

X-22   Issue2          user3       15m

 

Thank you.

Brant Schroeder
Community Champion
January 17, 2023

@Neelanjan Sinha You will need an app to get that information.  JQL will only return the sum of the time on the issue.

Gracjan Wesołowski _HeroCoders_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 18, 2023

Hi @Neelanjan Sinha

if in the future you would consider using third-party apps I can recommend you our Clockwork Automated Time Tracking & Timesheets Free app.

It suits perfectly for your use case, as it allows you to view time spent in the Timesheet in a quite similar way as your example using break-down, and filtering options. Please see the example below:CLK_communitty.PNG

If you have any questions you can contact us via our help center.

Cheers!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events