JQL - Which parent tasks are not having few sub-tasks?

[Manmadha Kudupudi]

Hi folks

We have one parent issuetype ex: Task

When created Task then automatically should create 5 subtasks with 2 deferent summaries. (We wrote scriptrunner code to auto create 5 subtasks )

all subtasks type same - subtask

1. subtask - summary abc
2. subtask - summary abc
3. subtask - summary abc
4. subtask - summary xyz
5. subtask - summary xyx

but some Tasks are not created subtasks 4 and 5 (4. subtask - summary xyz
5. subtask - summary xyx)

Need a JQL:

I want to know which parent tasks are not creating subtasks 4&5(Summary xyz)

Thanks,
Manmadha :)

[meliodas16]

Hello @Manmadha Kudupudi ,

This cannot be done natively with Jira, it requires a Custom JQL Function.

Do you have by any chance Scriptrunner ?

Kind regards.

[Manmadha Kudupudi]

Hello@meliodas16 

We are using Scriptrunner.

Can I do with scriptrunner?

Thanks

[meliodas16]

Hello @Manmadha Kudupudi ,

Please try : issueFunction not in parentsOf("summary !~ 'summary xyz' or summary !~ 'summary xyx'").

Kind regards.