Search issues that are NOT linked to a specific project

[Deleted user]

Looking to create a filter results view of stories that are not being linked to a specific project (DevOps project to handle deployments). The goal is to allow for alignment across pods so we know when an item should be linked to the devOps project but isn't in the case a team member just forgot. The current query I'm utilizing is returning issues that are linked... but i can't seem to return items that are NOT linked (I have manually confirmed there are stories in a specific status that are not linked)

Queries that do not work:

1. project in ("Pod 1", "Pod 2", "Pod 3", "Pod 4", "Pod 5") and status in ("In QA", "QA Approved", "Ready for UAT Deployment") and issueLinkType not in ( "project = DevOps")
2. project in ("Pod 1", "Pod 2", "Pod 3", "Pod 4", "Pod 5") and status in ("In QA", "QA Approved", "Ready for UAT Deployment") and issueLinkType not in ( "project = DevOps", "relates to", "blocks")
3. project in ("Pod 1", "Pod 2", "Pod 3", "Pod 4", "Pod 5") and status in ("In QA", "QA Approved", "Ready for UAT Deployment") and issueLinkType in ( "project = DevOps", "relates to", "blocks")

The 3rd query is the most accurate query -- but instead of displaying stories from the pods that are linked, I want it to display items that are NOT linked.

Note: I am unable to utilize the issueFunctions in linkedIssuesOf 

Thanks in advance for all your support! 

[Daniel Turczanski - JQL Search Extensions]

Hi @[deleted] ,

With standard JQL, you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue not in linkedIssuesOfQuery("project=DevOps", "relates to") and project in ("Pod 1", "Pod 2", "Pod 3", "Pod 4", "Pod 5") and status in ("In QA", "QA Approved", "Ready for UAT Deployment")

Check out the documentation to see more examples.

I hope this helps!

Daniel

[Bill Sheboy]

Hi @[deleted] -- Welcome to the Atlassian Community!

Just to confirm...

• Do you actually have an issue link type in your instance named "project = DevOps"? 
• Or, are you assuming that this is somehow performing a join-like operation on the DevOps project?

If it is the second one, out-of-the-box JQL cannot perform such a query.  You would need a marketplace app addon for JQL, or to export the data to another tool (e.g. spreadsheet) in order to perform that join operation.

Kind regards,
Bill

[Deleted user]

Thanks for the reply Bill! 

It is the second one - the assumption that it's a join operation... is there any way for us to query issues not linked to the DevOps project without an out-of-the-box JQL solution? 

[Bill Sheboy]

First thing, I recommend checking if you have any of the marketplace addon apps for JQL.  (Lots of premium license customers seem to do so.)  If you have one, check the vendor help to learn how to do the join, or search the community for ideas for the app's usage.

Without the addon, you will need to perform the join outside of Jira, such as in a spreadsheet.