Is there a way to filter only issues that affect only a specific version

Question

For example, let's say project PROJ has versions A, B and C, and the following issues:

* PROJ-1 affects versions A, B
* PROJ-2 affects version A
* PROJ-3 affects versions A, C

I'd like to create a query that returns only PROJ-2, because it is the only one that affects *only* version A.

I tried something like affectedVersion = A AND NOT affectedVersion != A, but that didn't have the desired effect.

Thanks

Ori Gabai_ir19pc · Answer

Thanks again. I'll have a look at the workaround in this ticket.

Mirek · Answer

I am afraid we are facing this here:

https://jira.atlassian.com/browse/JRASERVER-25901

So unfortunately we would not get a perfect solution without for example using external addons that could include filter in filter.

Ori Gabai_ir19pc · Answer

Thanks, Mirek - and thank you for the welcome :)

Your suggestion does indeed work, but I think I wasn't descriptive enough in my question. I'm actually aiming for a... shall we say, scalable solution.

In other words, I'd like my query to retain its functionality even when new versions are added. That's why my initial thought was to try something like "affectedVersion = A AND NOT affectedVersion != A".

I should probably update the original question to reflect this.