Get list of issues sorted based on number of issues to which they are linked

[Deepanshu Natani]

Is there any way to get a list of Jira issues with sorting based on the number of issues to which they are linked. So the Jira issue which is linked to most number of Jira issues will appear first in this list.

[Bill Sheboy · Accepted solution]

Hi @Deepanshu Natani 

You could use a custom field and the automation rules to count the links with:

{{issue.issueLinks.size|0}}

The rule could be triggered as you wish, but probably by a scheduler or link changes.

Then use a filter to sort by the custom field.

Best regards,

Bill

[Deepanshu Natani]

Thanks for your solution @Bill Sheboy 

[Steve Nguyen]

Great idea but I am running into query record size limitation. 

A JQL search in this automation rule has exceeded the allowed maximum number of issues to retrieve per search. Only the first issues up to the following limit were processed:1000

All issues are to be calculated so I can't write a JQL to reduce the records count.  Do you have any suggestion for my issue?

[Bill Sheboy]

Hi @Steve Nguyen 

Are you just trying to count the issues or do something else with them?

If just counting, you could call the REST API issue search with JQL using the Send Web Request action.  Even though it will only return up to 100 issues, the total count will be returned in the message.

If you are trying other processing with more than 100 issues, you will need to find some way to get smaller chunks of them.  In that case, I recommend creating a new question to get more suggestions.  This is an older thread, and so a new question will get more community members seeing it.

Kind regards,
Bill

[Steve Nguyen]

I will submit a new question.  Thank you Bill.

[final_openshift Certi]

Hi Deepanshu,

You can achieve this by using   JQL Search Extension plugin , you can use the query linksCount > 0 and then sort the result in Ascending/Descending order  , please refer to the documents it contains examples and other necessary information related to the usage of plugin

[Deepanshu Natani]

Thanks for your reply @final_openshift Certi 

[Lucas Modzelewski _Lumo_]

Great answer by @Bill Sheboy 

If you would like to go further and see the links between issues in that filter/JQL search, you can check our app displaying links in form of graph. Graph is available also on single issue view, then it displays all issue dependencies.

Here is related page from documentation: Issue Links Viewer - Global graph 

Link to marketplace: Issue Links Viewer - Marketplace 

Cheers,

Łukasz

[Deepanshu Natani]

Thanks for your reply @Lucas Modzelewski _Lumo_