Query on tables for reporting purpose
We are currently using Quality Center 9.2 provided by the client. The client does not allow us to run any macros on their systems and has removed all the help documentation available on QC.
We want to generate a daily status report on the lines of the Graph "<Summary> - Cross Test Set" available in the "Analysis" at "Test Lab", but this we want it on a daily basis on any given date, i.e., we need to know the status of a particular "Test Case" on each date for a given date range.
We have decided to make use of the "Excel Reports..." and have been working on the required SQL on the lines of the Graph report. But we have failed to understand which table we can refer to know the "Status" of a Particular "Test Case" for a given date.
We have done some search in this forum, but could not get what is required or we failed to locate the same.
Hence request, if someone, could provide the table name, which can provide the "Status" of a Particular "Test Case" for any given date.
Thanks in advance.
Re: Query on tables for reporting purpose
[ QUOTE ]
The client does not allow us to run any macros on their systems and has removed all the help documentation available on QC.
[/ QUOTE ]
Looks like you are circumventing your client's (wierd) policy. You should ask for these docs from your client & check if it's okay to run macros / extract reports.
Try this, to query the status of a TC based on date<font class="small">Code:</font><hr /><pre>SELECT TEST.TS_NAME, RUN.RN_STATUS , RUN.RN_EXECUTION_DATE
FROM TEST, RUN
WHERE RUN.RN_EXECUTION_DATE >= '2012-01-26' AND RUN.RN_EXECUTION_DATE < '2012-01-27' And TEST.TS_TEST_ID = '123' </pre><hr />