Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL for all stories without Story Points

I want to get an overview of all the stories in the backlog that has not yet been estimated with Story Points, so I'm looking for help creating a query that will do just that.

In another thread https://community.atlassian.com/t5/Jira-questions/I-need-to-query-my-project-for-all-stories-with-no-story-points/qaq-p/280229 it was suggested to use "Story points" is empty, but that doesn't work for me...

Funnily, I can filter all the estimated stories with query: "Story Points" > 0, but it doesn't work to reverse it with "Story Points" < 1 to see all the unestimated stories.

2 answers

1 vote
Thomas Schlegel Community Leader Apr 26, 2019

Hi @Bjarke Brint

"Story Points" is empty should work, it does for me.

Do you get an error or just a wrong result? Could you please give us more information?

Hi, thanks for getting back to me. 

As you can see in the attachmeent it doesn't really work. Both issues with SPs and without SPs show up:

2019-04-26 16_18_00-'MSP2 - Production Track' - Agile Board - MovieStarPlanet JIRA.png

0 votes
Tarun Sapra Community Leader Apr 26, 2019

Hello @Bjarke Brint 

As suggested by @Thomas Schlegel  below JQL should fetch all the unestimated stories (story points field should be mapped to the project context in the custom field configuration)

"Story Points" is empty

should work, if it's not working then I suggest you to do a reindex of project or the instance and check the results again

Tried to re-index the project, still mot working... :/

OK, this looks weird:

In the backlog the Story Points appear if they are assigned as shown in the attachment above reply to @Thomas Schlegel.

But in the detail view the SPs show up only in the Estimate field, and its says "None" in the Story Points field. (1st attachment)

But then, if I open the issue in another tab it shows up in the Story Points field. (2nd attachment)

I'm a bit lost here, I must admit. 

Screen Shot 2019-04-27 at 21.41.50.pngScreen Shot 2019-04-27 at 21.42.17.png

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

1,140 views 2 7
Join discussion

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you