Bug Issues Related to Stories or Tasks

[tabdou]

I'm trying to use Jira to measure how my developers are doing in terms of the ratio of bugs are to Stories, Tasks and Sub-tasks they worked on.

Typically, when a Bug is created for a Story, we link the bug to that story -- I just don't know how to use JQL to query it.

I'm envisioning something like this (but of course this is not the actual JQL)...

project=PPP and assignee="John" and type in (story, task, sub-task) and linkedIssueType = Bug

So ideally I would like to see:

issue key, summary, type, assignee, list of all related bugs

A possible workaround is:

project=PPP and assignee="John" and type = bug and linkedIssue != Empty

I'm thinking that if the bug is related to an issue (vs. an existing production defect which wouldn't be linked to an issue) then there should be at least one link (which is the issue that the bug was created against).  On the other hand, if the bug is an existing production defect, it would not be linked to any other Jira Issue (stand-alone if you will).  Unfortunately, I can't seem to be able to query on linkedIssue.

Any help would be greatly appreciated!  We do not have any 3rd party Jira add-ons and will likely not be getting any.

[Charlotte Santos -Appfire-]

Hi @tabdou 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find bugs that are linked to stories and tasks:

issue in linkedIssuesOfQuery("project = PPP AND type in (story, task)") AND project = PPP AND type = Bug AND assignee = John

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

[Hannes Obweger - JXL for Jira]

Hi @tabdou,

kindly have a look at e.g. this thread - it's about projects rather than issue types, but the underlying problem, as well as any possible solutions, are the same.

Hope this helps,

Best,

Hannes