JQL to query parent record based on specific sub task

Vimalraj

Hi,

I'm looking for solution to search a parent record based on specific sub-task.

For ex., 

Parent issuetype has 2 different sub tasks. Sub task 1 is an Action and Sub task 2 is a Question.

My requirement to is fetch parent records which has only contains Actions. Is there a way to do it. 

I tried below, but doesnt seem to work. May be I'm making some mistake

 

issuetype = "Parent" AND issueFunction in parentsOf("issuetype = 'Action' AND issuetype != 'Question'") 

Please assist.

Italo Qualisoni [e-Core]

This is tricky, you can try the following:

 

issuetype = Parent AND issueFunction in parentsOf("issuetype = 'Action'") and (not issueFunction in parentsOf("issuetype = 'Question'"))

 

I'll try to break it down, this intend to return all issues with issuetype = Parent that contains subtasks with issuetype Action and doesn't have any Question subtask. 

It's important to notice that that not in the second part of the condition.

I think this might be a heavy query depending of the amount of issues you have, maybe you can improve the performance by adding the project = ProjectKey , this will reduce the scope of the JQL. I had an issue in the past that a heavy query was crashing an environment due large usage of memory, probably this has been fixed in recent versions but I need to share that heavy JQL can impact performance. So use it as needed