Summarized test progress metrics from database

[Nelio Pereira]

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

……………….

               

 

I’ve 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.

 

Please, can someone write those SQL statements for me?

 

Kinds regards