Searching on originalEstimate isn't accurate when using weeks or days

I have a JIRA task that has an 'Original Estimate' of '4 weeks'. However, when I search with the following query (either of them):

project="my project" and originalEstimate >= 4w
project="my project" and originalEstimate >= 20d

the JIRA isn't returned. Interestingly, when I search using the same thing in minutes:

project="my project" and originalEstimate >= 12000m

the JIRA is correctly returned in the search results.
Does anyone know why this is? It's painful to have to convert all of my time-based queries to minutes instead of the much more understandable convention of days/weeks.

3 answers

0 vote
Ahmad Danial Atlassian Team Apr 16, 2013

Hey there, Brandon.

Just did a quick testing on my side and it works fine. May I know which version of JIRA you are running? In addition to that, do you have any third-party plugins installed in your instance? If yes, try to enable the Safe Mode to see if it helps.

In addition to that, try running reindexing too. Hope this helps.

Warm regards,

Danial

After playing with this a bit longer, I think its due to some mysterious way JIRA converts hours into other units of time. Searching on hours is accurate but searching on days/week/month is very variable and can be off by quite a bit.

0 vote
Ahmad Danial Atlassian Team May 01, 2013

Hey there, Brandon.

Thank you for sharing your findings. When you say that the search via days/weeks/months varies, does that mean that sometimes it shows the correct result and sometimes not? Any luck with the reindexing?

Warm regards,

Danial

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,337 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot