How is the JIRA Agile Lexorank field formatted?

We are building a JIRA Agile external integration where we need to use the rank of an issue on an Agile board to drive some business logic. The new Agile 6.6 rank custom field is fieldtype 'lexorank', and formatted strangely (e.g. 1|hyi4w0: )

I've read that that the '1|' prefix encodes the lexorank "bucket" and is used in "rebalancing" operations.

What about the rest of the encoding?

How can I convert the encoding to an integer that I can use in my business logic?

3 answers

1 accepted

This widget could not be displayed.

Hi, you would not need to decode the lexo rank field to determine the rank of the issue in the board. The value of the lexo rank is calculated by ordering the issues on the board lexicographically(dictionary order). As @Tom Jackson has pointed out. There are 3 buckets used in the process of lexicographically sorting the issues in the JIRA, hence the 1|, 2| and 3|. The rest of the characters and symbols are the product of the sort itself.

So if you need to order the issues they way it looks on the board in JIRA, you have to apply order by caluse to the lexo rank field/ sort this in your code. Ideally both in the database order by clause and the array.sort functions of any coding language orders your string alphabetically.

This widget could not be displayed.

did you get any answer to your question? I would like to know how to encode this rank value to order a list of issues manually.

This widget could not be displayed.

Pretty sure the encoding is just a string that can be alpha-sorted (after removing bucket prefix). Have a colleague that figured this out. Hopefully she will chime in with additional details...

Yes you are right - it can be simply ordered as string value! it seems to work..

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/ ExecStop=/opt/jira/bin/ TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,488 views 10 12
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