nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Add a gadget to show the projects and issues assigned

Elbert

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.

Accepted answers

Trudy P Claspill

Hello @KE

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

All comments

Trudy P Claspill

Hello @KE

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

Elbert

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

Trudy P 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.

Elbert

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server