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