AffectVersion and Affect/s Version values mismatch

[Tal Kdoshim]

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

[Mahesh Shinde]

Hi @Tal Kdoshim :

You are correct, AffectedVersion is used in JQL to find out the tickets with those versions.

May I know, what you are searching in JQL and what you are getting results?(any screenshots)

Here is the example to get specific affected version tickets using below JQL

"affectedVersion in (6.2.1,6.2.4)"

Regards,

Mahesh Shinde

[Tal Kdoshim]

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

[Mahesh Shinde]

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]

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

1. 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
2. the main problem is that i get this error "The value '6.0.*' does not exist for the field 'affectedVersion'."