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 

[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")

[Benjamin]

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]

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. 

[Benjamin]

Have you consider in combining them?

(IssueType=Story and IssueLinkType is Empty) 

(IssueType=Story and issueFunction in linkedIssuesOf(Type=Test)) OR (JQL for your other search)

[Hadas Hamerovv]

yes but issueLinkType might not be Empty as there are other 'stories' or 'issues' 'tasks' 'bugs' linked to the story while no 'tests' are linked.

So I am still missing the stories which have no 'tests' linked to them but are linked to 'other' issues.

[Benjamin]

This is JQL should cover that case:

IssueType=Story and IssueLinkType is not Empty

[Hadas Hamerovv]

Sorry but no. I need a case that there are no 'tests' linked to the issue. The query you offer suggest that no issue of any type is linked. That is not the case.

[Benjamin]

(IssueType=Story and issueFunction in linkedIssuesOf(Type NOT IN Test)

This query will query all stories the have link to issues other than test.

[Hadas Hamerovv]

Sorry, This results in 'stories' that are linked to other issues regardless if they are linked to 'tests' or not.

I want only stories that are not linked to 'tests' regardless if they are linked to other issues or not.

[Hadas Hamerovv]

I was happy too early. Sorry.

[Emily Hansel]

@Hadas Hamerovv did you ever get an answer to this? I'm trying to do the same thing as you but am struggling with it

[Manjiri Godale]

@Hadas Hamerovv  Try below condition in your query. It works 

type in (Story) AND IssueLinkType in (Test)