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

Display JIRA filter results gadget using JQL instead of saved filter?

Mark Gancsos

So right now I can run a search, save it as a filter, and then display the filter results on a dashboard. Is there any way to show JQL search results as a pie chart without having to first save it as a filter?

Say I want to see all the camera product orders that a company has fulfilled on a dashboard. I search for the following:

status = closed
issuetype = "Product Order"
ProductType = "Camera"

That will show me all the fulfilled camera orders. Then I save this as a filter called "Closed_Camera_Orders", and put it on a dashboard using the Favorite Filters gadget.

Now we get a request to see all closed camera orders for each state in the USA. Do I really have to make 50 filters that are all some version of the following just to load them into gadgets?

status = closed
issuetype = "Product Order"
ProductType = "Camera"
US_state = "Alabama"

There's no gadget that takes "JQL String" as an input instead of instead of "Saved Filter"? Then I could at least enter "filter IN [7654765] AND US_state = "Alabama" in one gadget, and "filter IN [7654765] AND US_state = "Arkansas" for another.

That would be way better than having to save 50 search strings as filters.

Thanks!

Accepted answers

All comments

Nic Brough -Adaptavist-

I'm afraid the gadgets all take a simple filter, not JQL directly.

Mark Gancsos

Blargh. Ah well, thank you! So everyone just creates tons of filters?

Nic Brough -Adaptavist-

I'm afraid we do, yes.

Marcelo Zucchelli

@Nic Brough -Adaptavist- do you happen to know if there's a feature request for dashboard gadgets to take JQL as input?

PD Sheehan

I was searching for something else and saw this post.

I know this is not an answer, but there is an add-on that provides this functionality: https://marketplace.atlassian.com/apps/5228/show-saved-filter-with-columns-for-jira?hosting=server&tab=overview

In addition to storing the JQL within the gadget preferences, it also has options to set the title and header-bar color of the gadget.

We acquired this add-on years ago before the default filter gadget allowed column selection and that was the main differentiator. Now, just the color and JQL may not be worth the license cost for us, but maybe it is for you.

Radek Janata

Rich Filters for Jira Dashboards add-on will do exactly you want.

Alternatively, you could use cheaper Show Saved Filter with Columns for Jira add-on (suggested by @PD Sheehan above) and use the JQL you suggested in the dashboard gadgets (e.g.: filter IN [7654765] AND US_state = "Alabama").

Lucy Dilts_rfe46i

The whole create JQL filters is garbage. Whomever designed this had no foresight when it came to managing and sharing them. We have 1000s of filters which has made finding them beyond frustrating.

ALSO, the advance search, which is not even consistently available on relevant gadgets, doesn't even work! EVEN IF YOU COPY THE FILTER NAME EXACTLY AND SEARCH FOR IT.

COMPLETE GARBAGE. Looking forward to our move to Azure DevOps!!!

Welcome!

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

Quick Links

Find more posts tagged with

jira-core

jql

filter