How to return group names to filter results on dashboard?

Here is what I am trying to achieve:

I want a 2D Filter Results gadget on my dashboard which shows "Groups" on the Y-axis, and "Status" on the X-axis. Currently, I can *sort of* achieve this by setting up a filter that shows only issues that are assigned to members of a group. But when I use that filter in a 2D filter results gadget, it shows the assignee name rather than the group name.

I understand why this current gadget works this way, but is there a way to achieve this some other way? Even it requires some development, I'd like suggestions. The ultimate goal is to have a gadget on a dashboard that shows the status of issues for 6 major "Teams", regardless of which Jira project they are under.

1 answer

This widget could not be displayed.

My approach this would be to use a hidden Groovy Runner custom scripted field to store the group name(s) associated with the assignee.

I'm not a developer, so I couldn't provide you with any code examples. Maybe something on these pages would help, and I'll re-tag this question to hopefully attract the attention of experts like Jamie Echlin & Co. I'm a bit more comfortable with SQL, so in my mind it would be a script populating the data equivalent to something like:

SELECT cwd_membership.parent_name
FROM jiraissue, cwd_membership 
WHERE jiraissue.issuenum = $issuenum
AND jiraissue.assignee = cwd_membership.child_name
AND cwd_membership.parent_name NOT IN ('jira-users', 'jira-administrators')

Hope that helps.

Adam, thanks for spending some time on this- I tinkered around in SQL to get the results I am looking for (or close to it) and came up with:

select mycount, JiraGroup, JiraGroupID, issuestatus, pname from (

SELECT cm.parent_name as JiraGroup, issuestatus, pname, count(ji.pkey) as mycount, cm.parent_id as JiraGroupID

from jiraissue ji

left join cwd_membership cm on ji.assignee = cm.child_name

left join customfieldvalue cf on cf.ISSUE = ji.ID

left join issuestatus ist on ist.id = ji.issuestatus

WHERE cm.parent_id IN (10516, 10518, 10514, 10520, 10522)

and issuestatus in (1, 1004, 3)

and cf.CUSTOMFIELD = 10050

group by parent_name , parent_id, issuestatus, pname

) o

group by JiraGroup, mycount, JiraGroupID, issuestatus, pname

of course, you'd need to remove the custom field stuff to get this to return any results, but this is the data we're looking for. But I am not sure how to achieve this using JQL and/or REST services...

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

65 views 1 0
Join discussion

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