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

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • 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, order by "custom field" desc shows blanks first

I created a custom numeric field to calculate WSJF and sort desc, set the default value of the custom field to '0', but the results show all of the blank at the top of the list.


If the default value is '0', why are these stories showing before the largest value?


(field1 + field2 + field3)/field4 = WSJF  

1 answer

1 accepted

0 votes
Answer accepted

Hi @Ian Clem 

Welcome to the community.

Those issues might be the ones that do not have any value yet. I mean, they might be either out of custom field context or they might be created before the custom field creation.

You can add customfieldname IS NOT EMPTY to your JQL, or bulk edit issues to set default 0 value for already existing issues.

I hope I was clear


The options were very clear and they worked.


I believe that i discovered the default value option after created the field and adding the calculation.  Nevertheless, using JQL and bulk editing the field did the trick.



I'm glad to hear that 

Suggest an answer

Log in or Sign up to answer

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