Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate rank in column

Hubert Ciebiada
Contributor
August 27, 2019

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.

1 answer

0 votes
Hubert Ciebiada
Contributor
August 27, 2019

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. :/

GabrielR
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 7, 2019

Could you share the how friend?

Hubert Ciebiada
Contributor
November 20, 2019

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.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, confluence administration, confluence admin training, confluence learning path, manage users and permissions, confluence certification, atlassian learning, cloud admin tools, streamline collaboration, confluence admin best practices

🚨New Confluence Admin Course Alert!

Manage Confluence like never before! This new learning path teaches you how to manage content, users, and permissions while optimizing user experience. Built for admins at all levels who want to confidently lead and unlock more innovative collaboration.

Learn more
AUG Leaders

Atlassian Community Events