JQL to find the parent story task

[unnikrishnan]

Hi All,

I would like to write a JQL to show only the sub tasks which are Done status and the parent story status is no Deployed.

Do we have any way to extract the sub tasks based on the parent story's  status  

Something like this;

SELECT ALL SUBTASK WHERE SUBTASK Status = DONE and( PARENT STORY(sub task)  status = DEPLOYED )

[Susan Wilson]

Try this:  issueFunction in subtasksOf("status = Done") and status != Done. 

The results returned subtasks that are done, while their parent (story) is still in an open status.  You can tweak to your specific status naming convention, as needed, if this works for you.