Re: QC Test Lab: Planned Execution date vs. Execution date - Micro Focus Community

jul_2 · ‎2012-02-06

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

Bodhi · ‎2012-05-08

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

YValenzuela · ‎2012-05-08

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

Steve Barnash · ‎2012-05-10

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?

YValenzuela · ‎2012-05-10

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

Also, my db is ORACLE.

bfree · ‎2014-09-10

Hi,

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

Thanks

ALMatizer · ‎2014-11-25

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!

gopuhareesh · ‎2015-07-29

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

manudua · ‎2015-07-30

Hi,

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

can anyone help