CODEWITHSUNDEEP
jirajql
Jeff Pearce
Jeff Pearce

Reputation: 581

JQL query to find a linked issue in another project

I am looking for the Jira JQL syntax to find issues that have a linked issue in another project. For example in three projects I can find the list of issues that have been resolved in the last 90 days. I would like to find a list of issues in our QA project for the original issues resolved list.

Upvotes: 2

Views: 12235

Answers (4)

brandonbradley
brandonbradley

Reputation: 647

I was able to get to the solution I needed with the following:

AND issueFunction in linkedIssuesOf("project in (ext_proj_1, ext_proj_2, ext_proj_3)") AND issueLinkType in ("depends on", "is blocked by")

I then used this in a dashboard where I showed the filter results and added the "Links" column so that users could see what projects we had external dependencies on.

Upvotes: 0

SebK
SebK

Reputation: 487

sqluser was close. You don't to have designate a single issuekey, if you use the scriptrunner addon. I don't think there is a way around having it. Up to a recent version it was free so you can simply download that version. It's a must have plugin imho. Here is your query:

issueFunction in linkedIssuesOf('resolutiondate > 2015-10-01') and project = QA

You can extend the criteria of the search. Here is the documentation.

Upvotes: 1

sqluser
sqluser

Reputation: 5672

You can use linkedIssues function and combine it with project name

Something like this: 

issue in linkedIssues(XYZ-000) AND project = 'ABC'

Upvotes: 0

Robert
Robert

Reputation: 3302

Try this plugin:

http://www.j-tricks.com/jql-tricks-plugin.html

specifically JQL function 

linkedIssuesInProject(project,[linkType])

but the plugin is not free.

Upvotes: 0

Related Questions