How to find the initial assignee of a bug

[Chethana Hashani]

Hi all,

We have few projects and many resources are working on those projects. I need to create a report to track how many bugs are captured for each developer (to evaluate their development performance). In the current process, my QA team test the system, log bugs and assign them to relevant developer who is responsible for that bug. But because of tide time lines, we shift those tasks among other developers as well. But I need to track who is actually responsible for a particular bug. So is there a way to get the initial assignee of a jira ticket

[Deleted user · Accepted solution]

Hi @Chethana Hashani,

As far as I am aware it is not possible to achieve this via JQL. You will need to look for an add-on to achieve this however I have not been able to achieve this myself either.

Only way to view this information in Jira  from a normal user's perspective is to view the issue's change history. 

There are other questions related to this topic which may be of help to you: 

https://community.atlassian.com/t5/Jira-Core-questions/get-first-assignee/qaq-p/88371

The above is able to achieve this with an add-on though you will have to modify it to align with your requirements. 

https://community.atlassian.com/t5/Jira-questions/how-to-find-the-first-assignee-on-jira-issue/qaq-p/454946

The above delves into the reasons why.

https://community.atlassian.com/t5/Jira-questions/JQL-Question-Assignee-WAS-IN-quot-user1-quot-quot-user2-quot/qaq-p/67554  

The above uses JQL however it is very limited. 

Hope this helps

[Chethana Hashani]

Hi Danny,

Thanks for the help!

Cheers,

Hansi

[Deleted user]

Hi @Chethana Hashani,

If this answers your question please mark it as solved. It helps others within the community to find solutions to similar questions.

Have a great day Hansika :) 

[Tracy Kaonje]

status was "In Progress" by (membersOf("Group Name")) AND Project = Project short code

This will kind of get the data

[Viney Sharma]

It's showing an error while executing this query.

[Warren]

Hi Hansika

If you (or someone that you work with) is able to do a bit of coding, you could get this from the REST API. Essentially you would be looking at the change history (as @[deleted] has said) via the API and you could then get the first assignee.

[Chethana Hashani]

Hi Wrren,

I have a guy who can do coding a bit. So can you guide me about the start point at where I should initiate this development

Cheers,

Hansi

[Warren]

Here is the cloud API document, although I don't believe that there's much difference for the server API. See my answer here on how to set up a C# API.

When you get the list of issues from the API, use the parameter

?expand=changelog

then you can access the history via something like this

foreach (var histories in issues.changelog.histories)

This is C# syntax, but anyone who codes will understand it and be able to put it in the language they're using