Add a gadget to show the projects and issues assigned

[KE]

I want to create a JQL query for which I can see multiple projects with labels = AB or BC and the assignees to those tickets with the labels. 

Ex: issuetype = "story" and project in (123, 456, 789, 101, 111) and labels in (ab or bc)

For the above query - I'd like to create a gadget that will show the projects and assignees as per the label. 

[Trudy Claspill · Accepted solution]

Hello @KE 

Are you wanting to display the issues as a list or are you trying to display issues counts?

[KE]

Issues as a count and if possible issue as a list as well. 

[Trudy Claspill]

The challenge is that you want issues with Labels of "ab" or "bc" but that will also retrieve issues that have either one of those labels in combination with any number of other labels.

If you ONLY ever put one value in the Labels field, then you could use an ORDER BY clause to order your list of lables as you wish:

ORDER BY labels ASC, projects ASC, assignee ASC

You could then use the saved filter in the Filter Results gadget to present the list of results in a Jira Dashboard.

Jira doesn't have a native gadget that would let you count the issues in the way you want, with three dimensions. There is a Two Dimensional gadget that would let you do an issue count table based on just two dimension; i.e. issue count per assignee and label, or project and assignee, or project and label. The gadget can also use a saved filter, so you could make 1 filter for each project, and then set the dimensions as Assignee and Labels.

Again, that works only if you ONLY ever put just one value in the Labels field.

[KE]

Thanks, Trudy. I can certainly work with either one of the labels and your answer actually helps. 

Is there a query to filter out user stories only under certain EPICS?

[Trudy Claspill]

Yes, you can select issues under specific Epics using this:

"Epic Link" in (<comma separated list of Epic issue keys>)

You have to provide an explicit list of the Epic issue keys in this case.

There are third party products that would give you the ability to select child issues based on a filter being applied to Epics, similar to

issuesInEpics(<filter for which Epics you want to select from>)

[KE]

"Epic Link" in filter only provides the results for all the user-stories that are tied to the EPIC Link field. 

I'd like to filter out all the stories that are linked or related to the EPICs. What third party software should I use?

[Trudy Claspill]

Your question concerning filtering for issues linked to Epics by methods other than being a child of the Epic has diverged from the original topic of your post, which has been answered.

To ensure that your new question gets attention from the community, please start a new Question thread about it.