I am attempting to create a report that includes a count of the script statuses for our test scripts. I.e. the number of scripts in the pass,fail, and Not Started status for a project. The Results / Script Results report has them listed but I see no way to add a count or a chart to the report.
I have decided to create a report that would pull data directly from the database, does anyone know what tables I should look at?
This is not as easy as it may look. I have created reports for our organization and it took several weeks of 'hacking' the db to determine how the different id are related. Here are some basic tables:
QAC_WB_Projects - General Project data
QAC_WB_Folders - General information on folders (Test, result)
QAC_WB_Assetdefinitions - IDS and names for the different asset types (Tests, EPs)
QAC_WB_SCRIPTDEFINITIONS - Basic script info
QAC_WB_EOSCRIPTRELATIONS - Project/EP/Test Script relationships.
How good are you at SQL scripting?
don, CSTP, QAD/TP user since 06
Test Partner 6.3; QAD 6.1; QADLoad 5.9