We use Jira problems with linked incidents to them to keep track of how many incidents are logged for a specific problem.
And also to be able to close all of the affected incidents efficiently when the problem has been resolved.
An incident logged can be for one or more organizations.
How can I create a table containing all of the problems and counts of linked issues without having to create JQL for each single problem and organization combination?
I can pull the counts of linked issues required with (different versions of) below JQL, this works great to quickly lookup the different amount of linked issues on a single problem when asked.
linkedIssue in linkedIssues("issuenumber") and project = "project" and organizations = "organization" and resolution = unresolved
But having to do this manually for 80+ problems and 5+ organizations is way too much work and almost impossible to keep up-to-date.
What I am looking for is a table containing all problems with the following columns:
problem/issue number | total number of linked incidents to this problem | total number of unresolved linked incidents to this problem | total number of linked incidents for organization A to this problem | total number of unresolved linked incidents for organization A to this problem | etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.