Write a complicated filter - when a specific linkage is used across different projects

[Deleted user]

This is the filter I want to write.

- Search for any stories that have the linkage...

 is blocked by, blocks

AND I only want those results where the two stories linked are from DIFFERENT projects.

Does anyone know how to write a filter like that?

[Jack Brickey · Accepted solution]

Hi @[deleted] ,

you cannot achieve that OOTB. Is that a constraint here? If so you could consider leveraging Excel/Sheets to post-process your linked results to exclude "linked but in same project".

[Fabian Lim · Accepted solution]

Hi @[deleted]

I don't think this is possible with jql out of the box. 

You may want to look into eazybi reporting where you can put extra logic or some advanced jql plugins.  

Good luck.

[mauricio.groth]

Hi @[deleted]

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your stories that have links(blocks or is blocked by) that have a different project..

issue in linkedIssuesOfQuery("project != X") and linkType in (blocks, "is blocked by") and project = X and type = Story

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício