Lexorank ordering issue

[henry ha]

I am encountering an issue when attempting to sort by Lexorank for my issues. When viewing the issues in Jira and ordering by 'Rank', the subtasks are sorted right under the parent. The only problem is, once i've exported the data to CSV and look at their rank (the field name is 'Custom field (Rank)', the sorting does not work the same as in the UI. This is a problem as I am pulling these tickets via API and i'm not able to retain their sorting behavior like in the UI, so i need to rely on sorting in SQL or Excel. When doing this, the subtask are not ordered next to their parent properly. Any idea whats going on here?

[henry ha]

I did some further investigation on this and it appears to be caused by users reordering the rank on the jira board. This is still strange to me as it still groups properly when sorting by rank in the UI, just not when you are sorting it on the rank column outside of Jira.

Still no solution on how to do it outside of jira..