Collections:
Latest Failed Test Steps Report
How to generate a report for Latest Failed Test Run Case Steps from TestMan database?
✍: FYIcenter.com
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
2017-11-26, ∼2806🔥, 0💬
Popular Posts:
How to generate test phone numbers for US and Canada? Test phone numbers are frequently needed in te...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to validate and decode MAC (Media Access Control) addresses? In order to help your programming o...
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
How to valid IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has d...