09-26-2011 07:24 AM
Hi All, I just took a positon in the testing team using this tool. The team has a general reporting problem. What they want to see is: See a project's all -> Cyles -> test sets -> scripts from one report. I mean, cycles, under test sets, under scripts, and shows which tests and scripts ran properly, what percentage of the tests ran properly, etc. They have told from HP support that QC does not support this as default. A developer told me that QC test database tables are not related et all. When we generated diagrams within the MSSQL, there is no connection between the tables??We couldnt see any arrows..
(Before that I was working with VS testing, and In Visual Studio Testing, tables were related..),
Since HP QC is far more professional, I think HP QC must handle this in some way. Any Idea about this ?
By the way, I have read brochure of a tool called "Assure Project Harmonizer" for HP QC 10.0 . I am not sure whether this tool can help us on reoprting. Another thing is that right now we are using HP ALM - Quality Center 11.0, maybe some properties also added in version 11.0
Please somebody help me on this, thanks. Best Regards.
Solved! Go to Solution.
09-27-2011 08:12 AM
QC database tables are relational but there are no relations established by default. It is possible to create queries that join the proper tables to do the kind if reporting that you want. The query builder in the report module will help you create the SQL queries that you need to do this.
12-13-2011 04:21 PM
Can any one please help me. I want to create report with defect id and number of scripts blocked because of that defect.
Report should be like this.
Defect Id Number of scripts blocked
I have created query but its not working properly. Can any one please correct my query.
SELECT BUG.BG_BUG_ID, count(TEST.TS_NAME)
where BUG.BG_STATUS in ('New','Open')
and BUG.BG_TEST_REFERENCE= TEST.TS_TEST_ID
group by BUG.BG_BUG_ID
12-14-2011 11:04 AM
You should start a new thread for this question. Your question doesn't is not really on the same topic (yours is much more specific). Hijacking a solved thread with a new question off topic is generally bad forum etiquette. Also people are less likely to look at a Solved post when looking for posts that still have unanswered questions. :-)
(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)