It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to search stories which do not have a particular subtask ?

I want to search all the stories which do not have a subtask with subtask summary "integration tickets" ?

6 answers

Hi,

Sadly you must go for a third-party app for this complex query.

Using i.e. JQL Booster Pack you must type:

 

Find Stories not having Subtaks with summary "integration tickets"

type = Story AND issue NOT IN parentsOf('summary ~ "integration tickets" AND type in subTaskIssueTypes()')

 

Regards

@charutiwari As mentioned by others, its not possible naively, I am using  JQL Search Extensions for Jira & reports.

I would suggest give a try , its not that much expensive and have amazing built in queries. 

 

In your case by using this plugin following query will get all user stories which have no sub tasks.

issue in subtaskCountLessThan(1)and issuetype=story 

Thankyou @Muhammad Ramzan , is there any free version of this in the marketplace?

Unfortunately its paid one, but you can give a try at trail version , all plugins in jira are available on trail for one month

@Muhammad Ramzan : Would I need to purchase this for every login on my cloud JIRA or just one overall? Say if it cost $10 and my cloud JIRA has 20 user, Would I need to pay $200?

If it is for every login, can I purchase it for only my login and not everyone? 

 

Thanks!

You will need to have Scriptrunner for the same. It has "issueFunction" capability in JQL that provides help complicated requirements.

0 votes
Jack Community Leader Nov 25, 2019

OOTB you can’t find issues that have or do not have sub-tasks so that interferes with your goal. You can accomplish this using an addon like Scriptrunner and others.

0 votes

Scriptrunner 

type = story and issueFunction not in linkedIssuesOfAll("summary~'integration tickets' and type=sub-task")


Search Linked Issues

type = story and issue not in parentIssuesFromQuery("summary~'integration tickets'") 

 

@Leonard Chew  : I added scriptrunner . However the functions and query you suggested is still not available. 

Thankyou everyone. Is there any free extension I can get for this in the marketplace or anywhere else?

As I suggeted, JQL Booster Pack is free prior to 2.x version.

Like charutiwari likes this

@Jack Nolddor _Sweet Bananas_  would it work with Cloud JIRA?

Not sorry, only available for Server & DataCenter deployment options

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you