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; } } }

How to query stories which have no test or have tests not in an 'approved' status

Hadas Hamerovv

Hi,

I wish to get all the stories which are not linked as 'parents' to issue of a 'test' type or linked to 'test' but those 'test' are not in the 'approved' status.

Can someone help with this?

Naturally I want only the stories in the current sprint but this i believe I know how to add.

Thanks

Accepted answers

All comments

Benjamin_tmh9yg

HI @Hadas Hamerovv ,

Assuming you are using scriptRunner Enhanced search based on the tag on this post.

You can use linkedIssuesOf function:

https://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html

linkedIssuesOf(Subquery, [link name])

For example,

issueFunction in linkedIssuesOf("status NOT IN Approve", "blocks") and IssueType=Story

The above is just example of what you can accomplish. Just modify it to your needs. Also, added a link to the documentation.

Thanks,

Ben

Hadas Hamerovv

I tried this but I could not figure how to add the part for 'or there are no tests linked at all'

Benjamin_tmh9yg

HI @Hadas Hamerovv ,

There's a few example in the post that will help find issues with no link.

https://community.atlassian.com/t5/Jira-questions/Get-all-Issues-without-linked-issue/qaq-p/629810

If you have a particular link type for linking to test, there's another option to search for link type.

-Ben

Hadas Hamerovv

I started with that thread. The problem is that there might be linked issues only not from the 'test' type. (Therefore the issueLinkType is EMPTY won't fit here.)

Again: I wish to find 'stories' with no 'tests' linked to them or with tests linked and not in the 'approved' status.

Pete Singleton

I was looking for the same query, Stories not linked to Tests... the following seems to work (although it is slow!)

IssueType = Story AND issue NOT IN linkedIssuesFromQuery("IssueType = Test")

You can expand the query to include Sprint ID and/or the Test status, e.g

IssueType = Story AND Sprint = 123 AND issue NOT IN linkedIssuesFromQuery("IssueType = Test AND Status !=Approved")

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

jira

cloud

jira-cloud