Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Get started Tell me more

4,555,479

Community Members

Community Events

184

Community Groups

Community
Products
Jira
Jira Software
Questions
JQL query to find issues with no story points, but exclude those with subtasks

JQL query to find issues with no story points, but exclude those with subtasks

Hi. I've been looking into adding a quick filter to our Kanban board that displays tickets with no story point value. My query is shown below and works well.

status not in ("Done/Published", Cancelled) AND issuetype != epic AND "Story Points[Number]" is EMPTY

However this isn't the whole story. You can have subtasks and tasks, in which case the task isn't story pointed - just the subtask.

So my question is, can the query be changed to report on tickets that are not story pointed, but exclude tasks that aren't but have subtasks that are?

1 answer

1 accepted

1 vote

Answer accepted

Hi,

It seems that you will need an addon to achieve this.

Or try to create a rule with automation to add a flag in those task that have not story point but subtask have.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks for responding. The idea of automation is one I hadn't considered.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Suggest an answer

Was this helpful?

Thanks!

Jira Software

DEPLOYMENT TYPE

CLOUD

PRODUCT PLAN

PREMIUM

Products

Community resources

Support

Interests

Community resources

Support

Top groups

Community resources

Support

Earn badges and make progress

Participate in fun challenges

Gift kudos to your peers

Rise up in the ranks

Come for the products,
stay for the community

JQL query to find issues with no story points, but exclude those with subtasks