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