JQL get second most recent version

Question

Hi,

I would like to get issues, with the value of the second, most latest version. We use it to print reports.

I know the function latestReleasedVersion(), to get the latest version, but I want the second most recent.

Does it possible to do it using JQL?

thank you

matthew_bache · Answer

@Arthas nova 
I am also trying to do what I think your question was asking: to find tickets in the fixVersion immediately preceding the most recent release. (Not the next unreleased fixVersion)
So for example, if you have:
1.1 (released), 1.2 (released), 1.3 (released), 1.4 (not released), ...
the JQL would pull tickets in 1.2

Did you find a way to do this?

Henrique Bittencourt · Answer

Hi Arthas!

So, about your question, unfortunately, there isn't a nextUnreleasedVersion() function to help you with.

Digging a little further on the JAC I've just found this feature request:

- Allow filter by "Next Unreleased Version"

But it was marked as fixed, please take a look into this comment.

Seems like you can search using the following statement:

fixVersion = earliestUnreleasedVersion()

Also, take a look into this comment:

This function appears to use the order of the "Versions" in the list NOT the dates associated with them. Also, note the list earliestUnreleasedVersion() function expects the next list to be ordered with the old/next versions on the bottom of the list with future versions on the top. (I.E. From top to bottom: Release 6 -> 5 -> 4 -> 3 -> 2 -> 1 NOT Release 1 -> 2 -> 3 -> 4 -> 5 -> 6).

Hope this can help you out.

Best Regards.