Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

create a JQL query to find story points NOT using Fibonacci

Stefanie Sullivan
Contributor
December 29, 2022

I would like to find all stories that have points that are NOT using Fibonacci numbers.

 

How can I write these criteria in proper JQL?

  • Where "Story Points" is NOT empty
  • and not 1,2,3,5,8,13,21,34 
  • IS NOT greater than 55
  • or not equal to 0

 

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Champion
December 29, 2022

Hello @Stefanie Sullivan 

You've pretty much got it. You just need the proper syntax.

"Story Points[Number]" is not EMPTY and "Story Points[Number]" not in (1,2,3,5,8,13,34) and "Story Points[Number]" <= 55 and "Story Points[Number]" != 0

You can actually combine the last one with the second one:

"Story Points[Number]" is not EMPTY and "Story Points[Number]" not in (0,1,2,3,5,8,13,34) and "Story Points[Number]" <= 55 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events