How can I filter out Sub-tasks whose parents are in an Epic?

[Patrick Till]

HI

I have written the below filter that will obviously not work as you can not use "is not" with the field "parentEpic".

Can anyone offer me a solution to be able to list all sub-tasks whose parents are part of an Epic, any Epic?
This is not for specific Epics.

project = MTSAP AND ("Epic Link" is not EMPTY OR "Epic Name" is not EMPTY OR (issuetype = sub-task AND "parentEpic" is not EMPTY))

[Dave Mathijs]

Hi @Patrick Till , you cannot do this natively as far as I know, you would need an issueFunction for that.

[Patrick Till]

Hi @Dave Mathijs 

Thank you for your response. 

Where or how would I get or create an issueFunction?

[Dave Mathijs]

You can use third-party app ScriptRunner for Jira for that. See Issue Link Functions

[Patrick Till]

I had a look at that but I have a very limited budget and I was hoping for some sort of solution in Jira.

[Dave Mathijs]

Apart from if it's possible or not, curious about why you would like to filter those subtasks?

[Patrick Till]

This project has many types of issues and sub-tasks etc

I have automations on sub-tasks that roll up to parent issue and then to Epic but my users do not always update the sub-tasks and therefore the Issues and Epics are inaccurate.

I want to review those sub-tasks but only if they are linked to an Epic.

[Dave Mathijs]

How about a validator that prevents transitioning a standard issue type (story/task) to a Done status category if the subtasks aren't resolved?

[Patrick Till]

The automation changes the parent status but only if someone correctly closed the sub-task. I am looking for a list of sub-task, that are "linked" to Epics, that have not been correctly closed so that I can close them and educate the users.