How to add filter to exclude parent story that has child?

Question

I would like to exclude story/bug/task that has at least one child. How to do that?

Note: All story/bug/task are having epics as parent.

Below is list all the required information without above logic.

issuetype in (Bug, Story, Task, Subtask) AND "End date[Date]" >= 2021-04-01 AND "End date[Date]" <= 2021-09-30 AND assignee in (5b43fa8ba492e959f3f32549) order by created DESC

Thanks.

Lee

Lee Zhi Chien_86gaft · Answer

I have tried the following but still I can see the "Parent" CX11-1222.

issuetype in (Bug, Story, Task, Subtask) AND "End date[Date]" >= 2021-04-01 AND "End date[Date]" <= 2021-09-30 AND assignee in (5b43fa8ba492e959f3f32549) AND "Parent Link" is EMPTY order by created DESC

Carlos Garcia Navarro · Answer

Hi @Lee Zhi Chien ,

Did you try the clause:?

"Parent Link" is EMPTY