Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Components closed report

web-app

How to run a report that shows only components that have all issues closed?  Don't want to see the issues at all, just the component titles on a report?  Anyway to do that?
brian
· 1 		brian
Monday, January 15, 2007, 2:12:35 PM
Replies (7)
helpful
0
not helpful

If I understand you correctly, you want to see components that do not have open issues. If so, then no. You will have to do the opposite, filter by each component and check if it has open issues.
Saar Cohen
· 5000 		Saar Cohen
Monday, January 15, 2007, 8:07:18 PM
helpful
0
not helpful

Might you explain how to accomplish this?  I am still trying to learn the interface.

 
brian
· 1 		brian
Monday, January 15, 2007, 9:11:08 PM
helpful
0
not helpful

Actually you can see this from the project home page summary. Click on "Home" from the main page.

All components are listed and the number of open (not closed) issues are shown.
Saar Cohen
· 5000 		Saar Cohen
Monday, January 15, 2007, 10:54:02 PM
helpful
0
not helpful

OK I see that. THanks.

But is there a way to see this for all projects?  See a global view of it versus having to go in and see each project individually?
brian
· 1 		brian
Tuesday, January 16, 2007, 2:13:57 PM
helpful
0
not helpful

No, projects do not share component, so need for this.
Saar Cohen
· 5000 		Saar Cohen
Tuesday, January 16, 2007, 8:14:40 PM
helpful
0
not helpful

Can you recommend  a way to write a sql statements that would select all components that have all issues as complete?  Could this work?
brian
· 1 		brian
Wednesday, January 17, 2007, 2:00:02 PM
helpful
0
not helpful

The statment below will return all components that have no issues logged or have all issues with the status of closed:

select distinct c.compid, c.compname from components c
LEFT JOIN issues i ON c.compid = i.compid
WHERE i.compid is null or NOT EXISTS(select i2.compid from issues i2 where i2.compid = i.compid and i2.issstatus not in (select statusid from issuestatusfinal))
Mark Wing
· 9108 		Mark Wing
Wednesday, January 17, 2007, 2:57:36 PM