Who assigned to who?

I need to generate a report which shows, for every task created in a certain time period, who changed the task from unassigned and who did they first assign it to.

Any ideas? Not even sure where to start with this one!!!

It should be in the task history, but how would I access that to generate a report.

Happy to do number crunching and such in excel if I can get something exportable. 

3 answers


I never hear about a native solution to your needs. :/ But I think you are trying track the life time of issue per user. Right? So...

The Tempo Timesheet is a plugin to things like that. Did you see it? https://marketplace.atlassian.com/plugins/is.origo.jira.tempo-plugin/cloud/overview

And I found a huge discussion about a similar topic https://answers.atlassian.com/questions/51270

0 votes

assignee field support history searching, to an extent. For example, you can write the following JQL:

assignee changed from ABC to XYZ by POR after -20d

This will get you all issues where assignee was changed from ABC to XYZ by PQR in the last 20 days. The catch is that it will get you results irrespective of how many times that change happened. But that should be alright for many cases.

You can modify the duration and use it along with other available clauses to narrow down the result set.

Thanks Jobin, I think that would be achievable, since it is only 3 assignees which I really need to target. I can do a report for each.

One problem I'm having is being unable to search for assignee = unassigned. Any tips on the syntax for that? Where it was changed from unassigned to person X by person Y?

How about this?

assignee was EMPTY and assignee changed to ABC

You can use the other clauses like AFTER, BEFORE, BY etc along with this.

Thanks Jobin, that's the conclusion I came to as well (Assignee was EMPTY).

It's not 100% because it picks up results where it was changed from unassigned to assigned to person x and then assigned again to person Y, but it is near enough for the purpose this report is being used for.

Thanks for being so helpful smile 

Thanks for your help, but I'm looking to report on assignee/status changes, not time. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,752 views 18 21
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