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

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

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

3 answers

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 Community Leader Dec 13, 2019

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

0 votes
edwin vasquez Community Leader Dec 13, 2019

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.

0 votes
Jack Community Leader Dec 14, 2019

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

Suggest an answer

Log in or Sign up to answer
TAGS

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