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

pauthompson_caci January 20, 2021

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 }

 

2 answers

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 3, 2022

Hi @pauthompson_caci  - Did you ever get this solved? 

0 votes
Kian Stack Mumo Systems
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 20, 2021

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

Suggest an answer

Log in or Sign up to answer