Where can we get the status name for the Zephyr test case executions

[Mani]

Hello,

In Zephyr test case Schedule table (AO_7DEABF_SCHEDULE) there is a column which stores the status id of the execution. In UI it says Pass but in the DB it is storing as 1. Under which table we can find the status descriptions of those executions so that we can map accordingly.

Thanks,

Mani

[Neelakanta Reddy M · Accepted solution]

Hello

Zephyr execution statuses stored as part of jira properties 

you can get them using below query.

SELECT * FROM propertytext where ID IN(select ID from propertyentry where PROPERTY_KEY = 'zephyr.testcase.execution.statuses');

Note: statuses format is JSON.

Regards

Neelakanta