Filter sub tasks by issue type "Epic"

[Urmas Kungla]

Hi

I need to create a filter where I can sort all tasks that are not

• Epics
• Linked to an Epic as a task (not issue to issue link but set as a task under Epic"
• Are subtasks of Epics
• Are subtasks of parent tasks that are linked to an Epic

I only have come this far:

issuetype != Epic AND "Epic Link" = EMPTY

All help is welcomed :)

--

Urmas

[Grigory Salnikov]

Hi @Urmas Kungla!

Let's split the JQL according to the conditions:

1. Not Epics:

issuetype != Epic

2. Not linked to any Epic

"Epic Link" is EMPTY 

3. Not subtasks of any Epic:

... AND parent not in (<ID1>, <ID2> ...)

Where ID1, ID2 are ids of Epics.

4. Not subtasks of parent tasks that are linked to an Epic

This last condition is already covered by the 2nd one. Subtasks have the same Epik Link as their parents.

So, the final JQL will look like:

issuetype != Epic AND "Epic Link" is EMPTY AND parent not in (<ID1, <ID2>, ...)

[Urmas Kungla]

Hi

Thank you for your suggestions.

Regarding this part:

parent not in (<ID1, <ID2>, …) 

This solution unfortunately is not suitable because there will be many different Epics which I can't control and therefor the script should be dynamical- it should be able to filter by issue type "Epic" not by single ID (or multiple ID-s).

Any ideas?

[Grigory Salnikov]

Hi!

Yes, there's a workaround. 

You should link all the epics to an issue (<ISSUE>) and tell everyone they need to link all their new epics to this issue.

After that you can use:

parent not in linkedIssues(<ISSUE>) 

[Urmas Kungla]

Yeah, I thought about that too but this will not work for me- it's an extra move that EVERYONE has to REMEMBER all the time. It'll never work out.

Any other ideas? Or is it really a feature request?