JQL query - all the stories which has passed the fixversion but the status is not Released

[neelam annad]

JQL query - all the stories which has passed the fixversion releaseDate but the status is not Released

[Patrick S · Accepted solution]

@neelam annad 

There a couple of options when you use the ScriptRunner plugin. See below query for examples of using a version's release date, or release status.

(
   fixversion in releaseDate("before 1d") 
   OR fixVersion in releasedVersions()
)
AND (Status != Released)

The second half of that clause can be tweaked as needed to find "Resolution is empty" or Status NOT IN (Closed,Done), etc.

[neelam annad · Accepted solution]

I got the answer myself through the below query, not sure there is better way to do that.

project in (xxxxxx) AND issuetype = Story AND status not in (Released, Closed) AND "Story Type" not in (spike, "Release Readiness") AND fixVersion in releaseDate("after 2019-01-01 before now()")

[edwin vasquez]

What version of Jira are you in? The query fixVersion in releaseDate("after 2019-01-01 before now()") doesnt work for me

[Patrick S]

@edwin vasquez - In newer versions you can use something like this.

(
   fixversion in releaseDate("before 1d") 
   OR fixVersion in releasedVersions()
)
AND (Status != Released)

[Jack Brickey]

@neelam annad , I would be interested in hearing more on this. I am not aware of “releasedate” being an available field in JQL. The only option for fixVersion in JQL is either a specific version or releasedVersions() or U.N. releasedVersions(). Maybe “releasedate” is a custom field in your project or possibly something new has been released in your instance.

[edwin vasquez]

Hello Neelam,

I dont know that this is possible via JQL. If you go in to releases it will list all releases. The ones with the Release date in red are the ones past due. This will give you the name of all the versions that are not release and are past their release date. Maybe this will help. Let me know.