Filter parents status is ready for testing without resolved the subbtasks

[Madhavi]

I need a query to filter the parent tickets status changed to ready for testing without resolving the dev sub task in jql. 

Ex: I have one parent story for that I have created two dev sub task.

Dev sub task status is open or in progress but I have change the parent story ticket status to Ready for testing so the query will return the main ticket. 

[Charlotte Santos -Appfire-]

Hi @Madhavi 

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

Unfortunately, natively, 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 get the parent tickets in the status Ready for Testing whose subtasks are not resolved:

issue in parentsOfSubtasksInQuery("status!='Done'") and status="Ready for Testing"

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

We’ll be happy to help you! 😉

[Ana Vitória Selista]

Hi Madhavi,

if you have Scriptrunner, use the following:

status = "Ready for Testing" AND issueType = your_issuetype AND issueFunction in hasSubtasks("resolutions is empty")

This JQL finds issues of a certain type that are in the "Ready for Testing" status and have at least one unresolved sub-task.

 Hope it helps!

[Madhavi]

I want like suppose in sprint while I am changing the parent ticket status is ready for testing with out resolved sub task but after some time I have resolved sub task and parent ticket also. Still I need to show parent ticket by using jql query. 

[Vishal Biyani]

@Madhavi 

This is not feasible using native JQL as it does not allow subquery.