Who assigned to who?

[Deborah Cross]

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. 

[Deborah Cross]

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

[Jobin Kuruvilla [Adaptavist]]

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.

[Deborah Cross]

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?

[Jobin Kuruvilla [Adaptavist]]

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.

[Deborah Cross]

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  

[Meck]

Deborah, 

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