I am a newbie at JQL and ask the community for help to come up with a query that returns a list of issues (in my cases Tasks) where the Tasks have sub-tasks within, but all of these sub-tasks are closed or cancelled (i.e. there's no open tasks that require attention).
Hi, @Fatima Bernardo !
As I know Jira doesn't have out-of-box JQL-funtion for your case.
I checked the Atlassian's docs about Advanced searching.
But you can get it from apps:
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event