Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

A single JQL for all jiras I'm looking at?

aakash.alurkar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 12, 2021

Currently I'm tagged in multiple JIRAS and it's easy to miss some of them. To solve this, I have written a custom JQL which pulls up a list of every JIRA which mentions me, where I'm watcher, assignee, owner etc.  

It's like - reporter = currentUser() OR assignee = currentUser() OR "Owner = currentUser() OR watcher = currentUser() OR comment ~ currentUser() ORDER BY updated DESC

the main problem with this is that if I have commented on a 6 month old jira and someone comments on it in the last day then it's at the top of my list which is annoying as that jira has been closed from my end. Any tips on how I can further optimize this query?

2 answers

0 votes
Aron Gombas _Midori_
Community Champion
August 12, 2021

Maybe adding another condition using the updatedBy() function (with your user name and with an eventual period) could improve filtering. It doesn't affect ordering, but may help...

aakash.alurkar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 13, 2021

thanks I'll try it out

0 votes
Iago Docando
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 12, 2021

if you just want the old issues where you're mentioned not to jump to the top of the list but you do want the rest of the issues to be listed from more recently updated to less recently updated I can only suggest maybe using two different JQLs and have a different gadget show each one.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events