Find all issues related, and ordered, by multiple queries

OK, so I've used JIRA for quite a few years now but here's a new one I don't know how to solve!

Business problem - about 40 projects, each with a few issues in them.

I want to see one list where all those issues are displayed in the correct order, based on (this is the abridged version, I've actually got a list of 12 queries/priorities):

 

First tickets in the list should be Priority = Critical

Second tickets in the list should be DueDate is this month and they have a label of "SLA"

Third tickets in the list should be Category of "Project" and (not billable and label of "additional")

Third tickets in the list should be Type = Bug

So I'll end up with maybe 300 tickets displayed, of which all the first lot are priority critical, and then the ones due this month and so on.

 

How do I do this? smile

1 answer

0 vote

There's no way to sort on a list of completely arbitrary unrelated rules.  Imagine you've got a simple instruction for "sort by colour" and your list contains "Red, Blue, Cat, Yellow, Teapot".

You'll need to do some mapping (such as "all cats are black" and "all teapots are brown"), and that's going to need code.  A basic approach would be a scripted or calculated field (I say Scripted because I've always reached for the Script Runner to create such fields) that does:

if (priority = critical) return 1If (duedate = this month and label = SLA) return 2
if (category = project and (not billable and label = additional) return 3
If (issuetype = bug) return 4
<and so on>
return 99999

You'll be able to sort and search by that result automatically if you use a SR number scripted field

Hey Nic - thanks for the reply.

 

This sounds sensible, but the only problem would be that the view/list of issues is calculated as it loads but surely the calculated fields are only calculated every so often (how are they triggered?)

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Fadoua M. Boualem
Published Monday in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

499 views 8 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you