Un-block other projects

[Matthis Thorade]

In our company, we have three projects, let's assume they are named OCT, TML and AFP. I work in the TML project, and would like to do two things:

• find a list of all stories where TML is blocking the OCT or AFP project
• find a list of all stories where TML is blocked by OCT or AFP project

Using JQL, I can easily use the following queries:

project = "TML" AND issueLinkType = blocks

project = "TML" AND issueLinkType = "is blocked by"

but then the majority of stories in the list is of type TML blocks TML, or TML blocked by TML. 

How can I filter out the issues/stories where we are blocking or are blocked by a DIFFERENT project only??

[Kevin Johnson · Accepted solution]

Hi @Matthis Thorade ,

This kind of filtering is not possible in jira as of now. Instead these are some plugin which will help you achieve this 

• JQL Booster Pack

• JQL Tricks Plugin

• JQL Search Extensions for Jira & reports

• ScriptRunner for Jira

• Search Linked Issues

Hope this helps.

Here's a link to similar ticket : https://community.atlassian.com/t5/Jira-Core-questions/Query-to-find-jira-issues-in-one-project-that-are-linked-to/qaq-p/1332315 

Regards,

Kevin.

[Matthis Thorade]

Thanks. This is a pity, I cannot buy any apps/extensions. This seems quite basic functionality to me. 

[Prince Nyeche]

I'm not certain if this would be what you're looking for but I would try it like below

issueLinkType in (blocks, "is blocked by") AND NOT (project = TML AND issueLinkType in (blocks, "is blocked by"))

[Kevin Johnson]

@Prince Nyeche I guess this will list all the linked issues in other projects, not the issues in the specific project which has only linked issues with other projects.

[Prince Nyeche]

Hmm, I thought as much.