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

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

jql for incident report linked by project

I need a report with the issues that used an incident linked to a specific project, if I use only issueLinkType = "link1" it returns all issues but I need a series for each project.

Example:

project A = 5 issues link "link1" to project "B"

project A = 1 issues link "link1" to project "C"

project A = 10 issues link "link1" to project "D"

1 answer

2 votes

Hello @Administración_Soporte

Unfortunately, JIRA does not have an inbuilt report to return this kind of information, however, I know there are some apps that you can use to perform JQL sub-queries inside linked issues, so you would be able to return only the linked issues from a specific project and use a gadget to count the number of issues or return them directly.

Check below some apps that might help you achieve that in JIRA Cloud:

JQL Search Extensions for Jira & reports 

Scriptrunner for JIRA 

Let me give you an example with JQL search Extensions, so I can clearly explain what I mean:

1 - Configure the following queries, saving it as three different filters:

Project = A and issueLinkType = "link1" and linkedByQuery = "project = B"
Project = A and issueLinkType = "link1" and linkedByQuery = "project = C"
Project = A and issueLinkType = "link1" linkedByQuery = "project = D"

The three queries above will return all the issues from the project A that are linked as "link1" to other issues in the project B, C, and D, respectively.

2 - Navigate to your Dashboard > Click to add a new gadget > add three Issue Counts gadgets

3 - Configure the gadgets with the respective filters, naming it as you want. The gadgets will return:

      - How many issues in project A are linked as "link1" to project B issues

      - How many issues in project A are linked as "link1" to project C issues

      - How many issues in project A are linked as "link1" to project D issues

Let me know if this information helps.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,615 views 22 33
Read article

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