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 votes

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
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

216 views 6 0
Join discussion

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