We are rolling out a fix for cycle summary issue for our Zephyr for Jira Cloud customers (on October 16th 2018) post the recent 3.0 release. This change will automatically be pushed into your cloud instances and there will not be any downtime.
Support | Zephyr



How to generate report of Testcase Execution History?

Created on

Problem

I wish to generate report of testcase execution history. Can I generate this?

Cause

Re-execution of the Test Case from the same test cycle will overrides the status.


Fix:

Steps:

1) Get the Execution ID for which you want to view the history.You can get this from DB using the query

select * from release_test_schedule;

OR

By using the REST API Get execution by Criteria - "/services/rest/latest/execution/"


2)Once you get the execution ID pass that value in the below API which gives you the TestResult History of that Execution.

Request (replace username/password,ZephyrIP:PORT and execution ID):

curl -u "test.manager":"test.manager" --request GET "http://ZephyrIP:PORT/flex/services/rest/latest/execution/10?expand=resulthistory"
Note : Here 10 is the id of schedule (not testcase)


Response : History of the Execution with ID=1 (History starts by name "resultHistory" )

{
"testScheduleId":1,
"assignmentDate":1419877800000,
"estimatedTime":600,
"comment":null,
"testerId":-10,
"remoteRepositoryTestcaseId":2,
"remoteTestcaseId":3,
"cyclePhaseId":1,
"lastTestResult":{
"id":2,
"executionDate":1420799644000,
"executionNotes":null,
"executionStatus":"2",
"attachmentLocation":null,
"status":null,
"defect":null,
"testerId":1,
"releaseTestScheduleId":1
},
"attachmentCount":0,
"scriptName":null,
"scriptId":null,
"scriptPath":null,
"remoteFieldValues":null,
"actualTime":600,
"defects":null,
"testStepResult":null,
"resultHistory":[
{
"id":1,
"executionDate":1420798691000,
"executionNotes":null,
"executionStatus":"1",
"testerId":1,
"releaseTestScheduleId":"1",
"testStepExecutions":null,
"actualTime":null
},
{
"id":2,
"executionDate":1420799644000,
"executionNotes":null,
"executionStatus":"2",
"testerId":1,
"releaseTestScheduleId":"1",
"testStepExecutions":null,
"actualTime":null
}
]
}

See as gist
KnowledgeBase Document Information:

---------------------------------------------------------------------------------------------

Title: How to generate Testcase Execution History?

Product: Zephyr

Version: All

Summary: When I re-execute the test case from the same test cycle it overrides the results. I want the report of testcase execution history. Can I generate this?

---------------------------------------------------------------------------------------------


Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request
Powered by Zendesk