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