Find all issues with watchers NOT IN a specific group

Question

Goal:

Find all issues in a given category with users in the watcher list which are not in a given Group

Given:

* Category C1
* Project P1
* Group G1, G2
* User U1

Project P1 is in Category C1 and User U1 is in the watcherlist of at least one issue in P1 and is only member of G2

Attempt:

* category in (C1) AND watcher = U1
* category in (C1) AND watcher not in membersOf("G1")

Expected result:

Both results should contain all issues from C1 where U1 is in the watcherslist

The second result should also contain all issues where users NOT IN G1 are in the watcherslist

Actual result:

1: delivers a list with the results where U1 is in the watcherlist

2: is an empty result

Why is the 2. JQL Query an empty result? I can not find all watchers in C1 which are NOT IN G1, but using a single users search i can ..

Edit: It looks like that the search with assignee is working, but not watchers.

jbeg · Answer

Hi Jack,

i did a re-index but get the same results. For testing purpose I made a second group (G2) with all users not in G1:

From the following queries, i would expect the same results:

* watcher in membersOf("G2") and category in (C1)
* watcher not in membersOf("G1") and category in (C1)

Query 1 delivers the correct results. Query 2 is still an empty result.. From my point of view, there seems to be a problem with the watcher field and the "NOT IN" query....

Jack Nolddor [Sweet Bananas] · Answer

Hi.

Not sure if there is any restriction with the watcher field. But most strange problems with JQL comes from an outdated cache, so could you please re-index your instance and try again?

Regards