nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

All comments

Sanjen Bariki_rtm841

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

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...

Mikel44

This code gives me an error

Marc -Devoteam-

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?

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 -Devoteam-

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jql