QC Test Lab: Planned Execution date vs. Execution date
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,
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?
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!
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
Ohh man you have no idea how many day i spend looking for this also.
The solution is here: