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

[charutiwari]

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

[Jack Nolddor _Sweet Bananas_]

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

[Muhammad Ramzan_Atlassian Certified Master_]

@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 

[charutiwari]

Thankyou @Muhammad Ramzan_Atlassian Certified Master_ , is there any free version of this in the marketplace?

[Muhammad Ramzan_Atlassian Certified Master_]

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

[charutiwari]

@Muhammad Ramzan_Atlassian Certified Master_ : 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!

[charutiwari]

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

[Jack Nolddor _Sweet Bananas_]

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

[charutiwari]

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

[Jack Nolddor _Sweet Bananas_]

Not sorry, only available for Server & DataCenter deployment options

[Leonard Chew]

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'") 

[charutiwari]

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

[Jack Brickey]

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.

[Solomon David Cherian]

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