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
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 ...
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