Fix version filter question

[Hemen Oza]

So, I have some issues with two fixVersions assigned to them - X and Y. I'm trying to write a filter that lists the issues that have ONLY one fixVersion assigned to them (X). Here is what I am writing to do this -

fixVersion in (X) AND fixVersion not in (Y)

Returns 0 results, when I know there are a few in this bucket.

Any ideas on what I might be doing wrong?

[Jobin Kuruvilla [Adaptavist]]

Query looks fine. Have you tried a full reindexing?