JQL complicated query filter

Sharona Keren

Hi, 

I'm looking for a way to search issues in 2 projects, without having duplicate Jira issues. Project 1 has all Jira issues, Project 2 has a part of Project1's Jira issues, and they are linked. 

I'd like the search to show all of Project2's Jira issues and only the issues of project 1 that doesn't have a linked issue that belongs to project2.

Is that possible? 

(I also need to filter by a certain group of assignees but I can handle that)

Velizar Borisov

Hi Sharona!

If you are "ScriptRunner Enhanced Search" user it would be pretty easy to create such a complicated query. Just use the "linkedIssuesOf" function.

In case you are not, you will have to check for something common between issues in Project 1, that you don't need to show up and exclude them. If there's nothing you can simply add a label to those you would like to be added in the filter.

Something like " project= "Project 2" or "Project = "Project 1" and label = "Marker_for_project2""  ".

Hope that helps,
Velizar