Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

how can i filter out tickets without subtasks?

Paolo Ferrara
Paolo Ferrara
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
February 8, 2021

I want to filter out only tickets without any subtask.

Can you suggest me an SQL string?

thx

Paolo

Answer
Watch
Like Be the first to like this
647 views

3 answers

2 accepted

0 votes
Answer accepted
Mohamed Benziane
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 8, 2021

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

View More Comments
Paolo Ferrara
Paolo Ferrara
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
February 8, 2021

Thanks a lot!

I'll try with it.

Like • Mohamed Benziane likes this
Reply
0 votes
Answer accepted
Jack Brickey
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 8, 2021

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

Reply
0 votes
John Funk
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 8, 2021

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. 

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events

    See all events