Combining Jira Queries: Search for issues based on previous query results

Question

Hello,

I need to create a query that would return all the defects linked to the stories processed in a particular sprint.

To find the stories I can use the following query 1.:

project = X AND sprint =Y AND type = story AND status not in (Z)

To find the defects linked to a story, I can apply:

project = "X" AND type = bug and issue in linkedIssues(issueKey)

The question is: how can I combine these two queries, so that I don't need to run the query 1 one and then manually put the story IDs into the query 2.

I would be very grateful for your suggestions.

Nataliya Romaniv · Answer

Thank you all for such quick replies!

As far as I understand, this is possible via add-ons only, which are currently not purchased by the company.

Muhammad Ramzan_Atlassian Certified Master_ · Answer

you can use  JQL Search Extensions for Jira & reports plugin

In your case following query will get the required results.

issue in linkedBy("project = X AND sprint =Y AND type = story AND status not in (Z)")

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-LinkedBy([linktype],jql-queryorissuekeys)

Nataliya Romaniv · Answer

Thanks a lot for your reply @Fran Garcia !