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

Question

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?

Aakash Alurkar · Answer

thanks I'll try it out

Aron Gombas _Midori_ · Answer

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

Iago Docando · Answer

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.