Need Query to search Closed / Done User stories linked with Open defects

[AjayShankar AN]

Old defects are re opened. Need to search all the stories in closed status but having open defects. Open defects means, anything other than closed. ( In progress, testing, blocked etc )

[Charlotte Santos -Appfire-]

Hi @AjayShankar AN 

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

Unfortunately, using JQL of Jira, 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 all the stories in closed status that have linked defects that are not closed:

issue in linkedIssuesOfQuery("type=defect AND status!=Closed") AND type = Story AND status = Closed

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

We’ll be happy to help you!

Best regards,

Charlotte

[Ravi Sagar _Sparxsys_]

Hi @AjayShankar AN 

Are your defects linked to the stories?

Ravi

[AjayShankar AN]

Yes, closed stories with linked open /testing/to do defects.