how can i filter out tickets without subtasks?

[Paolo Ferrara]

I want to filter out only tickets without any subtask.

Can you suggest me an SQL string?

thx

Paolo

[Mohamed Benziane · Accepted solution]

Hi @Paolo Ferrara 

Welcome to the community

This is not possible out of the box. You will need addon like scriptrunner to achieve this.

hope this helps

[Paolo Ferrara]

Thanks a lot!

I'll try with it.

[Jack Brickey · Accepted solution]

Unfortunately this is not possible OOTB (JRACLOUD-67108). You can consider something like Scriptrunner.

[John Funk]

Hi Paolo - Welcome to the Atlassian Community!

Unfortunately, this is not possible out of the box with Jira. See this feature request:

https://jira.atlassian.com/browse/JRACLOUD-67108

However, you should be able to do with an add-on like ScriptRunner.