Using linkedIssuesOf to filter by dependencies with multiple arguments

[abc 1234_]

So I am trying to filter tickets on JIRA by trying to find the ones with open dependencies.

The issue is that we have multiple statuses for both open, and closed tickets, so I currently have

project = " " AND issuefunction in hasLinks("depends on") AND issue function in linkedIssuesOf("status != closed") AND type in (Story, Bug)

What I would like to do is extend the linkedIssuesOf clause to have multiple other statuses, but I am running into errors trying to pass anything more than 1 status. 

Cheers.

[Trudy Claspill · Accepted solution]

Hello @abc 1234_ 

Welcome to the community.

Please show us the filter you are trying to use that results in errors, and the error message you receive.

Typically to set a criteria for Status where more than one value is acceptable the syntax would be:

Status in (value1,value2,value3)

[abc 1234_]

Hi Trudy,

I just tried something that works, but it seems really rudimentary, in which I used:

project = " " AND issuefunction in hasLinks("depends on") AND issue function in linkedIssuesOf("status != closed") AND issuefunction in hasLinks("depends on") AND issue function in linkedIssuesOf("status != x") AND issuefunction in hasLinks("depends on") AND issue function in linkedIssuesOf("status != y") AND type in (Story, Bug)

As this eliminates all the stories which have dependencies which are in status closed, X, and Y. 

I'm pretty new to scriptrunner functions, and was wondering if there was a better way of doing this.

[Trudy Claspill]

You should be able to simply that like this:

 issuefunction in linkedIssuesOf("status not in (x,y,z)", "depends on") AND type in (Story, Bug)

[abc 1234_]

Thank you, this works. 

[Harald Seyr]

Hi @Trudy Claspill 

maybe you replace "status != closed" with "statusCategory != Done".

Regards

Harald