---
title: "Use working queries in your dashboard"
canonical: "https://support.appfire.com/space/RFC/783941950/Use%20working%20queries%20in%20your%20dashboard"
format: markdown
---
> Macro (aura-html)

## Overview

> ℹ️ 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.

![Working queries.png](media://f2aa90da-f9f2-44d0-a5ab-22034129a219)

> ℹ️ 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](https://appfire.atlassian.net/wiki/spaces/RFCDOC/pages/783941943).

### Use Working Queries

1. At the bottom of the *Rich Filter Results* gadget, click ** Menu  **() > **Configure gadget** for 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 (`AND`ed) 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<span style="color: #172b4d">* *</span>or<span style="color: #172b4d">* *</span><span style="color: #172b4d">Done</span>.  
If you now click the <span style="color: #172b4d">*Closed*</span> static filter in the <span style="color: #172b4d">*Rich Filter Controller*</span>, the <span style="color: #172b4d">*Rich Filter Results*</span> gadget will be updated to show only <span style="color: #172b4d">*fixed*</span>/<span style="color: #172b4d">*done*</span> 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. Select *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.   
  
> Macro (inline-media-image)
7. Rename the gadget as *Cancelled*.
  
  The gadget's title is *Cancelled* and only displays *canceled* issues using the *Delivery* view.
8. Optionally, select a different color for this gadget.
  
9. Click 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, a<span style="color: #172b4d">ll the rich filter gadgets provide this feature.</span>
> ✅ 
> ✅ 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](https://appfire.atlassian.net/wiki/spaces/RFCDOC/pages/783941954).