Sort by "Watched" / "Not Watched" for items of equal Priority?

pauthompson_caci

Current search query:

( assignee = currentUser() OR watcher=currentUser() ) 
AND 
resolution = Unresolved 
ORDER BY priority DESC, updatedDate DESC

For items of the same priority, I want the items where I'm the Assignee to appear above items where I'm a Watcher.

So something like this as the second condition in the "ORDER BY" clause.  ORDER BY would need to allow sorting on integer values:

If ( assignee = currentUser() ) {
  If ( watcher = currentUser() ) { return 1 } Else { return 2 }
} Else { return 3 }

 

Kian Stack Mumo Systems

@pauthompson_caci, you cannot do that. One option might be to create two separate filters, one returns issues where you are the assignee and one returns issues where you are a watcher. you could then place both filters onto a dashboard so you can see both sets but know which ones you are the assignee on and which ones you are the watcher on.