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

JQL query User story and defects

Garden16__h3vuuz

Need a JQL query for the user story and the defects associated with the User story using Script runner JQL functions.

We have defects linked to User story. We would like to see all defects related to the user story. We need a report that displays all the user stories and its associated defects and total count of defects related to the user story

User story and defects.PNG

Accepted answers

All comments

Trudy P Claspill

Hello @Garden16_

What version of Jira are you using and what version of ScriptRunner are you using?

You should be able to use the linkedIssuesOf ScriptRunner function to get the Bugs linked to Stories.

First you construct the query that will get the stories you want; i.e.

project=x and issueType=Story

Add to that the linkedIssuesOf function to get issues linked to those stories.

project=X and issueType=Story or 

issueFunction in linkedIssuesOf("project=X and issueType=Story")

Add criteria to limit the linked issues to only Bugs:

project=X and issueType=Story or 

(issueFunction in linkedIssuesOf("project=X and issueType=Story") and issueType=Bug)

That will give you a list of the issue, but not in the format you showed. Jira does not natively have the capability to produce a report in that format.

You could use a ScriptRunner Scripted Field to keep track of the Bug issues linked to your Story.

https://docs.adaptavist.com/sr4js/latest/features/script-fields

Hannes Obweger - JXL for Jira

Hi @Garden16_

if you're open to solutions from the Atlassian Marketplace, this may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, the number of linked issues, and many other issue-link-related columns. With these, you should be able to build the view you're looking for in just a couple of clicks:

JXL also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - depending on your exact use case, I believe that these could be useful as well.

Note that this all just works, and doesn't require any scripting or automation whatsoever.

Any questions just let me know,

Best,

Hannes

Garden16__h3vuuz

We have script runner Version:

6.56.0 Data center

and JIRA 8.0.1

Garden16__h3vuuz

We do have JXL also . Can you suggest how to create this report and put it in the JIRA dashboard User story and defects.PNG

Trudy P Claspill

All of my references to ScriptRunner documentation were to the latest version - 8.18.0. You would need to double check the documentation for the version you are actually using to confirm that the same functionality is available and used in the same manner.

Garden16__h3vuuz

(issueFunction in linkedIssuesOf("project=X and issueType=Story") and issueType=Bug)

when I run this query its shows the list of defects that linked to all issue types

its showing defects, tests, test execution issue types which are all linked to the defect.

If I flip the query it shows the story and every thing that is linked to the story

(issueFunction in linkedIssuesOf("project=X and issueType=Bug") and issueType=Story )

How will I create query that shows 'only issue type =bugs ' linked to the user story.

Please advise how to display only defect issue types linked to the user story User story and defects.PNG

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

adaptavist

jira-server

new-to-jira