Need a JQL query to extract the required issues based on some conditions involving project roles in Jira 4.4.5

[Harish]

We are using Jira 4.4.5

We are in need of a JQL query that should provide the results as per the below conditions;

All Issues where Issue Type = Defect AND Evnironment = SIT Group by Project Role.

Say we have 3 project roles - SA, BA, QA. We need to find the defects raised in SIT by SA / BA / QA.

How can this be achieved?

Please provide the JQL query.

[Renjith Pillai]

You can use script runner and write a custom field the returns the first project role of the reporter. Use that field to plot it in a pie chart.

You need to write the logic to get all project roles, then do a loop to get all project role actors (ProjectRoleManager) for the project and then find the first one that matches the user.

I don't have any ready made script, I guess if you search this forum you can find snippets to get it working.

Remember, this field may become a computation intensive one, so using it on large filters may cause performance issues, if you instance is large and has lot of users being returned for each of the roles.

[Nic Brough -Adaptavist-]

The docs give you a simple example on https://confluence.atlassian.com/display/JIRA/Advanced+Searching

project in projectsWhereUserHasRole("Developers") AND status = Open

Obviously, drop the status clause and add your own for multiple roles, issue type and environment.

[Harish]

Hi Nic, Thanks for the response. However this query works for the logged in user.

It checks for the current loggedin user's role.

We need to have a the query to work as Grouup by.

The actual requirement is to have a Pie Chart in the dashboard which displays the defects raised in the SIT env by project roles - QA / SA/ BA.

Please elt me know if the query can be modified so as to achieve this.

[Renjith Pillai]

That's slightly tricky, if the user is present on multiple roles, what do you want to do?