Ordering backlog tickets with JQL

Question

Hi there, I'm working on 3 big (around 1000 open tickets)  and old backlogs because the PM left recently.

I would like to sort things a bit to ease the work of prioritising tasks and bugs for the next sprints.

To do this, I wanted to sort all my bugs following the following formula:
"priority - day since creation", and the higher the score, the more I should look into the task to either re-prioritise it or maybe simply close it.

I can easily use JQL and Python to do that, but I would like to be able to move up or down my backlog the tickets one and for all following this formula because we're mostly looking the backlog as is to prioritise our following sprints.

Is there a way to move up/down inside a sprint tickets with JQL ? (I created a "Bugs" sprint just to sort them).

Thanks a lot

Jean Julien Zeil · Answer

I started the script and my oldest bug never treated is 1372 days overdue :x

Jean Julien Zeil · Answer

The priority is not enough for me right now.
I want to prioritise a "priority: 2d" ticket opened 10 days ago after another "priority: 2d" from 2 month ago.

That's why I thought about calculating this in a script then re-ordering in the backlog accordingly.

Tarun Sapra · Answer

Hello @Jean Julien Zeil

Based on the priority score, you can assign a sprint to the ticket. And since you have sprints created in a specific order in the backlog hence once the sprint has been assigned to the ticket then it will automatically be available in a specific section of the backlog.