How to retrieve Zephyr test cycle and test version for an issue

[Evin Murphy]

Hi,

I have created a table that uses calculated measures to show for every Zephyr test issue that has been executed information relating only to its last execution: the date it was last executed, the individual who executed the test, and its result.

The format of this table can be seen below

These fields were all available as calculated measures in the Issues properties section using the following formulas

[Issue].CurrentHierarchyMember.get('Last executed at')

[Test Executed by].[User].getMemberNameByKey(
[Issue].CurrentHierarchyMember.get('Last executed by')
)

[Issue].CurrentHierarchyMember.get('Last execution status')

However, looking at a Zephyr test issue there are two fields that I can't seem to access: the Version and its Test Cycle. I know that Test Cycle has its own dimension, but I haven't been able to access those fields in the same way I accessed the others. I figured they would all be properties of an issue but any guesses I've made about the name of the issue has been wrong.

Does anyone have a solution for how to retrieve and show those fields in the same manner as the other execution fields? Currently the only dimensions I'm using are Issues in row and Measures in column. Do I need to also use the Test Cycles dimension? 

Thanks