How to filter issues on a project that are not linked to issues on another project

Question

Hi, in order to visualize which initiatives are not linked to my team's quarterly goals, I am trying to launch a query on the issue navigator. I need the query to give me as a result all the issues of a specified project, with a certain issue type and summary, that are NOT linked to specific issues of another project. What syntax can I use in my query to have that result back? Thank you in advance!

Valeria Faraone · Answer

Hi @Hannes Obweger - JXL for Jira , thank you very much! The query you shared should be good to get the information I need.

Thanks again.

Valeria

Hannes Obweger - JXL for Jira · Answer

Hi @Valeria Faraone

if you know the specific issues by issue key, you should be able to use a clause like

issueLink not in (ISSUEKEY-1, ISSUEKEY-2, ...)

If you want to run your query dynamically, without a "hardcoded" list of issue keys, the thing becomes quite a bit trickier; you then may want to have a look at this thread as a starting point.

Hope this helps,

Best,

Hannes