Can we filter all tasks which have linked issues from a specific project?

[Mahima Srivastav]

I have issues linked to other issues from let's say the Design Project.

Now, I want to filter out all the issues which are linked to the design project and not necessarily to a particular issue from the design project.

Is it possible to filter all issues which have linked issues from a specific project?

[Valen Cardozo]

Hi @Mahima Srivastav 
I encountered the same problem and a quick solution was to filter by link type.

issueLinkType = blocks ORDER BY created DESC

There is the possibility of defining custom link types, which would lead you to associate only the tasks that are of the "Design" project to the others by means of a link, for example: "Tasks to Design".

I hope this helps you

Cheers

Valentin

[Daniel Turczanski - JQL Search Extensions]

Hi,
With standard JQL you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:

• JQL Search Extensions

After you install the app you can simply search:

(linkedByIssueProject=DESIGN OR linksIssueProject=DESIGN) AND project!=DESIGN

The query finds all issues that have links to or from DESIGN issues. The query also makes sure no DESIGN tickets are returned. You may want to check out the docs as well.

I hope this helps!
Daniel

[Jack Brickey]

I don’t think you can get to where are you want to be OOTB. You will need an add-on such as scriptrunner.

[Suvradip Paul]

Yes @Jack Brickey .

ScriptRunner for Jira can be found here in marketplace- https://marketplace.atlassian.com/apps/6820 .

@Mahima Srivastav  - Please follow the blog link mentioned above for guidance.

[Jack Brickey]

Understand. My point to Mahima was that he would need an addon to achieve the goal. Scriptrunner is one such addon.

[Suvradip Paul]

Yes @Jack Brickey  absolutely. Thanks.

[Suvradip Paul]

Hi @Mahima Srivastav ,

Thanks for haring your post in this community.

If you are familiar with JQL then it can be easily done.

Please check this article - https://valiantys.com/en/blog/atlassian-administration/jql/ and customise your JQL accordingly to filter out the results. 

I hope that helps.

Cheers

Suvradip