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; } } }

Jira Reporting - Custom report via REST API?

Ricardo Gomes

Hi,

I need to get a report from Jira either via REST API or SQL (or maybe some other method as long as I don't have to pay for another plugin) that shows me:

• For each ticket of a certain project (based on certain criteria)

• What are the linked tickets to each of the above (based on a certain type of linkage)

• and for each linked ticket that matches the criteria, I'd like to see: Sprint and Status fields from those tickets.

Is it possible to accomplish the above somehow?

Desperate to get a solution here so any hints would be greatly appreciated.

P.S. not a developer so I have some knowledge of REST and can do some programming with some help, so any further tech assistance here would be helpful. Ideally, I'd like to run a script that would generate a spreadsheet for me with the above data.

Thanks in advance!

Cheers!

Accepted answers

All comments

Michael Raj_18ewee

Hi @Ricardo Gomes ,

Your request sounds challenging especially when you have to learn all the stuff from the beginning.

It is possible and not that hard but it requires few different modules and more than one request to be send to REST API.

From my experience you have to answer yourself this basic question:

1. Do you have an access to Jira database to use SQL? It would be easier than via REST API?

Based on answer you can think about next steps.

Best

Michael

Ricardo Gomes

Thanks, @Michael Raj .

I've used REST to get and manipulate data from Jira before using different types of script languages but I'm not sure I'd have access to their SQL database.

How do I know that? Or request access?

Thank you!

Michael Raj_18ewee

Hi @Ricardo Gomes ,

If you use REST API, let's stay with it. In the meantime you can request access to Jira SQL Server but you can do this exercise via REST API as well.

Based on your requirements I would follow these steps:

1. collect all issues from particular project (using JQL which you can validate using Jira Service Desk and then decode it into correct request -> https://www.w3schools.com/tags/ref_urlencode.ASP or just copy whole URL to notepad)

2. when collecting issues from step 1, check field "issuelinks" where information about links is stored

3. collect all issues' keys that match your criteria (your second bulletpoint)

4. collect sprint and status from those issues

Unless you can use special functions (example: https://community.atlassian.com/t5/Jira-questions/Get-list-of-linked-issues-how-to/qaq-p/95753) these steps may look different.

If you have thousands of issues above method may not be very efficient as you have to send request for each issue to collect sprint and status. Maybe you can use jql search using issuekey in ('issuekey-1','issuekey-2') to do it faster. But optimization is the next step.

Build a tool to collect basic data and then you can optimize.

Good luck!

Michael

Michael Raj_18ewee

Hi @Ricardo Gomes ,

I've checked this solution: https://community.atlassian.com/t5/Jira-questions/jira-query-issues-with-linked-issues/qaq-p/426769 which is just JQL code:

Project = XYZ and issueLinkType in (blocks, causes)

And it works. So you can collect all issues at once and that should be even more efficient than steps proposed by me above.

Best

Michael

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

rest-api

report