Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Carol Reeves July 25, 2023

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

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()"))

 

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 26, 2023

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)

Carol Reeves August 7, 2023

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?

Suggest an answer

Log in or Sign up to answer