Hello, I'd like to use the JQL function releaseDate to target a specific day in the week, for example Tuesday of the current week without having to specify a specific day. This is used to dynamically populate a dashboard that shows all the issues scheduled for release on each day of the current week.
Basically, I want to write the equivalent of:
fixVersion in releaseDate("after startOfWeek('+1d') before startOfWeek('+2d')")
You can do this, but from my testing, you need to count backwards.
For instance, if I want all issues that have a fix version release date on Thursday, I'd write:
fixVersion in releaseDate("on endOfWeek(-2d)")
If I want all issues that are going to be released on Tuesday:
fixVersion in releaseDate("on endOfWeek(-4d)")
i am attempting to follow the logic here and am unable to produce any results. i am attempting fixVersion in releaseDate("after 2019-01-01 before 2019-09-15") and am just getting errors. do you have any suggestions for overcoming this? thanks in advance for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Ryan Anderson , you can try to your case:
fixVersion in releaseDate("after 2019-01-01") and fixVersion in releaseDate("before 2019-09-15")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunately, this does not work. Error below:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Whitney Patterson , you should add an "".
releaseDate("after 2019-01-01")
releaseDate("before 2019-09-15")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Alexander Bondarev Thank you, I did use quotations previously - I copy and pasted the query. See screenshot below. Same error. Is there something I am missing?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Wow! I checked on 3 Server instances - it's right.
But when I checked this query on Cloud - I got your error.
@Whitney Patterson , so you are an Jira Cloud user?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Interesting that JQL-syntax checker think that it is right query...
Try to ask that on Atlassian Support Portal. very interesting...
I checked list of JQL Cloud improvements here - there is no similar task.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Alexander Bondarev Ah, good point! Yes I am on Jira Cloud. Thank you for digging deeper - I will definitely reach out to Support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Whitney Patterson I am curious, did you hear anything from support on this issue? I would love to make this query work and I am on cloud as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am on Jira cloud and I am having the exact same problem that @Whitney Patterson was having. I would love to have a solution for this problem. Is there a fix or an alternative?
EDIT - Oh, it seems the official position of Atlassian is, "No."
https://jira.atlassian.com/browse/JRASERVER-22640
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have not received any help yet, but will be trying again. Still no solution for Jira Cloud.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi all, the "in releaseDate()" functionality is not native Jira, it comes from scriptrunner ;)
So if you don't have scriptrunner, you can't use this query.
See doc here
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there any way to have the Release Date displayed as a column in my query output? I want to see the Release Date connected to each of the JIRA cards I have listed. Thanks
Here is the query >>> fixVersion in unreleasedVersions() AND sprint in openSprints()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Casey Maynard
Did you find the answer ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
https://support.atlassian.com/jira-service-desk-cloud/docs/advanced-search-reference-jql-functions/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.