Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Get Number of Linked Issues

Hi,

I'm using IssueType called Requirement in Jira and all my US's are linked to this requirement,
I'm want to get all the related linked issues to this requirements (succeeded) and also get the number of related  issues and present it by any gadget I will found in Jira dashboard in a list view.

Requirement --> US --> Number of US

XXX-123 --> XXX-124 , XXX-125 --> 2

I apricate your help to help me to get the number of those US's

Thanks,
Elran

3 answers

Hi @Miron Giladi Try below query to get all linked issue of an issue :-

issue in linkedIssues("issuekey") . it gives the number of issues linked to a particular issue. 

issue in linkedIssuesInFilter("10000")

https://www.j-tricks.com/jqlt-links-functions.html#:~:text=issue%20in%20linkedIssues(%22TST%2D,will%20get%20the%20same%20result.

If you have a script runner plugin installed , you can get better result based on issue type :- 

For eg :- issueFunction in linkedIssuesOf("project=xyz", Blocks)

https://valiantys.com/en/blog/atlassian-administration/jql/

 

 

Thanks

VY

Hi Vikrant,

Thanks for your replay.
to get all the linked issues, I already succeeded.

My problem is bigger than get all the issues and I will try to explain shortly.

I need to present all related issues to many requirements, for example in fix version X I have 40 requirements, so I want to see a list of those requirements with number of related issues to each requirement.

requirement 
requirement XXX-111 --> 11 related issues
requirement XXX-222 --> 12 related issues
requirement XXX-333 --> 13 related issues
requirement XXX-444 --> 14 related issues

If you have any suggestion, I will be happy to hear :)

0 votes
Daniel Ebers Community Leader Jun 26, 2021

Hi @Miron Giladi

if I understand you correctly the requirements and the other issues are perfectly linked and you already have a JQL query in place to find out what you need. However, you want to have a count (represented by a custom field?) in your issues that shows how many issues are linked to a specific requirement, represented in your example as XXX-111 - please confirm if this is correct.

If so ... and you have a scripting App in place you can use it likely to reach the goal.

In this example (here it is ScriptRunner) it comes quite close to your requirement I believe, worth having a look at:
https://library.adaptavist.com/entity/number-of-linked-alerts-itsm

For displaying on dashboards it will be a different thing, usually Gadgets do not offer number fields as a source for visualizing data. This part would likely need more inspection.

So far - is it what you are looking for? Please feel free to update us here if you find the time.

Regards,
Daniel

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you