How do I modify the query which displays data for my dashboard

[barry kimelman]

quite a while ago, someone helped me setup  a dashboard/query to display my tickets as I would like to see them displayed. Now I was thinking about modifying the query behind my dashboard. I clicked on an icon to edit my dashboard, but that screen did not have anything to modify the query behind the dashboard.   How can I modify the query behind my dashboard ?

[Liam Sampson]

Hi @barry kimelman i appreciate this is a late reply, however you can edit the filter behind the dashboard gadget by going to Issues/Manage filters. You can edit your filters here and then assign them to your gadgets in your dashboard.

[John Funk]

Hi Barry,

Atlassian has rolled out the ability to have multiple people be able to edit dashboards. Would that solve your problem? 

[Daniel Ebers]

Hi @barry kimelman

you're almost there. In simple words the relation in Jira is a dashboard which contains gadgets and those are powered by JQL queries.

JQL queries, when saved, are often referred to as filters - so those filters are the 'fuel' to powerful dashboards, using gadgets.

You can see them regularly when inspecting one of the gadgets on your dashboards or when creating a new one (then you need to provide a filter or initially to form a JQL query).

Please see further documentation on this here:

• Configure filters:
  https://support.atlassian.com/jira-software-cloud/docs/configure-filters/

Some inspiration what is possible then was published in a blog post which I found always interesting and useful:
https://confluence.atlassian.com/jiracore/blog/2015/08/5-steps-to-a-killer-jira-dashboard

Regards,
Daniel

[barry kimelman]

thanks for the reply. However, I still don't see any way to modify the query behind my dashboard.

I click on "manage dashboards". Next I click on edit. in the edit screen there is nothing to modify the jql query.

[barry kimelman]

something just came to mind.  Is it possible I am not able to change my jql query because I do not have sufficient privileges ? Do I need to be an admin to change the jql query ?

[Daniel Ebers]

Yes, this is likely the case.
The person who is the owner of the dashboard is probably the first one you should speak to. In case this won't help you should indeed consult your Jira administrator.

[Alexis Robert]

Hi @barry kimelman , 

you actually need to modify the query used in the gadget that's on your dashboard, not the dashboard directly.

You can have a look at the documentation on how to edit a gadget : https://confluence.atlassian.com/jiracoreserver/adding-and-customizing-gadgets-939938014.html#:~:text=If%20you%20don't%20already,in%20Gadgets%20for%20Jira%20applications.

Let me know if this helps, 

--Alexis

[barry kimelman]

that was a lot of interesting info to look at. however I did not see anything which would let me modify an existing gadget/query

[José Nogueira]

Hi

I see this is an old topic, but might be of interest for anyone.

I am also starting with this, and here is how it works for me:

1. On the dashboards gadget, take note of the filter name
2. Click on Issues in the menu bar
3. Click Manage Filters
4. Search for the filter you picked at step 1
5. Click on it (the filter panel should appear, including the JQL instruction on top)
6. Make your changes and click Search to see the results
7. Once you get the required results, either
   1. if you have permission, it is automatically saved or you have to click on Save (click the 3 dots button and Discard to undo),
   2. or click Save as and update the gadget in the dashboard with this new filter

Hope this works for you too

Cheers