Latest Failed Test Steps Report

Q

How to generate a report for Latest Failed Test Run Case Steps from TestMan database?

✍: FYIcenter.com

A

You can follow this tutorials to generate a report for Latest Failed Test Run Case Steps from TestMan MySQL database:

1. Create a SQL script file, Report-Latest-Failed-Steps.sql:

-- Report-Latest-Failed-Steps.sql

use TestMan;

select s.ID, c.Reference, s.Timestamp, s.Name, s.Success, s.Duration, 
   c.Target, c.Tester
from Test_Run_Case_Step s, Test_Run_Case c
where s.success = false
   and s.Test_Run_Case_ID = c.ID
order by s.Timestamp desc 
limit 0,100;

2. Run Report-Latest-Failed-Steps.sql:

>\fyicenter\mysql\bin\mysql -u fyicenter --html 
   < Report-Latest-Failed-Steps.sql
   > Failed-Steps.html

3. Open Failed-Steps.html in a Web browser. You see a nice failed steps report.

 

Generating Reports from TestMan Database

⇒⇒Test Management Tutorials

2017-11-26, 137👍, 0💬