List of not Closed Jira test cases, that have Passed zephyr test executions

[Alejandro Greppi ext]

How do I get that list using JQL and/or ZQL?

[Mohamed Adel]

Hi @Alejandro Greppi ext  

You can use the following query : 

project="Your Project" AND type = "Test Case" AND Status !=Closed executionStatus = PASS

[Alejandro Greppi ext]

How exactly the query would be? executionStatus is not part of the JQL language.

[Mohamed Adel]

Can you try it inside zephyr search page 

zephyr search page 

[Alejandro Greppi ext]

I was informed that that cannot be done from Zephyr side.

type or issuetype is not part of the ZQL language, neither is status

[Mohamed Adel]

Please try then the following query inside your JQL advanced search

project="Your Project" AND type = "Test Case" AND Status !=Closed AND issue in hasAnyLastTestResults("Pass")

reference

[Alejandro Greppi ext]

I checked that, and I get this error message:

Unable to find JQL function 'hasAnyLastTestResults(Pass)'.

I checked the documentation, and it says that I can do that if I have Zephyr Scale installed. How can I know if I have this installed?

[Mohamed Adel]

Zephyr Scale - Test Management for Jira