Issue Details (XML | Word | Printable)

Key: JRA-1538
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: SnowWolf Wagner
Votes: 174
Watchers: 83
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
JIRA

Filter on Versions and Components across Projects

Created: 04/Apr/03 10:19 AM   Updated: Thursday 06:11 AM
Component/s: Filtering & Indexing
Affects Version/s: 2.0.2
Fix Version/s: 4.0

Time Tracking:
Not Specified

File Attachments: 1. Zip Archive JiraSearchableReleasePlugin.zip (17 kB)

Issue Links:
Duplicate
Part
 
Reference

Participants: Andrew Heald, Bogdan Calmac, Bogdan Dziedzic [Atlassian], Bogdan Ficner, Darren Fraser, Dejan Nenov, Gavin Bee, Gerhard, Gino Marckx, gunter zeilinger, Hugh Hart, Jeff Schnitter, Joe, John M. Black, Kevin James, Maarten van Wensveen, Mark Chaisson, Miles Duke, Nick Duncan, Patrick Ludwig, pete sirois, Rajiv Shah, Rick Watson, SIT Administrator, SnowWolf Wagner, Stefan Arentz, Stephane DURAND, Thomas McBurney, Vincent Eggen and Vita
Since last comment: 10 weeks, 2 days ago
Labels:
Support reference count: 30


 Description  « Hide
Would like to be able to save a filter that searches on Affected versions and or Fixed Versions across projects

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
gunter zeilinger added a comment - 10/Feb/04 03:08 AM
Updating due dates according release date of versions enables to use Due Date filter to find issues of several projects which are scheduled for versions with same release date

Kevin James added a comment - 28/Jun/04 10:44 AM
It would also be nice to be able to search Components across projects. We have several projects that share alot of code in a set of common libraries. These projects share the same Components. When I'm fixing issues in Project A for Component X, it would be nice to search across the other projects for any other issues against Component X to make sure I pick up anything critical.

Kevin James added a comment - 13/Dec/04 04:24 PM
What we REALLY need is a way to filter across projects on different versions. We have several projects that are released as standalone products. However, they are also bundled up and shipped as a bundled product or suite. Now we may be working on Suite 4.0 which consists of ProjectA v4.5, ProjectB v8.1.1 and ProjectC v7.3. We want to create a filter that would filter across the specific Fix For versions of these three products. Then we could call the filter Suite 4.0 and it would give us the stats we need. This capability would even be more valuable now that you have portlets that can give you stats based on a filter.

Right now we have a custom field called Bundled products that we use to generate this kind of filter, but users are always forgetting to set the either the Bundled Products field or the Fix For version or the choose the wrong Fix For version to go along with the selected Bundled Products. It just not an ideal solution.

I've entered this comment on several other issues including JRA-1578 and JRA-3554. Not sure where it makes the most sense, but this is a big stumbling block for us.


Nick Duncan added a comment - 25/Jan/05 11:30 AM
We have multiple projects going on, but we like to restrict roll-ins to bi-weekly windows. That means many projects aim at the same milestone. The best way I have seen to do that in Jira is to have each project keep a list of "versions" which are aligned with the global milestones.

But I can't find all the issues across the projects which are rolling in on a milestone.

Possibly we can build some sort of custom report, but I would certainly prefer to be able to just create a filter that does this.


Dejan Nenov added a comment - 26/Apr/05 01:46 AM
I add my vote to this issue - ability to filter across projects based on named version is very important.
In real life the model is many-2-many between proejct-version-component entities.

Gerhard added a comment - 26/Jun/06 12:21 AM
I'd like to be able to filter across projects for components which have the same name. In our projects one person is dedicated to a specific component which exists in all projects.

Hugh Hart added a comment - 28/Jul/06 02:02 PM
We have been struggling with this issue as well to the point of looking for other tools which do this better. The way we deal with it at this point is an SQL query to generate the list for a release and we dump it into Confluence manually. Here is the query we have been using it depends on similar version names. Enjoy!

SELECT '|' , VNAME Milestone, '|' , I.PKEY KEY, '|' , I.REPORTER, '|' , I.ASSIGNEE, '|' ,
decode(I.ISSUETYPE, 1, 'Bug', 2, 'New Feature', 3, 'Task', 4, 'Improvement', 5, 'Escalation', 6, 'Sub-task', 7, 'Question',
7, 'Reminder', 9, 'Deliverable') ISSUETYPE, '|' ,
decode(I.PRIORITY, 1, 'Blocker', 2, 'Critical', 3, 'Major', 4, 'Minor', 5, 'Trivial') PRIORITY, '|' ,
decode(I.ISSUESTATUS, 1, 'Open', 3, 'In Progress', 4, 'Reopened', 5, 'In Test', 6, 'Closed') ISSUESTATUS, '|' ,
I.SUMMARY, '|' ,
'['||I.PKEY||'|http://mantis:8080/jira/browse/'||I.PKEY||']' URL , '|'
FROM TESTTRACKPRO.VERSION V, TESTTRACKPRO.NODEASSOCIATION A, TESTTRACKPRO.JIRAISSUE I
WHERE ASSOCIATION_TYPE = 'IssueFixVersion'
AND I.ID= A.SOURCE_NODE_ID AND A.SINK_NODE_ID = V.ID AND instr (upper( V.VNAME), 'M617') > 0
order by I.PKEY


Stefan Arentz added a comment - 02/Feb/07 08:06 AM
I would actually like to do something different than a simple 'where version = 1.0' kind of filtering. I would like to be able to add tags to versions and then for example tag Project A v1.0 and Project B v1.5 both with 'Release Service FooBar' and then filter on that.

That way it is very easy to create big lists of issues for a specific release that consists of several projects with different version numbers.


Stephane DURAND added a comment - 02/Feb/07 08:13 AM
Quick comment: I do totally agree with Stefan. I have the case of "packages" which involve different project with different version number.
Stefan's solution would be fantastic if implemented !

Vincent Eggen added a comment - 02/Feb/07 08:25 AM
I addressed this need differently while waiting for the improvement: I added a custom text field called "Shared Fix Versions" and a workflow function that copies the issue fix versions to the "Shared Fix Versions" field. Then, it makes the life much easier to filter on the custom field instead of the fix versions when targetting multiple projects.

Vince


Gino Marckx added a comment - 13/Feb/07 06:10 AM
In my company, people are working on several projects, and want filters across these projects, showing only issues on specific versions. However, the only version specifications we need are the special ones: "Any", "No Fix Version", "Unreleased Versions" and "Released Versions" for both fix version and affected version.

This way, we can create shared filters showing "all issues to retest", or "all issues to fix" across multiple projects.


Gavin Bee added a comment - 21/Feb/07 09:48 PM
Based on what my company is looking for and Kevin's comment above, it seems like what is needed is the concept of a Product.

Products (or suites) are composed of several projects. A project may be included in several products. Each product version is linked to specific versions of each of its projects.

The best path that I can see to this is by expanding the product category feature. Allow a project to be in multiple project categories, add versions to categories, and then link category versions to project versions.

As far as we can tell the workarounds are less than ideal:

  • Add a "Shared Fix Versions" custom field as mentioned by Vince above. But having to set it on each issue is time consuming and error prone.
  • Export lists of outstanding issues for each project version and merge them together outside of Jira ... even more time consuming.
  • Use custom sql queries and custom reports external to Jira ... requires development time and could be broken by a jira upgrade.

Bogdan Ficner added a comment - 02/Mar/07 09:09 AM
Let me propose an idea - having "component scheme" and assigning that scheme to project would make possible 'sharing' components across various projects and maybe using schema component for issue filtering?

Joe added a comment - 12/May/07 06:18 AM
I agree to Gavin's conclusion. For our product organization we need to compose a product belonging to a "product line" from components that are managed independently from each other in separate projects.

As a first step having a text search field for versions when selecting multiple projects in Search would be very helpful.

In the long run introducing a product/product line concept would be the smart solution.


Thomas McBurney added a comment - 24/May/07 06:20 AM
For me, I think having the ability to specify more than 1 condition for a filter would do the trick. I want to see ALL issues created in the last week, regardless of current status, AND any issues with an "open" status regardless of when they were created, for instance. Right now, I have two separate filters for these and have to merge them outside of Jira. Would be nice to AND / OR several searches together and have them appear in a single filter.

Maarten van Wensveen added a comment - 20/Aug/07 08:42 AM
Any idea when we could expect this functionality in JIRA ?
Our company has been long awaiting this New Feature, and i know of some other company's using JIRA are really waiting for it aswell.

The ability to create more flexible filters could really enhance the reporting functionality and information that JIRA portlets would put out aswell.

This offcourse goes hand in hand with the abillity to create versions per components.


pete sirois added a comment - 28/Sep/07 04:17 PM
Over 4 years as a Major issue and still unresolved? Hey Atlassian, what's getting in the way of you taking action on this?

John M. Black added a comment - 16/Nov/07 10:46 AM
While the symptoms described here are slightly different, I believe solving JRA-1560 would address many of the needs expressed here.

If all 49 people watching this Voted for JRA-1560, it would move up to 3rd place.


Bogdan Dziedzic [Atlassian] added a comment - 19/Feb/08 09:42 PM - edited
In some cases, a possible work around this limitation could be to create a custom URL in the following way:
  1. From issue navigator create a search that returns for e.g. open Documentation issues for JIRA and grab the URL from [ Permlink ]
    http://jira.atlassian.com/secure/IssueNavigator.jspa?reset=true&&pid=10240&status=1&component=10120&sorter/field=issuekey&sorter/order=DESC
    
  2. Than the same for a different component e.g. open Documentation issues for Confluence
    http://jira.atlassian.com/secure/IssueNavigator.jspa?reset=true&&pid=10470&status=1&component=10315&sorter/field=issuekey&sorter/order=DESC
    
  3. Finally, add from the first URL the project and component references ( &pid=10240&component=10120 ) to the second one and create the following URL:

http://jira.atlassian.com/secure/IssueNavigator.jspa?reset=true&&pid=10470&pid=10240&status=1&component=10120&component=10315&sorter/field=issuekey&sorter/order=DESC

The URL constructed in this way should return all open issues in the Documentation components for both projects, which can be saved(filter) for further use.


Maarten van Wensveen added a comment - 25/Feb/08 02:07 AM
I agree with John on this one JIRA-1560 has defenatly got my vote.

Strange thing is, that all the issues i seem to vote for lately have been created 4+ years ago.
These are off course all major changes/improvements, but should really get the attention they need.


Darren Fraser added a comment - 25/Feb/08 10:52 AM
I also agree that Stefans idea would solve our main problems.

Bogdan Dziedzic [Atlassian] added a comment - 17/Jul/08 01:36 AM
for ref from a SAC case

Why this is high priority for us:
We use the same Version/s between different Project/s. We try to give or different software applications the same Life Cycle.
So at the same time we release version 2.1 of product A as we release version 2.1 of Product B.
But now we have no fast way to find all the issues for version 2.1 from both product A and product B.
We can only see all issues from product A or all issues from product B.


SIT Administrator added a comment - 17/Jul/08 02:03 AM
Hi, this is also an important issue for us.

Why this is high priority for us:
We use the same Version/s between different Project/s. We try to give or different software applications the same Life Cycle.
So at the same time we release version 2.1 of product A as we release version 2.1 of Product B.
But now we have no fast way to find all the issues for version 2.1 from both product A and product B.
We can only see all issues from product A or all issues from product B.

Furthermore there is another bug that makes the priority even higher:
The sorting on the Version/s column doesn't work this makes it even more important for us.


Bogdan Calmac added a comment - 17/Jul/08 09:20 AM
Same thing here. I cannot stress enough the importance of this issue. And to play the angry customer: "I can't believe this issue has been open for 5 years now!"

Mark Chaisson added a comment - 24/Jul/08 07:44 AM
I voted for this, we need this feature. I see that the custom URL workaround supports multiple pid=##### and component=##### in the URL, does it also support multiple versions?

Stephane DURAND added a comment - 24/Jul/08 07:56 AM
Indeed, I've used this workaround to be able to have a list of issues for different project-versions.
it works perfectly fine!

John M. Black added a comment - 24/Jul/08 09:23 AM
Mark & Stephane – What you are describing is not the same. By placing multiple PID, Component, Versions, etc. in the URL, you are essentially doing an "AND" query. AND queries have always been possible, even with the web interface the way it is presently.

What this ticket is really about (if I'm not mistaken) is the ability to do "OR" queries across different fields. Like, show me tickets that have "Affect Version = 1.2.3" OR "Fix Version = 1.2.3".


Stephane DURAND added a comment - 24/Jul/08 10:47 AM
John,

I think we were actually speaking about the same thing.
let's take the following url I am currently using for my projects as an example:

http://gdps-prod/jiraRF1S/secure/IssueNavigator.jspa?refreshFilter=false&reset=update&show=View+%3E%3E&pid=10331&fixfor=13292&pid=10200&fixfor=13105&pid=10210&fixfor=13295&pid=10371&fixfor=13294&pid=10400&fixfor=13293&pid=10212&fixfor=13336&query=&summary=true&description=true&reporterSelect=&assigneeSelect=&created%3Aafter=&created%3Abefore=&created%3Aprevious=&created%3Anext=&updated%3Aafter=&updated%3Abefore=&updated%3Aprevious=&updated%3Anext=&duedate%3Aafter=&duedate%3Abefore=&duedate%3Aprevious=&duedate%3Anext=&customfield_10020=&customfield_10030=-1&customfield_10010=-1&customfield_10050=-1

This url looks for the issues for several couple of projects - versions. Am I right to say it is a mix of AND and OR?


Jeff Schnitter added a comment - 21/Aug/08 03:36 PM
For what it's worth, my company is working around this issue as follows:
  • We created a custom field named "Company Version".
  • Most of our project share a screen scheme, so we added the custom field to the shared screen scheme so it could be used across all projects.
  • We created a Jelly script that runs every hour that looks at all issues that have been updated in the last hour. If the Company
    Version field value does not equal the JIRA version value it is updated to match the JIRA version value.
  • We then create filters that filter on "Company Version".

This allows us to filter across projects using the same version. It's not great but it allows us to get the data we need until
this feature is implemented.


Andrew Heald added a comment - 26/Aug/08 04:27 AM
Jeff, are you able to attach your jelly script to this issue? I'd like to use it (it would save me time) and I'm sure others might too.

Thanks in anticipation,
Andrew.


Vita added a comment - 06/Oct/08 04:41 PM
+1

Jeff, seeing your Jelly script would be very helpful as you're doing exactly what I need to do.


Rick Watson added a comment - 29/Oct/08 08:49 AM
+1 Gavin

Andrew Heald added a comment - 30/Oct/08 07:53 AM
Since my last visit to this one I've discovered a much better way of achieving this. I've written a "calculated custom field" plugin that creates a custom field that mirrors the fix version and shows up as a searchable field. Updates to fix versions immediately show up as updates to the custom field.

I'll publish details as soon as I can. The plugin would need a little generalisation if I were to publish the sources.


Miles Duke added a comment - 14/Nov/08 09:43 AM
Further development of Project Categories is a "nice to have". They seem like an afterthought, rather than a logical way to aggregate a set of projects.

However, I think rationalization of "Project Categories" is somewhat Orthogonal to this capability – the ability to do searches across multiple projects that have certain fields in common.

When/if changes are made to Project Categories, then a Search Field that lets you pick any category or some set of categories, would then be icing on the cake.


Andrew Heald added a comment - 21/Nov/08 06:43 AM - edited
I've been prompted to attach the very simple plugin I wrote to get round this issue. See JiraSearchableReleasePlugin.zip. It's a Maven 2 module and will need some coding to make it useful to anyone else. (Suggestions for generalisation and configuration welcome.)
Notes:
1. Though set up to buid against Jira 3.13 libraries it will work properly on a range of Jira versions.
2. You'll need to set up http://maven.atlassian.com/public as a repository in your settings.xml.
3. This custom field is only really of any use in searches. The text name of your versions in different projects will have to be exactly the same for this to work. This plugin (as is) also allows a suffix "Approved" to be added, so for example "1.3 Approved" in one project willl be equal to "1.3" in another.
To use:
1. Copy the built JAR to atlassian-jira/WEB-INF/lib.
2. Restart Jira.
3. Add a custom field.
4. Reindex the Jira database.

Patrick Ludwig added a comment - 21/Jan/09 07:05 AM
When do you expect to release the version 4.0 with this new usefull feature?

Rajiv Shah added a comment - 23/Apr/09 08:33 AM
My vote for getting this implemented for fix version and components, specially if the projects belong to the same project Category.