Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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!

 

 

 

3 answers

1 vote

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.

1 vote

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

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

Like Valentin Dragin likes this

I'm afraid we do, yes.

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

Like # people like this

Yes, it was closed ages ago with something that can be summarised as "saved filters are JQL"

Having the same challenges here, managing tons of saved jql queries is super cumbersome over time and not efficient at all to manage, as opposed to having the ability to define your jql queries on the fly when adding new gadgets to your dashboards.

So many of the same jql queries that I have to create, except perhaps one single tiny criteria difference.

The gadget's 'Saved Filter' search box becomes harder and harder to use, as you keep creating more saved filters over the years across all your dashboards etc. I have hundreds of them, and the search becomes not super efficient and even buggy at times.

Would be soo easy if I could simply add and edit my jql query for a given gadget right on spot, directly on the gadget itself (..and let jira saves it behind the scenes, if that's really what they need behind the scenes, just abstract that to your dashboard creator users..).

0 votes
Radek Janata Community Leader Nov 06, 2021

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 @Peter-Dave Sheehan above) and use the JQL you suggested in the dashboard gadgets (e.g.: filter IN [7654765] AND US_state = "Alabama").

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

77 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you