Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I use the release date of a version in JQL?

Hey friends,

 

I'm trying to construct a query that will provide a list of issues that were created for a certain version up to three months after it has been released.

I accessed the relevant project, and under 'Versions' I found the list of released and unreleased versions, and saw that they had a column of 'Release date'. Great!

I went over to the advanced search and have tried to use it, and couldn't for the life of me find a way to reach that field.

Essentially, this is what I'm building:

issuetype = Bug AND project = <project> AND affectedVersion = <product version> AND "Bug source[Dropdown]" = Customer AND createdDate <=  ??

Just to make it clear, if I remove the createdDate part, I get all of the bugs that were created for this version. 

Ideally, I'd like to add something like "createdDate <= releaseDate(<version> + 3M)"

Any ideas?

 

2 answers

0 votes
Jack Community Leader Jul 19, 2021

Unfortunately the version release date is not a field that can be used within a JQL. The reason for this is the release date is not stored for every issue. So if you want to make your current JQL work you would have to use a static release date. The other option would be to create a custom date field and every time you make a release populate the actual date into that field. Then you could use your custom release date. Of course the downside of this is that either you would have to go back and populate the release date for all the storage issues or just live with this working going forward.

Fair enough.

Then if I go ahead and manually populate the release date in the query, is there a function that I can use to get only three months after that date?

To clarify, let's assume that the version release date was November 1st, 2020.

Can I structure something like the below?

createdDate <=  "2020-11-01" + 3M
Jack Community Leader Jul 19, 2021

Why not simply…

createddated <= 2021-02-01 and createddate >= 2020-11-01

Honestly, because I'm going to repeat this for a large number of versions and the less I manually type the dates, the sooner I finish this day.

Alright, I'm going to give it a go. Thanks!

hi @Eitan 

I don't see any native solution.

One way to cover your need would be to implement this JQL function with ScriptRunner : https://scriptrunner.adaptavist.com/latest/jira/custom-jql-functions.html

Regards,

Cyrille

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

497 views 2 17
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you