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?
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
Welcome to your weekly Jira Ops Early Access program update, where we’re sharing news and updates on Jira Ops progress as we work toward our 1.0 release. If you ever want to drop us feedback or ideas...
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!
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