Query to find all issues with a link to ANY issue from a specific Project

[Nyssa Watkin]

Is there a query to find all issues that have a link (any type of link) to any issue from a specific project?

[Jack Nolddor _Sweet Bananas_]

Hi Nyssa,

If you want to search for issues on a given project having a link you can type the following using standard Jira 8.x features:

project = "My Awesome Project" AND issueLinkType NOT IN ("is blocked by" ,blocks, clones, "is duplicated by", ....)

Note that you must replace ... with all available issue links here to get the desired results.

However, if you want to search for issues in any project having a link to a given proyect... Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

Search for issues on any project linked to an issue within the "My Awesome Project" project:

issue IN linkedIssuesOf('project = "My Awesome Project"')

Note that this is just an exaple, you must tune your query to fit your needs

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards

[Parvaneh Zand]

Hi @Jack Nolddor _Sweet Bananas_ ,

I'm using jira 8.2, but I'm not able to use your first jql

[Jack Nolddor _Sweet Bananas_]

You are right, sorry for that. I've edited my previous message.

[Parvaneh Zand]

Hi @Shawn ,

If you have ScriptRunner for JIRA plugin, try this:

project = "ProjectName" AND issueFunction in hasLinks()

otherwise you have to write all issue-link names in JQL , separated by ( , )

 project = "ProjectName" AND issueLinkType in ("is blocked by","blocks","relates to","...")