How to manage hundreds of versions

Question

Hi,

i am interested to know how to manage hundreds of versions efficient.
Since the first jira-version there is no possibility to filter

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.

Thanks
michael

Michael Kornatzki · Answer

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.

Contact Kintosoft · Answer

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.

Michael Kornatzki · Answer

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.