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

Need help with JQL: Looking for a list of Stories where only bugs have been linked to

Diana Leon

I need help with JQL. I am not a programmer. I do not have access to the backend to configure JIRA.

I am looking for a way to pull Stories with linked Bugs only.

sample: project = <my project> AND issuetype = Story AND status = Accepted

I have a column Links, however, it shows me everything that is linked but I only want to get a list with bugs.

If there is no way to do this with JQL filter, can it be done in Project Automation where it can send the report with all Stories linked to bugs once a week?

Thank you!

Diana

Accepted answers

Joseph Hani

Hello @Diana Leon ,

If I remember correctly this is not possible with Standard feature of Jira. You will need and extension to do this. Like ScriptRunner or JQL Search Extension for Jira

Actually the only thing you could get is the issue link from a specific IssueType, for example :

issue in linkedIssues("TYPI-35")

If you have admin rights, and have managed to put all your bug inside a reference like "related to", "approve by", blocks, cloned by, ... (you can check you reference if you are Admin, go to Issues --> under Issue Features --> Issue linking)

Something like this could be useful :

issue in linkedIssues("TYPI-345", blocks)

I would suggest also to try something like this with multiple ticket, but probably need more permissions to do it :

issueFunction in linkedIssueOf("issue in (TYPI-30802,TYPI-31247,TYPI-30292,TYPI-31270)") AND type in (bug)

Using an app you could have use something like this , but not working on Standard sorry

type = Bug AND issue IN linkedIssuesOf("type = Story")

Good luck

Robert Wen_Cprime_

Hello @Diana Leon !

The closest I can come to what you want is this (using OOTB JQL):

project = <my project> AND issue type = Story AND issueLinkType = "is blocked by"

This will only work if you consistently set up this link relationship to your Bugs. If not, the following variation may help:

project = <my project> AND issue type = Story AND issueLinkType in ( "is blocked by", <other link relationships>)

All comments

Joseph Hani

Hello @Diana Leon ,

If I remember correctly this is not possible with Standard feature of Jira. You will need and extension to do this. Like ScriptRunner or JQL Search Extension for Jira

Actually the only thing you could get is the issue link from a specific IssueType, for example :

issue in linkedIssues("TYPI-35")

Something like this could be useful :

issue in linkedIssues("TYPI-345", blocks)

I would suggest also to try something like this with multiple ticket, but probably need more permissions to do it :

issueFunction in linkedIssueOf("issue in (TYPI-30802,TYPI-31247,TYPI-30292,TYPI-31270)") AND type in (bug)

Using an app you could have use something like this , but not working on Standard sorry

type = Bug AND issue IN linkedIssuesOf("type = Story")

Good luck

Robert Wen_Cprime_

Hello @Diana Leon !

The closest I can come to what you want is this (using OOTB JQL):

project = <my project> AND issue type = Story AND issueLinkType = "is blocked by"

This will only work if you consistently set up this link relationship to your Bugs. If not, the following variation may help:

project = <my project> AND issue type = Story AND issueLinkType in ( "is blocked by", <other link relationships>)

Diana Leon

Hi Robert. Let me try your solution. Thank you!

However, it will pull everything and not just bugs.

Robert Wen_Cprime_

Diana,

You are correct. it will pull all issues of any type that has that link relationship.

@Joseph Hani may have the better solution, but it will require an app like ScriptRunner.

Diana Leon

We do not have ScriptRunner. I doubt it will be allowed to enable in our JIRA. Thank you so much for all your help @Robert Wen_Cprime_ and @Joseph Hani .

Diana Leon

Thank you so much!

Diana Leon

It worked. I have tried: project = <my project> AND issuetype = Bug AND issueFunction in linkedIssuesOf("Type = Story")

Thanks a ton!

Welcome!

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

Quick Links

Find more posts tagged with

jira-core

issue-link

automation