Zephyr for jira tests without planned execution

Is there a jql function in Zephyr for jira to extract all the tests without a planned execution? I'm not talking about unexecuted tests.

I thought there was a function in the previous version but It seems it has desappeared now.

5 answers

1 accepted

0 votes
Accepted answer

Hi Angelo,

So it appears that there is not a way to search for test cases that have no executions assigned to them. Apologies for that. You can only search using ZQL in the Search Test Executions locaiton of Zephyr for JIRA. And you can only search based on an execution status including unexectued. However, you can do it using our plugin ZAPI.

What you can do is you can use JIRA to find all the issue types test. Then you can use ZAPI to find all the exections. Then you can cross reference them to filter out test cases that have not been assigned any execution.

You can acquire ZAPI at the Atlassian Marketplace:


For more information on getting started using ZAPI:


Our Zephyr for JIRA REST API Library:


Kind Regards,


let me get this straight: to have back a functionality I had in the previous version I have to buy a plugin that will cost me $1,000


Could you please help us understand exactly what functionality existed in a previous version that isn't there now?

I am unaware of this exact functionality and can best respond to your comments after I know exactly what it is.

Please include details such as the version of ZFJ and the actions you could take to get the specific data set of testcases without executions.

Kind Regards,

Hi Chris,

I'm talking about the jql function unexecutedTest available in JFJ < 2.x

best regards


Hi Angelo,

If you review our documentation, the value unexecutedTest isn't listed in the documentation of our ZQL. You can note the page wasn't edited since October and also you can see the single prior version of this page via Tools. Thus are two versions of this documentation, and neither mention unexecutedTest.


Also note that we only control ZQL, not JQL. There are two different places where you can search in JIRA when you have Zephyr for JIRA. The JIRA search navigator has JQL. The Zephyr for JIRA Search Testcase Executions has ZQL.

The ZQL specifically populates data when a testcase is scheduled for execution. So thus it doesn't know about testcases of the issue type test in your JIRA database. I've confirmed with a developer that this hasn't been the case, so I don't think it is mechanically possible for ZQL to do such a query.

We added ZQL in 2.0 and we're now in 2.1, and thus our memory is fresh on this topic. I strongly suspect the unexectedTest value you speak of was a JQL value and maybe was related to a different JIRA Ad-On. I applogize for the confusion, but this is likely the source of your thought process.

Emily outlined a way to cross-reference all tests vs all scheduled tests earlier in this string and this is and has been the only way to perform this fucnction.

Kind Regards,


Hi Angelo,

In Zephyr for JIRA we now have ZQL which you can use in the "Search Test Executions" section of Zephyr for JIRA. In here you can search for all kinds of different stuff. Below are a few thinks that I think will help you out.

This shows you have to use the Search Test Executions location:


This link is our ZQL reference guide:


It is important to note that you can not use JQL in this location nor can you use ZQL in the issue navigator. They need to be kept seperate for a successful search.

Kind Regards,


Hi Emily, if i'm not trying to find a test execution in a particular state, I'm trying to find tests without test executions

Hi Angelo,

So the Zephyr for JIRA ZQL only can search for executions. If the test has not been assigned to a cycle and therefore has no execution status, the ZQL will not be able to pull it up.

I was able to craft a JQL query to find all the unexecuted test cases. Since JQL does a search on issue tyles, not execution statuses, this was able to work. I want to make a large note that I am not a JIRA professional. I was able to find a JQL query that works for me. If this does not work for you, you will want to reach out to Atlassian for further answers.

In the issue navigator I was able to do the following JQL and pull up all my tests that had no execution status assigned to them what-so-ever:

issuetype = Test AND "Execution Type" is EMPTY

Try this out for yourself, see if it pulls them up for you.

Kind Regards,


The result is field Execution type does not exist

I'm facing the same issue. I would like to be able to search for tests not belonging to any test cycle - to make sure that all my tests are correctly planned. Is there a way to o that?

Me, too.  I'm a bit disappointed in this Trial.  I expected more flexibility.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 07, 2019 in Marketplace Apps

A Timeless Love Story

It started as any story starts, on a normal, rainy day.   Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...

441 views 8 26
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you