Script to generate list of Jira tickets with Pull reques(Git hub), Auth and reviewer pending

[satish_1_badiger]

Wanted a script to generate report of Jira ticket linked with Github Pull Request, owner, repo, status and reviewer details.

An Example is attached for reference.

[Hari Krishna]

HI @satish_1_badiger ,

To generate a report listing Jira tickets linked with GitHub Pull Requests, including the PR owner, repository, status, reviewer, aging, and sprint information, follow this approach:

Query Jira for issues with linked Pull Requests using a suitable JQL:

issueFunction in hasPullRequest()

Use Jira REST API to fetch details for each issue:

Endpoint:

GET /rest/api/2/issue/{issueIdOrKey}?expand=renderedFields,names,fields

Extract fields such as:

• Issue key
• Sprint (custom field)
• Development info (linked PR URL, repo, etc.)

Use GitHub REST API to fetch PR metadata:

• Endpoint:

          GET /repos/{owner}/{repo}/pulls/{pull_number}

• Extract the following:
• Pull request title
• PR status (open/closed/merged)
• PR author
• Reviewer(s)
• Created and updated dates
• Combine the Jira and GitHub data:
• Match issues and PRs
• Calculate aging (e.g., current date - PR created date)

Add sprint and status details

Export the results into an HTML table or CSV format for easy sharing.

Reference:

• Jira API: https://developer.atlassian.com/cloud/jira/platform/rest/v3/
• GitHub API: https://docs.github.com/en/rest/pulls/pulls

This method helps in tracking engineering progress and identifying review bottlenecks across sprints.