How do I search for tasks where the status of the related story has a certain value?

Question

So I have a bunch of stories with subtasks. I want to find all tasks on my name, but only for stories in a certain state. On the board I have to click open each story one by one to see all tasks assigned to me, but I need some kind of worklist. So in the issue search I try to filter on tasks on my name. You can see the tasks with the name of the story in the title, but I cannot filter on the status of the related story.

Muhammad Ramzan_Atlassian Certified Master_ · Accepted Answer

You can get your results by using :  JQL Search Extensions for Jira & reports

They have amazing features like sub queries, in your case what you need to do is

Create a sub query : "type=story and status=yourstatus"and name it anything like in below example name is "stories"

Now you can use following query and it will get all stories sub tasks where you are assigned to sub task.

subTaskOfQuery="stories" and assignee = currentUser()

If you want to get both stories and sub tasks then you can use following query

(subTaskOfQuery="stories" or  issuesInQuery="stories") and assignee = currentUser()

here is the documentation reference:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/173211649/Subqueries+-+Jira+Cloud