How to manage hundreds of versions


i am interested to know how to manage hundreds of versions efficient.
Since the first jira-version there is no possibility to filter sad
But in the old days all the versions where shown and one an use CTRL+F and serach but now?

Can i get rid of the annoying function of "paging" (i know it's not paging but i don't know how to name it) the versions. I want to load and see all the versions.


1 answer

SQL for JIRA might help you. It allows you to explore project versions easily by using standard SQL.

Have a look please at the advertising video (1 min) and pay attention to the latest query.

If you like SQL for JIRA, the complementary plugin "Birt Reports for JIRA" may help you to create advanced reports for your versions:

Thanks for the answer, but you misunderstood the requirement. I wanted to know how to manage (add, edit, ...) not only to view versions via jql.

Well, the summary/title is enough clear. However, the detail of the questions puts the focus on reporting clearly. I would also like to differentiate among version METADATA (name, start and end date, release status) and the version CONTENT (what are the issues belonging to a version?). I guess you mean version CONTENT management. SQL for JIRA allows several approaches to get version contents according to the underlying JIRA Java API. You can filter ISSUES via JQL as mentioned and then join the rest of the tables or you can start by the PROJECT table and join it to PROJECTVERSIONS and ISSUEVERSIONS, for instance. What are the issues released by your company in the last week? And by project? And by issue type? and by reporter? or by whatever other criteria? Those are questions that SQL for JIRA answers in seconds as well as making any report of all your versions and releases along the time filtered, ordered and grouped by any criteria. In my opinion, JIRA is enough good to manage a single version (metadata and content) via the web interface or the REST API. However it would be difficult via web interface for massive versions and REST becomes tedious and inefficient because it would require coding to fetch the data and a lot of calls to the server (get projects, for each project get versions, for each version get issues and then operate with them to filter, count, etc.). This is nicely supported by SQL for JIRA because everything happens on the server side: it is very efficient, flexible, simple and powerful out-of-the-box and without coding. In my opinion, tracing massive version contents is the difficult and interesting part and it is nicely supported by SQL for JIRA. However, I agree it would be also nice to support adding and removing issues to/from versions via SQL. This will supported in the 2.0 version.

Thanks again for clarifying and your detailed answer. I understand that my first post was not clear enough. I mean the manage version view (http://svr-jira:8080/plugins/servlet/project-config/???/versions) in the administration backend. In your terms the Metadata. And this is getting worse in the new version (i don't know jira 5 and work before with jira 3 and 4) as i described in the first post. How did the version manager work with this kind of view with hundreds of versions? I am also thinking about a desktop-client to get rid of the view. Hopefully this behaviour in the manage version view is disableable in the future.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,305 views 5 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you