Order by 'time to sla custom field'

Hi,

Currently I have meny tickets with defferent SLA. I want to order them to show tickets with least time to resolve them. When I simply order by the custom field, it doesn't work, I don't even know what is pattern there. Is there any resolution for that?

2 answers

Hi,

This is a little hard and confusing but I will try to clarify.
JIRA Issue navigator sorts according to index values, and indexing (changing) time value is nearly impossible because JIRA only indexes by issue status changes or by admin's reindexing. Since time changes every second, we can not index remaining time value.

So Time to SLA field indexes the SLA Target Date. When you change issue's status it calculates and modifies the index value according to new SLA target date. However if the issue is in pause status the SLA target date does not change until a status change happens, so the index value may not be accurate.

On the other hand you can use SLA Report to see the exact SLA target dates and sort issues in that page.

Hope that I was clear

Tuncay

0 vote
Vasiliy Zverev Community Champion Mar 29, 2016

You need a culculated custom field to get difference between two dates, There is no such functions into box JIRA, but you could use these plugins:

  1. Free plugin to do simple things. Do no need to write code: https://marketplace.atlassian.com/plugins/com.innovalog.jmcf.jira-misc-custom-fields/versions#b100500930
  2. more complex, but you can do a lot with writing code https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner/versions#b1296

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira Service Desk

Wy are we still using email for Service Desk workflows?

...attest to the experience of an urgent approval that gets lost in the boss’s inbox and requires that special “Please Approve” email or text message. In an age where we have distributed teams...

104 views 0 2
Read article

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