Hi Community, I want to filter tickets which is having sub task. Please help me with the query here.

Aravinthakumar K
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!
September 24, 2024

Screenshot 2024-09-25 013901.jpg

2 answers

0 votes
Laurie Sciutti
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 24, 2024

Hi @Aravinthakumar K and welcome to the Community!  If you use ScriptRunner you can use the following:

 

issueFunction in hasSubtasks()

 

Ref:  https://docs.adaptavist.com/sr4js/8.25.0/features/jql-functions/included-jql-functions/sub-tasks#hassubtasks  

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 24, 2024

Hello @Aravinthakumar K 

Welcome to the Atlassian community.

Can you please provide more information about what you want in the results of your filter?

Do you want only issues that have subtasks?

Are you trying to get the subtasks under all the issues that match your filter?

Are you trying to get just the subtasks that directly match the criteria of your filter?

Aravinthakumar K
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!
October 17, 2024

Hi @Trudy Claspill , Thanks for your reply!
Yes, I want to filter only issues that have subtasks.

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 17, 2024

Jira does not have a native function in JQL for selecting issues based on them having (or not having) subtasks.

You can get that function from a third party app, as suggested by @Laurie Sciutti. Are you willing to get a third party app?

If you are not willing or your Jira administrators won't support that, you could work around that by using a custom field to keep a count of subtasks in each issue and using Automation Rules to set that field. Then you could use that field in your JQL.

Like Laurie Sciutti likes this

Suggest an answer

Log in or Sign up to answer