Calculate rank in column

Question

I want to save information about issue's rank per column when transition is performed.

For example:

I have column "Selected for development" with 5 issues ordered by "Rank". Highest issue is most important.

User performs transition to column "Doing" on issue in the middle of the column (so it is 3rd counting from the top).

I want to save information about issue being third in column "Selected for development" when transition performed.

Hubert Ciebiada · Answer

This solution will slow down or even crash your JIRA instance:

I calculated a field in SQL using "SQL+JQL Driver: Transform JQL into SQL" app. The field showed the current position in column (which is basically a status).

Using "Automation for JIRA" I saved this value to another custom field on transition.

I used "Rank" field in SQL which caused JIRA to crash. This is a known issue - I've reported it to CodeBarrel, author of "Automation for JIRA". Because the code was faulty I don't have it anymore.

GabrielR · Answer

Could you share the how friend?

Hubert Ciebiada · Answer

So far I managed to do it based on two custom fields:
- one calculates current position in column

- second is filled when transition is performed with value from first field

But it seems like a huge workaround. :/