How to use the releaseDate function for a specific day of week

[Ron L]

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

[Joshua Yamdogo @ Adaptavist · Accepted solution]

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

[Ron L]

That works great.  It seems like the issue was the single quotes I was adding around the parameter to startOfWeek() that was causing the error.

[Ryan Anderson]

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. 

[Alexander Bondarev]

@Ryan Anderson , you can try to your case:

fixVersion in releaseDate("after 2019-01-01") and fixVersion in releaseDate("before 2019-09-15")

[Whitney Patterson]

Unfortunately, this does not work. Error below:

• Unable to find JQL function 'releaseDate(after 2019-01-01)'.
• Unable to find JQL function 'releaseDate(before 2019-09-15)'.

[Alexander Bondarev]

@Whitney Patterson , you should add an "". 

releaseDate("after 2019-01-01") 

releaseDate("before 2019-09-15")

[Whitney Patterson]

@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?

[Alexander Bondarev]

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? 

[Alexander Bondarev]

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.

[Whitney Patterson]

@Alexander Bondarev Ah, good point! Yes I am on Jira Cloud. Thank you for digging deeper - I will definitely reach out to Support.

[Brandon Pierce]

@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.

[Ryan Clark]

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

[Whitney Patterson]

I have not received any help yet, but will be trying again. Still no solution for Jira Cloud.

[TTuteleers]

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

[Casey Maynard]

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

[Jamil Rahimov]

@Casey Maynard 
Did you find the answer ?

[Henk Smets]

Did you got a solution?

[Henk Smets]

This works: latestReleasedVersion()

https://support.atlassian.com/jira-service-desk-cloud/docs/advanced-search-reference-jql-functions/

[Whitney Patterson]

@Henk Smets Unfortunately No, I have not.

[Katiana Montoya]

👍