How can I write a query to return issues I am connected to?

[George Carvill]

To clarify, I want to write a query that will return...

1. All Issues and subtasks assigned to me

2. And any parent Issues where I am assigned a subtask

3. And all subtasks of parent Issues returned in #2

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

Using JQL Tricks plugin (paid), you can achieve this in 2 steps.

1. Save a filter to find all parent issues where you can assigned a subtask

issue in parent("issuetype = subtask and assignee = currentUser()")

2. Write another query to use the filter saved above. Something like:

assignee = currentUser or filter = "Filter I saved earlier" or issue in subtask("filter = \"Filter I saved earlier\"")