JQL Query for Affects Version

[Malisha Thapa]

Hello Team,

I am trying to filter out all the issues that are related to a specific version.

For example: I have project ABC and Affects versions 4.1 to 4.10. I would like to filter the issue that has been created for the above versions, nothing more or less.

I tried the query as project = ABC and affectedVersion >= 2.1 AND affectedVersion  <=2.1.027

This shows results for 3.1 affects versions as well.

Could anyone help me with this request.

Thank you,

Malisha

[Kalyan Sattaluri]

Hello @Malisha Thapa 

Instead try wilcard search:

project = ABCD and affectedVersion ~ "4.1*"

[Florian Bonniec]

Hi @Malisha Thapa 

The logic used behind > < when using them on version field is not the name of the version but the order they are in the Version config page.

The comparison operators (e.g. ">") use the version order that has been set up by your project administrator, not a numeric or alphabetic order.

Advanced searching - fields reference | Jira Software Data Center 9.15 | Atlassian Documentation

In you case you have to re-order the versions or list them all using in (...,...,...)

Regards

[Malisha Thapa]

Thank you for your response.

I need this issues to be filtered for 1 Project and I have like multiple projects. 

Regards,

Malisha

[Florian Bonniec]

You have to add filter by project AND project = "Your Project"

[Laurie Sciutti]

Hi @Malisha Thapa ~ assuming your versions are sequential, the following would be the easiest and quickest:

project = ABC and affectedVersion in (4.1, 4.2, 4.3, 4.4, 4.5, 4.6, 4.7, 4.8, 4.9, 4.10)

[Malisha Thapa]

Thank you for your response.

Yes, you are correct it is in sequential. As per your suggestion let’s say we have affected version starting 4.1.1 4.1.2, 4.1.3 till 4.1.030, then I have to enter the entire version in the query manually to get all the issue belongs to above versions, but adding query like “project = ABC and affectedVersion >= 4.1 AND affectedVersion <=4.1.030” .

This wouldn't help is that right understanding.

The query does help to filter the issues which has 4.1 affected versions, but also 4.2, 4.3 as a results.