Reshuffling issues when one of them is edited

[Henri Tchoi]

Hi, 

I want to set up a simple automation to reshuffle issues when one of them is edited : basically, I have a custom field for the priority (1, 1.1, 1.2 and so on) and when we re-prioritize with my team, I would want all the issues with a lower priority to be shifted down one rank.

For example : let's say one issue is re-prioritized as 2.1, I would want the previous 2.1 and all the issues below to be shifted down to 2.2 onwards.

We had been previously manually shuffling epics around by dragging and dropping, but it is getting a bit too tedious and prone to errors.

If anyone has better ideas, I'm all ears, thanks in advance !

[Pablo Beltran · Accepted solution]

This would be supported by the Subversion ALM API and it would require you develop your own custom plugin in order to support that functionality.

All the JIRA-Subversion relationships are stored in KEYS table of the internal H2 database used by Subversion ALM. If an issue key-commit record is inserted (updated/deleted) in the KEYS table, the changes are immediately shown on the JIRA GUI (seeplease the animated gif below showing how to make that change by using the database web console)

Subversion ALM, shares the JDBC connection with 3rd party plugins. So you can get the connection from your own plugin and make any change in the index database according to your needs.

There is a public opensource example of a plugin showing how to use the shared connection. All the details are available from the Subversion ALM User Guide distributed with the plugin as well as from the plugin example on Google Code.

Hope this helps.

()