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.
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
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?
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
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG