You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Lets say I have releases 1.1 , 1.2 , 1.3 out of which both 1.1 and 1.2 are released, what is the JQL to show just the released versions.
So I need a JQL that returns only the released versions 1.1 and 1.2
You can use the releasedVersions function.
See https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html#Advancedsearching-functionsreference-releasedVersionsreleasedVersions() for more details.
thanks could figure that out
But one small clarification I want to take this JQL and set it as a filter to show on dashboard the list of release that are completed. when i set this filter it shows all the issues that are from all the completed releases, like I mentioned in the example I just want to see the fix versions
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can probably create a filter using this and use it in a pie chart by selecting fixVersion as the statistic type? That will list all the released versions with number of issues in it.
You can do similar things with 2D Filter Statistic gadget as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you so much @Jobin for the help
The syntax for releasedVersions is releasedVersions(project) but when I try entering the project name it throws a error.
The JQL that I was using is fixVersion in releasedVersions(Online Ops)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use double quotes if there is a space in the project name.
fixVersion in releasedVersions("Online Ops")
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.
I found the answer to my question above. Here is the syntax:
fixVersion in releasedVersions("Online Ops") OR fixVersion in unreleasedVersions("Online Ops")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm trying to get all released and unreleased versions, hence using the below query which is throwing an error
jql = f'fixVersion in releasedVersions() OR fixVersion in unreleasedVersions()'
I tried filtering using some projects like below(as I need release information for multiple projects)
jql = f'fixVersion in releasedVersions() and project in ("sampleproject1","sampleproject2")
This is returning some records, but it doesn;t retrieve all the released versions I see on the browser
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can alternatively use the Project Key without quotes, e.g.
fixVersion in unreleasedVersions(SSI, TAB, MIR, BS, DL, EB, SE2020, SE2021, TST)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the discussion here, it helped me build this JQL
`fixVersion in unreleasedVersions() ORDER BY updatedDate DESC`
It gives me all the tickets that are in unrealeased releases, not exactly what I want, as I'd love to have a filter based on releases as you all do.
However, if I could aggregate this query so that the Fix version was unique I could then hide all the ticket-specific columns and I would have what I want.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Saw a lot of "Done" tickets clogging up the filter, so I've revised my JQL:
`fixVersion in unreleasedVersions() AND status not in (Done) ORDER BY updatedDate DESC`
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Bharath Kumar @Stephen Musgrave @Jira Admin @AtlassianLearner @Mike Ellertson
i NEED a JQL to find the releases which are in certain period of time
Please do the need full
I am new to this part
Thanks in advance
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.