OK, it turns out that the Global Rank is held as a linked list, making evaluating specific "Global Rank Value" more difficult.
A bit more digging turned up this answer, which I will play with: https://answers.atlassian.com/questions/96142/how-to-get-sprint-issue-list-by-sql
Hey there, Yunfeng.
I believe that you are referring to the AO_60DB71_ISSUERANKING table here. As we can see from the structure:
So, if you want the Rank of an issue, let's say the issue ID is 10004, it can be something like:
SELECT ID FROM AO_60DB71_ISSUERANKING where ISSUE_ID = '10004';
Hope this helps.
If I understand Danial correctly, then the 'ID' of the AO_60DB71_ISSUERANKING table is actually the 'RANK' of the issues. Take the SQL query that he has provided as an example :
This query would return the 'RANK' of the issue that has the issue ID of '10004'. Hope this clears things up a bit :)
Sorry to open this old question again, but I am having the same problem.
For example, I have an issue ID 18892 corresponding to a key ABC-123.
If I use your SQL above I get a rank of 7944.
If I create a filter in JIRA and select to display the Rank column, the rank number shown for that issue is 849.
If I use SQL to see what issue ID has rank 849, it is not the issue ID that I'm looking for.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot