JQl query

unknown

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]

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

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

Kind regards