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

[Lee Zhi Chien]

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

[Carlos Garcia Navarro]

Hi @Lee Zhi Chien ,

Did you try the clause:?

"Parent Link" is EMPTY

[Lee Zhi Chien]

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