Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Time tracking based on Assignee Edited

Hi, I need help in JQL query for time tracking by asignee per sprint or per project.

2 answers

1 accepted

0 votes
Answer accepted

Hello Hitesh,

Welcome to Atlassian community.

I understand that you would like to create a JQL query that will display issues time tracking ordered first by Assignee and second by Sprint/project. Is that correct?

If I have properly understood it, you can do the steps below:

- Go to your issue navigator > Select List view > Add the columns you want for your view (Time tracking fields, assignee, Sprints, etc)

- Then, add the following query to in the filter bar (Advanced mode):

ORDER BY assignee ASC, sprint ASC

Your issues will be ordered by its assignee and by their Sprints:

Screen Shot 2019-04-23 at 16.17.36.png

Let me know if this information helps.

Hi Petterson,

Thanks for your help. That works.

Like Petter Gonçalves likes this

Also Petterson, I am stuck in confluence where i am trying to pull up project portfolio dashboard based on the individual status reports created along with labels. Would you be able to help me? I can provide you more details.

Hello Hitesh,

I'm glad to know I was able to help you.

In order to get better visibility for the other people on Community so they can also help you with this, I suggest you open a new question regarding the Confluence issue that you are facing with all the details you can provide.

Just make sure you are not providing any confidential data since the community is a public channel.

Have a nice day. :)

Hello, I would suggest TMetric as this time tracking software was specially designed for remote teams, developers and freelancers so there is an option of tracking by assignee.  

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,430 views 22 32
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you