Use working queries in your dashboard

Owned by Cristian Oancea
Last updated: May 02, 2024 by Praveena Manohar
3 min read

By the end of this tutorial, you can split your list of issues into two groups: canceled and non-canceled. Each group will be displayed by its own Rich Filter Results gadget, which will be controlled by the same Rich Filter Controller gadget.

In this example, we consider canceling all the issues that have a non-empty resolution different from Fixed and Done. Depending on your Jira configuration, you might have different resolutions and conventions.

For this tutorial, you need to have already created:

  • a Rich Filter

  • a dashboard with one Rich Filter Controller gadget and one Rich Filter Filter Results gadget based on your Rich Filter.

We have used the dashboard we worked with in the previous tutorial.

Use Working Queries

  1. Open the configuration of the Rich Filter Results gadget you already have in your dashboard.

     

  2. Add the JQL resolution in the Working query field in (EMPTY, Fixed, and Done). This JQL filtering condition will always be combined (ANDed) with the JQL filter that feeds the gadget. Therefore, this gadget will display only issues with no resolution or the resolution Fixed or Done (which we consider not-cancelled in this example). Click Submit.

     

  3. Rename the Rich Filter Results gadget as Not Cancelled so that users easily understand what the gadget displays. 



  4. The gadget's title is Not Cancelled, and it only displays issues with resolution, either EMPTY (Unresolved), Fixed or Done.
    If you now click on the Closed static filter in the Rich Filter Controller, the Rich Filter Results gadget will be updated to show only fixed/done issues. 

     

  5. Add a new Rich Filter Results gadget to your dashboard. Configure it based on the same rich filter as the two other gadgets and add the working query resolution that is not in (EMPTY, Fixed, Done).

  6. Click on Customize shown views and add only the Delivery view; the gadget will display only this view for the canceled issues. Submit the configuration of your gadget. 



  7. Rename the gadget as Cancelled. Optionally, select a different color for this gadget.

     

  8. The gadget's title is Cancelled and only displays canceled issues using the Delivery view.



  9. Click on the controller's Assigned to Me static filter to turn it on. This will impact both Rich Filter Results gadgets (i.e., all gadgets based on the same rich filter in the dashboard). The first will show the fixed/done issues assigned to the current user, and the second will show the canceled issues assigned to the current user.

The working query is a powerful and versatile mechanism for customizing your gadgets. For instance, it allows you to split your issues in different groups (overlapping or not), to be used by different gadgets. Except for the controller, all the rich filter gadgets provide this feature.

Also, if you use the ORDER BY clause in a working query, this will take precedence over the ORDER BY clause of the base filter, allowing you to customize the default sorting of issues for that gadget.

See also

Add dynamic filtering to your dashboard.