count of linked issues

[Jennifer Choban]

Hi Folks,

I'm looking for a way to put together a report that will list issues in a project and the number of linked issues (regardless of link type) that each one has.

Thanks in advance for any suggestions,

Jenny

[mfabris · Accepted solution]

Hello Jennifer

If you have scriptrunner there you can use this JQL

issueFunction in linkedIssuesOf("Issuekey= ABC-123")

For the count of the issues, well a JQL only returns a list.

If you want the count you could consider a plugin called "counter gadget".

You save your JQL in a filter and call it from the gadget.

This gadget is very simple and it is free, and it has always been free so I hope the guys who developed it (Akeles) do not change their mind about it.

Sorry for giving a solution using 2 plugins, but I am not sure this can be done otherwise.

Good luck!

Mirco

[Jack Nolddor _Sweet Bananas_]

Alternatively, you can also use JQL Booster Pack which comes with a bunch of JQL functions regarding issue relationship:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Regards

[Andrew Laden]

You can also create a scripted field with a script to set the value of the field to the number of linked issues. You can then use that field in filter searches and results.

I'll leave the script as an exercize fo the reader. :)

[Doug Clendening]

Sadly, scripted fields do no work in dashboards in Jira cloud if anyone else is wondering. You'll have to update a normal custom field somehow.