How can I find bug linked to issue in sprint?

[Pier Nicolò Pinna]

Hi all,

I need a JQL query to find bugs open linked to issue in current sprint or in past sprints.

Details: 

I have sprints with different story inside. When a story are tested, if bugs are present, the relative bug it's linked to the story.

How can I find this bugs with a JQL query?

This bugs aren't inside the sprint, so I can't use "In Sprint" JQL function for this issues.

Thanks in advice

Pier Nicolò

[Tarun Sapra · Accepted solution]

Hello @Pier Nicolò Pinna

You would need a plugin for this kind of query. If you have script runner plugin then it can be easily achieved using the followign query

type = bug and issueFunction in linkedIssuesOf("Sprint in openSprints()")

It fetches bugs which are linked to issues in open sprints (you can add futher conditions like closedSprints etc in the above JQL) 

[Pier Nicolò Pinna]

Hi @Tarun Sapra,

thanks for the answer. Do youknow if there is a way to have a similar result without plugin?

Cheers!

N

[Tarun Sapra]

Hello @Pier Nicolò Pinna

It's possible out of the box.

Jira provides a function to search for linkedIssue but you can do that only for a single issue key and not a generic search like the one which I shared above

https://confluence.atlassian.com/jirasoftwareserver0711/advanced-searching-functions-reference-955167126.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues()

[Pier Nicolò Pinna]

This is not what I am looking for :(

Ok so I need a plugin or i need to think a workaround to find this issues

Many thanks for your support!

[Pier Nicolò Pinna]

Hi @Tarun Sapra,

there is also a JQL to find bugs in a specifically closed sprint?

[Tarun Sapra]

Hello @Pier Nicolò Pinna

yes you need a plugin for the jql query which I posted above. If you wish to find bugs in closed sprint then if you know sprint name then you can find that using jql and without any external plugins.

[Pier Nicolò Pinna]

I buy the plugin that you mention above, what should be exactly the JQL for this?

Many thanks

[Tarun Sapra]

Hello @Pier Nicolò Pinna

I have mentioned the jql in my answer, what is your exact requirement?