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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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