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; } } }

Identifying Teams with No Stories Matching Specific Label (Without ScriptRunner or API)

Igor Pertsovsky

Hi Atlassian Community,

I'm trying to identify teams in Jira that have not created any stories with a specific label (let's say the label is called "Important").

Here's my situation:

I need to find teams that haven't used the "Important" label on any of their stories.
I'm not working within Jira Cloud.
Unfortunately, I don't have access to ScriptRunner or the Jira API within my organization.
Teams are identified using a custom field called "Team" (a single select field).

I've tried using JQL queries in dashboard gadgets, but I'm struggling to find a solution that directly lists the teams that are missing the label. The best I can do is create a JQL query like this:

project = YOUR_PROJECT AND issueType = Story AND labels = Important AND "Team" = "Team A"

...and then repeat that query for each team, which is very manual.

I've also experimented with the "Two-Dimensional Filter Statistics" gadget, but it only shows me teams that do have stories with the label, not the ones that are missing them entirely.

Is there a way, using only standard Jira features (JQL, dashboard gadgets, etc.), to efficiently identify the teams that have not created any stories with the "Important" label? Any suggestions or alternative approaches would be greatly appreciated!

Thanks in advance for your help!

Accepted answers

All comments

Varsha Joshi

Hi @Igor Pertsovsky

Welcome to the community

Have you tried - project = YOUR_PROJECT AND issueType = Story AND labels Not In (Important) - this should get you list of teams from your custom field that have not used the label

project = YOUR_PROJECT AND issueType = Story AND labels = Important AND "Team" Not In (list from Query1) should verify it for you.

Hope this helps.

Igor Pertsovsky

Hi @Varsha Joshi

Thank you for your reply. Please help me understand the (list from Query1) part?

Varsha Joshi

Oh I just meant the first Query - "Have you tried - project = YOUR_PROJECT AND issueType = Story AND labels Not In (Important) - this should get you list of teams from your custom field that have not used the label" - just lazy to type it again :-)

I should have labelled it in my reply. Sorry for the confusion.

Bill Sheboy

Hi @Igor Pertsovsky -- Welcome to the Atlassian Community!

Based on what you described, please try using this JQL:

project = YOUR_PROJECT
 AND issueType = Story
 AND ( 
      labels NOT IN (Important)
      OR labels IS EMPTY 
     )
 ORDER BY Key ASC

And use that on a dashboard with the Pie Chart gadget, selecting your Team field.

Kind regards,
Bill

Igor Pertsovsky

Thank you for the suggestion. I used it in the DB and it looked very promising but when I test it, I see team that do have stories with the label in those projects but they are still in the chart. what can be the reason? this is my real filter:
project in ("DM-Shared Services ART", "DM-Claims ART", "DM-Financials and C&R ART", "DM-Policy ART", "DM-Pricing and UW ART") and issuetype in (Story, Spike) and labels not in (Codeupdates) and fixVersion in ("PI SHSE 2025.2")

Bill Sheboy

Labels are case-sensitive. Do you have other variations of that label which are not exactly "Codeupdates"?

If not, please post a image of Jira for the JQL search, showing that exact JQL, and a work item with that exact label value?

Please also note: as you are not also testing for EMPTY, the JQL you describe will always have at least one label, even when it does not match Codeupdates.

Igor Pertsovsky

Thank again. The filter above is the exact one I used in gadget.
Now it shows 4 teams and all of them have at least 1 spike or story with label "Codeupdates" see the image of such spike
Jira label.png

pie chart results.png

Igor Pertsovsky

Hi @Varsha Joshi , so do I need to use an excel in between or there is a better way?

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud