Search Tests WithNo PlanTest

[Mikel44]

Hello,

I'm trying to perform a search in jql to find all tests from the last month that don't have a test plan associated with them.

I have searched and found the following commands: testsWithNoTestSet, testsWithoutTestExecution... But I would need something similar to testsWithoutPlanTest, but that doesn't exist... is there any other way?

This is the current code:
type = Test AND created >= startOfMonth(-1) ORDER BY key ASC

[Mikel44]

I still can't get it. My intention is only show the tests (of all my project) that do not have a test plan associated...

Thanks!

[Marc Koppelaar]

HI @Mikel44 

Are you using a specific test app from the marketplace in your instance, if so which one?

Is there any information in there documentation on JQL options that can be used?

[Marc Koppelaar]

HI @Mikel44 

Are you using a specific test app from the marketplace in your instance, if so which one?

Is there any information in there documentation on JQL options that can be used?

[Florian Bonniec]

Hi @Mikel44 

Have you try to save your filter "type = Test AND created >= startOfMonth(-1) ORDER BY key ASC with name "MonthTests"

Then run another query 

type = Test AND created >= startOfMonth(-1) and issue not in testPlanTests("MonthTests")

Regards

[Mikel44]

The same number of results appear as in the previous one... :(

[Florian Bonniec]

Can you try to save a filter with this query (eg, name it AllTestPlan)

type = "Test Plan"

Then do another query with

type = Test AND created >= startOfMonth(-1) and issue not in testPlanTests("AllTestPlan")

Regards

[Sanjen Bariki]

Hi @Mikel44 ,

Welcome to atlassian community!

Please find the below JQL.

project = "XYZ" AND issuetype = Test AND created >= startOfMonth(-1) AND created <= endOfMonth(-1) AND issue not in testExecution("status = PASS OR status = FAIL")

Kindly let me know, Is the JQL worked properly or not..?

I will try one more JQL.

Regards,

Sanjen Bariki

[Mikel44]

This code gives me an error :(