Move card to top of column after transition of status

Question

I want to move a card to the top of the TODO column when moving the card from "Reviewed" column to "TODO

Is there a way for doing this using Jira web interface? I am learning the automation tools and I was able to find a way to make the status change trigger, but none of the actions seemed to be the one I am looking. This would be very usefull since the card is beeing moved to the bottom of the column. If there is no way for doing this with in the interface, I'll police myself to move the card insted of changing the status directly on the card such as in the previous image

Bill Sheboy · Answer

Hi @Raphael Fernandes

That is possible in an automation rule, although it is a bit complicated...

Let's assume your Jira board uses a filter based on ORDER BY Rank ASC, which is the default sort order to allow drag-and-drop of issues on the board.  And so the thing you need to change is the Rank.

But Rank (also known as LexoRank) is not a simple number value, and so the way to re-order things programmatically is relative to one another, calling a REST API function.

And so an outline of the steps to do this is:

* find the issue currently at the top of the TODO column, using JQL, and store that with the Lookup Issues action
* call the REST API function to rank issues, passing your new issue and the one at the top of the TODO column

Some references to get you starting on trying this are...

Calling a REST API function with an automation rule: https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

The specific REST API function for ranking issues: https://developer.atlassian.com/cloud/jira/software/rest/api-group-issue/#api-rest-agile-1-0-issue-rank-put

Kind regards,
Bill