JQl query

[Deleted user]

Hello All,

JQL query to find out how many issues in a Jira service Desk project contain issue links into other projects.

Thanks in advance,

ch

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Ch,

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 ServiceDesk Project" AND issueLinkType IS NOT EMPTY

However, this not ensure that the link is pointing to another project, it also retrieve issue that are linked to the same project, e.g "My ServiceDesk Project"

If you want to search for issues in yoour JSD project having a link to a given proyect i.e "My Software Project"... 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 project = "My ServiceDesk Project" linked to any issue within the "My Software Project" project:

project = "My ServiceDesk Project" AND issue IN linkedIssuesOf('project = "My Software 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()
• hasLinks()

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards

[Deleted user]

Thanks @Jack Nolddor _Sweet Bananas_