nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to sort backlog items using a scrypt?

Mariusz Bakalarz

I am working on a project where we would like to be able to automatically sort the backlog items (and I don't mean filtering them). I have no experience in JQL scripts but I know a scrypt can be utilized to sort the backlog automatically (for example every 24 hours).

What we want to achieve is to sort the items based on priority (in the easiest scenario). If possible, we want to be able to sort things by more complex conditions and levels, i.e. firstly sort them by the release number, then within those releases sort them by epic links and further within those, sort them by their priority.

Anyone can help with that?

Accepted answers

All comments

Sergey Gradovich_0k10v4

Not sure it's possible. But I'm subscribing for this thread.

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

You would need to build a REST API script that re-ranks your backlog in batches of 50, via https://developer.atlassian.com/cloud/jira/software/rest/api-group-issue/#api-rest-agile-1-0-issue-rank-put

I would very strongly recommend that you never do this. You are destroying the ranking your users have done in their backlogs, rendering the whole backlog functionality utterly pointless, and removing your team's ability to be in the slightest bit agile, because you're micro-managing them (and automating it!).

If you really want to have something that sorts your issues this way and can then be used to inform backlog refinement (not do it, just inform it), then I would

Take a copy of the board filter (let's say it is currently "project in (ABC, DEF) order by rank")
Exclude done items
Exclude active items (because you don't need these to inform your planning)
Add your sorting to it
Give it to the users as a saved filter, or even better, present it on a shared dashboard.

project in (ABC, DEF) and status not in (in-progress, done) and sprint not in sprint in futureSprints() and sprint not in openSprints() order by Priority, release, epic-link

You won't need to code anything, and the filter is dynamic, so you don't need to run it periodically.

Sergey Gradovich_0k10v4

If the question is on how to code JQL to filter out using different fields you can try something like this:

project = XYZ order by Rank asc, Priority asc, createdDate desc

Nic Brough -Adaptavist-

Bother, I forgot.

If you genuinely want to dump the backlog ranking functions, and treat it as though it is a queue, then it's actually quite simple.

Change the board filter from ending with "Order by rank" to "order by priority, release, epic-link".

There's no need to run a sort that way, it'll always be in the right order.

Mariusz Bakalarz

Questions is not about filtering but creating a scrypt to automatically sort the backlog items (automate a manual process of moving items around).

Mariusz Bakalarz

Hi @Nic Brough -Adaptavist- thank you for that answer. The thing is that this sorting is suppose to help the PO in managing the Product Backlog.

We do not want to turn the ranking system off, as we want to keep the dragging and dropping functionality.

Sergey Gradovich_0k10v4

@Mariusz Bakalarz in the Jira board you could either have sorting by rank and having ability to dragging tickets or via sorting by different fields, but you will lose ability to prioritize things over dragging stuff around.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud