Is there any way we can assign “current” to the fixVersion JQL?

Question

I have charts in Confluence that query Jira for the fixed version for each PI. I have to change the fixed version each PI to the new PI. What I would like to do is have a “current” JQL query tied to fixedVersion that will pull the current fixed version into the chart (possibly based on yearly quarters?) so I do not have to change the query every PI for every chart.

Current query we use on one chart: team = xx and issuetype = Risk AND  fixVersion ~ "*2023 PI3"

Query I would like for the chart: team = xx and issuetype = Risk AND  fixVersion ~ "*current"

I am fine using some other name besides "current" if needed (ie: currentFixVersion, etc.)

My team is Kanban and O&M so we have no releases and cannot use the earliestUnreleasedVersion() query to find the current fixed version.

No releases also keeps this query from working properly:

(fixVersion in startDate("before Now()") AND fixVersion in releaseDate("after now()"))

Carol Reeves · Answer

This is helpful. I was wondering if there was a way to relate fixVersion to a quarter of the year. IE quarter 1 is Jan, Feb, March, Q2= April, May June, Q3= July, Aug Sept, Q4= Oct, Nov, Dec.

I do not want to remove fixVersion as is, I just want to find a way to relate it to a quarter through JQL manipulation. This would allow me to relate a reoccurring time period to a fixVersion. Is this possible?

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

Versions do not have any concept of "current", unless you map it on to "unreleased versions", there's nowhere to tell Jira which ones you think are current.

Your queries with unreleasedVersions and earliest/latestUnreleasedVersions are probably the closest you are going to get.

For the no-release projects, there's nothing with the version to work with (at least until a Kanban team creates a release), so your query probably should be:

(fixVersion in startDate("before Now()") AND fixVersion in releaseDate("after now()")) OR (Project in (Kanban or O&M project) AND fixVersion is empty)