nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL, order by "custom field" desc shows blanks first

Ian Clem

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

Accepted answers

Tuncay Senturk _Snapbytes_

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

Tuncay

All comments

Tuncay Senturk _Snapbytes_

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

Tuncay

Ian Clem

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.

Thanks

Tuncay Senturk _Snapbytes_

I'm glad to hear that

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud