AffectVersion and Affect/s Version values mismatch

Question

Hi, to my understanding AffectedVersion JQL field inherits its value from Affect/s Version field, is that correct?

When querying AffectedVersion (as there's no option to query Affect/s Version field) we got different values than the ones displayed in Affect/s version - anyone knows why? or can explain how we should query certain affected versions?

Thanks in advance

Tal Kdoshim · Answer

Hi @Mahesh Shinde , when trying to use affectedVersion ~ "6.1*" instead of versionmatch function I encounter 2 issues:

* the expression ~ doesn't support a list of values so need to write (affectedVersion ~ "6.1*" OR affectedVersion ~ "6.2*"..) and its a long list - but possible
* the main problem is that i get this error "The value '6.0.*' does not exist for the field 'affectedVersion'."

Mahesh Shinde_k4hefc · Answer

Hi @Tal Kdoshim :

Thanks for the response.

You can use contain operators (~ and !~) with wildcards which can give you exact matches for issue results.

For eg.

affectedVersion ~ "6.1*"

Link document: https://confluence.atlassian.com/jiracoreserver0822/advanced-searching-fields-reference-1141970402.html

Regards,

Mahesh Shinde

Tal Kdoshim · Answer

Thanks @Mahesh Shinde

Here's the JQL:

Project in (XXXX) AND issuetype in (Improvement, Bug) AND "Documentation Impact" = "RN Open Bug" AND affectedVersion in versionMatch("6.0.*|6.5.*|7.0.*|7.5.*|8.0.*|8.5.*|9.0.*|9.5.*|10.0.*|10.5.*|11.0.*|11.5.*|12.0.*|12.1.*|12.2.*|12.3.*|12.4.*|12.5.*|12.6.*|13.0.*|13.1.*|13.2.*|13.3.*|13.5.*|13.6.*") AND ("Verified Version/s" not in versionMatch("13.6.*") OR "Verified Version/s" is EMPTY) AND ("Skip Verify Version/s" not in versionMatch("13.6.*") OR "Skip Verify Version/s" is EMPTY) AND (labels != BD-RN OR labels is EMPTY) AND "RN Bug Description" !~ couchbase

some of the results to this query were bugs with Affects Version/s = 14.7 for example, which shouldn't be there. the structure of our versions is "( 14.7.0.10 / xxx-xx / 2022-Q1 )" for example