Hello @Zahurul Islam
Jira does not provide functionality natively to support that type of search. You would need a third party app that extends the functionality of JQL to support subqueries or specialized functions for finding parent stories based on a subfilter for sub-tasks.
A search of the Marketplace for "jql extension" lists a few apps. You would need to review each one to see if it provides the functionality you need.
I used Adaptavist Scriptrunner at my previous employer and found it very useful. The have specialized sub-task functions that would allow you to execute the query you want.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events