Frequent Contributor.. jul_2 Frequent Contributor..
Frequent Contributor..
5166 views

QC Test Lab: Planned Execution date vs. Execution date

Hi Everyone,

 

We are running test execution cycle and need graph how many tests were planned to be executed and how many were actually executed.

 

QC allows to run graphs if History fields are enabled. There for I enabled History on Status, Execution Date, Planned Execution date under Test Instance.  When  am trying to create graph against test instance I still can not choose Execution Date, Planned Execution . Fields are just not there.

 

I am able to create report. But report you can export only in txt, not excel. When I am trying to create excel report, I am getting lost in tables connections as we need filter data by Test Set Folder.

 

Ultimate goal is to get graph Planned vs. Executed date for test sets.

 

Did somebody had same issue?

 

Any ideas how to get graph?

 

Thanks a lot,

Julia

0 Likes
8 Replies
Bodhi Absent Member.
Absent Member.

Re: QC Test Lab: Planned Execution date vs. Execution date

Sorry for the shorrt reply. I am trying to hunt for the solution for quite some time. If anyone has a solution for this please let me know.

Thanks,

Bodhi

0 Likes
Absent Member.. YValenzuela Absent Member..
Absent Member..

Re: QC Test Lab: Planned Execution date vs. Execution date

Ohh man you have no idea how many day i spend looking for this also.

The solution is here:

http://www.qualitycenterstepbystep.com/2012/hp-qc-test-set-report-by-folder/

 

Kind regards

0 Likes
Highlighted
Absent Member.. Steve Barnash Absent Member..
Absent Member..

Re: QC Test Lab: Planned Execution date vs. Execution date

This would be a very beneficial report, but I can't get the SQL to work in my enviroment.  I tried to run in ALM 11 with SQLServer.  I assume that I only needed to change the Folder name.  Am I missing something?

0 Likes
Absent Member.. YValenzuela Absent Member..
Absent Member..

Re: QC Test Lab: Planned Execution date vs. Execution date

In my query you just have to change the Folder Name. It has to be unique.

Also, my db is ORACLE.

0 Likes
Absent Member.. bfree Absent Member..
Absent Member..

Re: QC Test Lab: Planned Execution date vs. Execution date

Hi,

 

I am looking for the same solution but the URL seems to be down. Can you please post the query here?

 

Thanks

ALMatizer Absent Member.
Absent Member.

Re: QC Test Lab: Planned Execution date vs. Execution date

I need this information too but it appears the link from the comment above no longer works.  If someone could update this information it would be greatly appreciated!

0 Likes
gopuhareesh Absent Member.
Absent Member.

Re: QC Test Lab: Planned Execution date vs. Execution date

I would like to pull a test case execution report against test cases planned.

Can someone help me with SQL to use in HP QC ALM v11.52

 


@YValenzuela wrote:

Ohh man you have no idea how many day i spend looking for this also.

The solution is here:

http://www.qualitycenterstepbystep.com/2012/hp-qc-test-set-report-by-folder/

 

Kind regards


 

0 Likes
manudua Absent Member.
Absent Member.

Re: QC Test Lab: Planned Execution date vs. Execution date

Hi,

 

I am also looking for same but link provided is not working.

can anyone help

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.