Latest Runs Summary Report

Q

How to generate a report for Latest Test Run Cases Summary from TestMan database?

✍: FYIcenter.com

A

You can follow this tutorials to generate a report for Latest Test Run Cases Summary from TestMan MySQL database:

1. Create a SQL script file, Report-Latest-Run-Cases-Summary.sql:

-- Report-Latest-Run-Cases-Summary.sql

use TestMan;

select c.ID, c.Reference, c.Timestamp, c.Name, 
c.Success, c.Duration, c.Total, c.Failed, 
   c.Target, c.Tester, c.Station
from Test_Run_Case c
order by c.Timestamp desc 
limit 0,100;

2. Run Report-Latest-Run-Cases-Summary.sql:

>\fyicenter\mysql\bin\mysql -u fyicenter --html 
   < Report-Latest-Run-Cases-Summary.sql
   > Run-Cases-Summary.html

3. Open Run-Cases-Summary.html in a Web browser. You see a nice run cases summary report.

 

Generating Reports from TestMan Database

⇒⇒Test Management Tutorials

2017-11-26, 139👍, 0💬