How to retrieve the test sets - test instances - results within particular folder/path in Quality Center

Many times , you would be running the tests in multiple test sets and with multiple instances. Those multiple test sets would be in different folders under and under different hierarchy

Quality center has option to get this information using Analysis graphs, and thus you would be able to find what is the progress of each test set. But is has its own limitations. Like, if you want to find which test in each of sets is failed, or who has been the responsible tester for those tests , or any more information, then we are handicapped using Analysis reports.

Well , if you learn the excel reports, you life would be made easy. I have briefly mentioned on How to access excel reports in one of previous blog

So how shall we do go ahead?

How to retrieve requirement - test case - linked defect using excel reports

QC 9.2 has feature called excel reports. This feature is very versatile as you can retrieve complex data which simple reports or graphs from QC will not be able to do. One of the report that may be useful for any testing project is to find which all defects are linked to test cases and these test cases are covering which of the requirements. This will give you data that can be used to address which defects are more severely effecting your testing progress and resolving a defect what requirements/test cases you can quickly progress.

Here below is entity relationship diagram that you can find in HP quality center database reference. It is one of the help documentation available in QC.

For folks who not sure how to access excel reports in QC , follow below steps you will be amazed to find this feature.

Login into QC with project and domain. Then click on Tools and next select excel reports. It will open up another window. In the top menu , there is + button which on clicking will open report. You can make that report public or private.

TEST - REQUIREMENT ER DIAGRAM

First time fix failures or Reopen defect from QC

In quality center, for your project analysis, it would be useful to find how many defects reopened. As you might be aware that , due to defects and not so good work from developers, your testing progress gets hampered. But how will you be able to quantify like the defects most of them were reopened and users had to do more of regression and testing? For this, metrics of Reopen defect is quite good and will justify that there was more of testing required than expected.

How to retrieve Quality center bug details ?

The main table in quality center for defect related info is Bug table. This table stores all the recent /current bug details . There are few columns within this table which would of your interest. Below are columns for reference

BUG.BG_SUMMARY /*Defect.Title*/
BUG.BG_RESPONSIBLE /*Defect.Assigned To*/
BUG.BG_CLOSING_DATE /*Defect.Closing Date*/
BUG.BG_DEV_COMMENTS /*Defect.Comments*/
BUG.BG_DETECTED_BY /*Defect.Detected By*/
BUG.BG_DESCRIPTION /*Defect.Description*/
BUG.BG_BUG_ID /*Defect.ID*/
BUG.BG_USER_32 /*Defect.Defect Status*/
BUG.BG_PRIORITY /*Defect.Priority*/
BUG.BG_PROJECT /*Defect.Project*/
BUG.BG_SEVERITY /*Defect.Severity*/

QTP Actions VS Functions

 There has been debate over on whether to use QTP actions or Functions. Before presenting my opinion, let me present what they are and how they stand out.



QTP actions
- Are of three types Non reusable, reusable and external.
- Each action has local respositary associated with it
- Each action has local datasheet attached with it
- Each action call has to be inserted and cannot be dynamically called. There is concept of having relative path with QTP components, but it hardly works consistently with QC ( Where you require most as it is difficult move scripts around in QC)
* In QTP 10, there is new feature introduces which is called LoadandRunaction. There gives relief to folks who were using relative path for referring actions or have storage and development of scripts in different location

Simple VB Script that interacts with QTP and excel

'HI..here in this tutorial we gone try how to create a VB script which
' launches qtp and open the test which you have specified in the excel


'First we shall create a constant that points to the excel where it is located
' in local drive

VBScript - 8 .Run the test

This is last blog related to creating Batch run VBS script. Here there are few simple steps you need add at the end so that QTP application, which has been opened, connected to QC and has test loaded , needs to execute the test.


In previous blog Set Test results options we created ObjresultOpt object. Assigned it which instance the result should be stored. Now comes its actual use where in you tell the QTP to run it with this options.

How to get started of VBscripting for QTP automation

For many who want to more of automation and just know how to use QTP a bit,  I thought i will just write few things you can start off which helped me to learn more of VBscript. 
I refereed book VBScript Programmer's Reference most of the time while learning. It helped to master things a bit

VBScript - 7 .Set Test results options

Set objResultsOpt=CreateObject("QuickTest.RunResultsOptions")    'Set Result options

objResultsOpt.ResultsLocation = ""

objResultsOpt.TDTestSet = QC_TEST_SET ' Test set name'

objResultsOpt.TDTestInstance = Instance ' Test instance in the test set. Generally it is one unless you have pulled the same test twice in same test set.

appQTP.visible=True

  

VBScript - 6 . Setting Global Options of QTP script

Here below parts of code, we will look at important setting you ought to do have better QTP execution.

Part 1
Set objTest=appQTP.Test.Settings.Run    'Set Run time settings
objTest.ObjectSyncTimeOut="60000"
objTest.IterationMode="oneIteration"
objTest.OnError="NextIteration"

Quality center QC not working in IE8 - windows XP/ Vista / Windows 7

Quality Center not working in IE8 - Win XP or How to Disable Data execution prevention (DEP)?

DEP is enabled by default in IE8 for win xp . This prevents code from running in memory that is marked non executable ( I guess QC or QTP does have some sort of this kind of code or IE is not analysing the code properly) . Hence the QC would not be able to run.

SO how to disable DEP this?

Advantages of Automation

                                                     

•                                                         Time consuming                      Speed
•                                                         Low Reliability                        Highly Reliable
•                                                         Inconsisent                              Reusable
•                                                        More Human resources            Programming capability
•                                                                                                        More Coverage
•                                                                                                        Repeatability

VBScript - 5 Assign Test Parameters to QTP script

This blog is in sequence with my previous blogs and they are shown below.

VBScript - 1 . Launching QTP
VBScript - 2 . Connecting to QC/Open QC test
VBScript - 3. Add Resources of the Script

VBScript - 4 Add Recovery Scenario

Here we shall look how to intialize the test parameters.

ISTQB Info

ISTQB- International Software Testing Qualifications Board

Why ISTQB required?

Although like  for all certifications, you may get very question that would arise is it worth taking and certifying yourself about the knowledge you already know,  but this would does make the other person ( your manager, interviewer, etc.) think are very much capable. Though in India , where there are not many professionals who would have had the certification, but it certainly puts you conspicuous in a lot. Would surely help the other person that you would make difference.