nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Get Number of Linked Issues

Miron Giladi

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

Accepted answers

All comments

Vikrant Yadav

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

Miron Giladi

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

Daniel Ebers

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

Priyadharshini CS

Hi @Miron Giladi Check if the solution below works for you

Create a custom field named "count" of type Number from Jira settings -> Issues -> Custom fields -> Create custom field . Associate it with the screen of the project where you want to retrieve the information.
Go to project settings -> Automation -> Create rule

Automation rule details :

Trigger	Scheduled
New Branch	Branch/Related issues Type of related issues : JQL JQL : use the JQL query as per your requirement
Action	Lookup issues
Action	Edit issues -> choose the field that we created in Step 1 "count" Use the smart value as below {{lookupIssues.size}}

Publish the rule
Once published, click on "Run rule".
The rule will run and then the count field will be filled with the values calculated with the automation rule.
Now, create a filter with the JQL as below :

project = projectname AND "count[Number]" is not EMPTY

Save the filter
Now go to the "Dashboard" and choose "two dimensional filter gadget" -> choose the filter we created in step 5.
Choose the two fields Key and count
* *
Click on Save
The result will be as shown in the image below :

Martin Cleaver

All images are broken:

Martin Cleaver

They point to getsupport e.g. https://getsupport.atlassian.com/secure/attachment/6855924/6855924_image-2021-12-16-18-07-58-080.png

Kadhem MEJRI

Hello,

Could you please re-upload the images ? they are not available anymore

thank you

Steve Nguyen_o0yxwt

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?

Cael Metcalfe

The workaround for this limitation is to use a Web Request and call the issue search endpoint with your jql, then extract the "total" from the response; it is not limited to 100 records.

See: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

atl-gruland