Article Associations Database General Java Selenium SoapUI Tools UFT

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.

 

⇒ Test Management Tutorials

⇐ Latest Failed Test Steps Report

⇑ Generating Reports from TestMan Database

⇑⇑ Test Management Tutorials

2017-11-26, ∼2337🔥, 0💬

Article Associations Database General Java Selenium SoapUI Tools UFT