what would cause an issue on an Agile board to not have a record in the ISSUERANKING table?

Noticed that a couple of issues do not show up in the ISSUERANKING table contains one (and only one) record for each issue that appears on any Agile board within Jira, and contains a field indicating that issue’s direct ordinal child issue ID. 

Various theories could be if the issue is removed from JIRA or present across boards then this could lead to conflicts and hence resulting in an issue not being mapped to a rank.The remove scenario makes sense, but the issue being present across multiple boards should be a common scenario. Would like to know what is exactly happening.

4 answers

2 votes
Boris Berenberg Community Champion Jan 05, 2015

This is the old ranking method. Newer versions of the plugin now use LexoRank where the data is stored differently.

Ahh, so an upgrade would move to the new method, and leave historical (and redundant) data in the issueranking table. Another way to get an empty ranking. Thanks Boris!

Oops, that comment could be read as being sarcastic. It is not meant that way, it was a follow up to my answer (now converted to a comment) that suggested that there are several ways to get an empty line in that table. Most importantly, I mean to thank Boris for the *right* answer.

Boris Berenberg Community Champion Jan 05, 2015

Lol no worries. <3

I do understand what you're trying to do here, but I'm afraid you have gone down a route which is totally unsuitable. Reading a database which can (and does) change without consultation and warning is *never* going to be the right approach to anything you're trying to do. Please, stop looking at the database. Either use Jira as it's intended, and use the remote api (REST) to read the data when you;re trying to automate stuff. Forget lexorank, issueranking, jiraissue, banananana, it's wasting untold amounts of your time. Use the UI or REST. Ignore people who tell you to use the database, because they are almost certainly wrong.

Boris Berenberg Community Champion Jan 06, 2015

I really do agree with Nic, relying on DB consistency from us is a bad bet. If Nic's suggestion to use REST is not sufficient, consider creating a plugin for JIRA which exposes the data you need by getting it via JIRA's Java api. https://developer.atlassian.com/display/JIRADEV/JIRA+Agile+Development If you do not have the expertise to do this, there is a community of experts which can be found at: https://www.atlassian.com/resources/experts that do this kind of custom work.

I actually realized i can just apply order by clause/sort on the lexorank field for a particular issuetype of items to get the order in which they appear in that issuetype stack in JIRA UI.

0 votes

If an issue is removed from Jira, it is gone, dead, ended, there's nothing left, so you wouldn't need an entry for it (and the entry in that table should be removed).  

An issue being present in many boards really doesn't matter - the point of ranking is that it is a relative score, not an absolute score - you need to be able to say "this issue is higher or lower" than any other issue you choose to compare it with, but the actual number is irrelevant.

The ways I can imagine you'd get an empty ranking are:

  • Broken plugin
  • Accidental data corruption
  • Dodgy script
  • Ranking field does not apply to this project/issuetype
  • Multiple ranking fields in use and this one not relevant to this issue

I have seen all of those affect ranking, although I have never actually looked into the issueranking table to see how it works.  Also, my experience with it may well not be complete, there could be other reasons.

One other thought though:  If ranking is working for you, then the values in the database probably aren't of much real use, which leads me to wonder why you want to know?

Occasionally I see issues with no lexorank. If you search for that issue using some other field it doesn't show up in the search. Which suggests it got created but not indexed. This can happen if you Create transition uses a custom event so add an explicit Index post function you your workflow. I'm not sure what else can cause this but it goes away once the issue is edited in anyway

Sorry for the mangled text but the mobile view of this site doesn't let me edit

Thanks for the response guys smile i have been looking at the wrong table all the while i realize. Will have to come up with a method to decode the Lexorank table now. I am glad i consulted here before moving any further.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,718 views 17 21
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