Community
Products
Jira
Questions
Dashboard using filter results

Dashboard using filter results

I am wanting to build out a dashboard using the filter results gadget. Ideally I want the following columns, but am having trouble figuring out how to get the last two columns.

Key Summary. Assignee. Status. Linked Issue. Linked Issue Status. Linked Issue Assignee

Thoughts in how I could accomplish this. Or, if there is a better gadget that would accomplish this, I am open to that as well.

1 answer

1 accepted

2 votes

Answer accepted

Hello @Jason Chayer

With the native Filter Results dashboard gadget you cannot get the last two columns. That gadget doesn't support displaying information for linked issues in the same row as the issue to which they are linked. You would have to design your filter so that it would retrieve the linked issues also and they would then be displayed on a separate row.

Would you consider acquiring a third party app to get the results you want? I don't specifically know of such an app, but there is a chance that one exists.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Trudy Claspill - ideally I would not want to use a third party app. If I can figure out the filter, a separate row may suffice.

Thank you. And I may reach back out if I have trouble determining the filter.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I think you may run into trouble trying to create a filter that retrieves a dynamic list of issues and all their linked issues. Jira does not support that natively.

The native JQL function for retrieving linked issues does not support using a filter as an input parameter. It requires that you specify by issue key the issue for which you want to retrieve the linked issues.

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#linkedIssues--

There are a variety of third party apps that extend JQL functionality and provide functions that do accept a filter as input. You may or may not already have a third party app that does that.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Trudy Claspill - Not sure if it helps, but I have a project that houses all customer issues. We then link "bugs" tied to that project using link issue "xyz" or "abc". I am able to filter using issueLinkType IN ("xyz", "abc").

This will show me all of those issues. But, trying to get those linked issues status and assignee on a board is the problem I am running into.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Let us back up a step and explore the problem that you are trying to solve by creating this dashboard.

What is that problem?
Why is it a problem that needs to be solved?
If you could get the dashboard you want, what would you do with that data?

I think there simply is not a solution available, without third party apps, that will support you getting the results you want in a format that can be used in a native Jira dashboard gadget.

But maybe I'm missing something in your use case. Can you walk me through the full scenario, with details?

You have a project that houses issues of interest. Let us say that project key is PRIME. PRIME is the project that holds the primary set of issues you want to start with, and then get also the issues linked to PRIME issues.

What filter do you apply just to get the issues of interest from PRIME?

- Let us say that you want the PRIME issues that have issues linked to them where the link types are "xyz" or "abc".

Could each PRIME issue be linked to multiple other issues with those link types?

Do you want all the linked issues of PRIME issues that use those link types?

So let us say your initial filter for PRIME issue is:

Prime-Filter: project=PRIME and issueLinkType in ("xyz", "abc")

That gets you a subset of the PRIME issues of interest.

There is no native function that will allow you to take the output of that filter and plug it into another filter such that you could get:

filter=Prime-Filter or issues in fictionalLinkedIssuesOfFunction("filter=Prime-Filter")

You might be able to put something together with custom code and the Jira REST API, but that doesn't give you source material that can be used in a native Jira Dashboard Gadget.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Trudy Claspill - I think your explanation does verify that I would not be able to do this natively, which is what I was afraid of. However, so you have the context, the scenario is below.

I have a project (xyz) that houses all issues that customers call in about. If we determine that a bug needs to be written up against an issue, we write that bug in other projects. I have created two issue link types, "Created for "XYZ" "Fixes for "XYZ."

What I am wanting to do is show the "XYZ" project, but also show the linked issue ('bug") to that "XYZ" project. Since the actual work is being done against the "bug" and not the "XYZ" project, I need to see the status of that "bug" and also whom it is assigned to.

Hopefully this makes sense.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Are the bugs created only in a specified subset of projects, or could they be created in any project in Jira?

With these next questions I'm not trying to be difficult. I'm just trying to really drill into the problem you are trying to solve by gathering the information.

Why do you need to see this information?
What will you use the information for?
Why is viewing the issues individually, where the linked issue assignee and status can be seen, not an adequate solution?

Does the solution have to display the data in the Jira UI?

Perhaps an automation rule could be constructed to get what you want and send you results via email. Would that be an acceptable alternative?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

The bugs could be created in any project.

I need to see this information so I do not have to click into each issue to see the status. It is I want to be able to view all linked issues the the customer project in one dashboard.
Efficient reporting. We have set timelines on how quickly bugs need fixed, and I want to ensure focus from the devs are on the bugs when they get introduced.
See one.

I would prefer it on the UI so any stakeholder can quickly go in and see the status of the bug.

An automation would suffice for me, but because I want the stakeholders to be able to view this at any given time, it makes more sense to have it displayed.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Unfortunately there is not a native Jira solution that I can think of that would not require at least one app.

If you had a JQL-extending app you could at least create the filter that would get you the PRIME issues and all the linked issues that are linked by specific link types. You could then display those in the Filter Results gadget, though the linked issues would each be a separate row.

There are multiple such apps:

This one if free, but I didn't dig into if it is subsequently limited.

Advanced JQL Functions

https://werare.atlassian.net/wiki/spaces/AJF/pages/1003585552/Links#LinkedIssuesOfQuery

JQL Search Extensions for Jira

https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209269/Issue+links#linkedIssuesOfQuery()

Enhanced Search for Jira

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions/links-and-relationships#linkedissuesof