Summarized test progress metrics from database

[nalvesp]

Hello

We currently use Testlink 1.9.13 for all our projects. We issue a weekly status reports where we include the test progress. For that, we must access the metricsDashboard.php page for each one of the projects and then copy this information into a status report.

We’d like to create an automatic status report based on the Testlink database information. We need simple summarized information as below:

1. Total test count for each project:

Testproject prefix | node name | Test cases count
1 | Project 1 | 54
2 | Project 2 | 87
3 | Project 3 | 23
……………….


2. Test cases execution status. In other words, how many testcases were executed and their respective result:

Testproject prefix | node name | execution status | Test cases count
1 | Project 1 | p | 13
1 | Project 1 | b | 3
1 | Project 1 | f | 29
2 | Project 2 | p | 87
3 | Project 3 | f | 4
3 | Project 3 | b | 19
……………….



The above information is generated is generated online, so I tried to create SQL statements to produce this information, but every time I thought I’d got it made I found another mismatch comparing to the metricsDashboard.php official results. I couldn't understand the data model completely...

Please, can someone help me to create those SQL statements?


Kinds regards