---
title: "Use working queries"
canonical: "https://support.appfire.com/space/RFP/803406010/Use%20working%20queries"
format: markdown
---
> Macro (aura-html)

By the end of this tutorial, you can split your list of work items into two groups: canceled and non-canceled. Each group will be displayed by a different Rich Filter Results gadget, which is controlled by the same *Controller*.

![Rich Filter Results gadget](media://f1aa8bc7-3cc2-4bbd-bcb5-20f1c0a5a55a)

> ℹ️ In this example, we consider canceling all the work items with a non-empty resolution other than Fixed. Depending on your Jira configuration, you might have different resolutions and conventions.

## How to use the working queries

> ℹ️ For this tutorial, you need to have already created a rich filter and a dashboard with a Controller and Filter Results gadget based on the rich filter. We have used the rich filter and dashboard created in [the previous tutorial](https://appfire.atlassian.net/wiki/spaces/RFP/pages/803406028).

1. In the *Dashboards* page, click the** Rich Filters icon **() > **Configure gadget** for the *Rich Filter Results* gadget you already have in your dashboard.
  
2. Add the JQL `resolution in (EMPTY, Fixed)` in the **Working query**. This JQL fragment will always be applied (`AND`ed) to the JQL filter that feeds the gadget. Therefore, this gadget will display only work items with no resolution or the resolution Fixed (this is what we consider not-cancelled in this example).
  
3. Customize the **Title** of your gadget: write *Not Cancelled* so that users easily understand what the gadget displays.
  
4. Click **Submit** to save the configuration of your gadget.
5. You’ll now see that the gadget has the name *Not Cancelled* as configured. Also, it displays only work items whose resolution is *Fixed* or empty (*Unresolved*).  
Click the **Closed** static filter button. The filter results from gadget reloads, and only fixed work items are displayed.
  
6. Add a new *Rich Filter Results* gadget to your dashboard. Base this new *Rich Filter Results* on the same Rich Filter as the other gadgets. Add the working query `resolution not in (EMPTY, Fixed)`. Set the gadget's title to *Cancelled* so that users can easily tell what the gadget displays.  
Optionally, set a different color for this gadget.
  
7. Click **Customize shown views**. Select only the **Delivery** view—the gadget will display only this view for the canceled work items.
  
8. Click **Submit**. The gadget will have the title *Cancelled* and display only the canceled work items (non-empty resolution different than *Fixed*) using the *Delivery* view.
  
9. Click the **Closed** static filter in your *Controller*. This will impact both *Filter Results* gadgets (all gadgets based on the same rich filter in the dashboard). The first one will show the *Closed*/*Fixed* work items, and the second one will show the Closed work items with a resolution other than *Fixed*.
  

> ✅ The *Working Query* is a powerful mechanism that allows you to split your work items into as many groups as you want (overlapping or not). All Rich Filter Gadgets support this feature (except for the *Controller*, for which this setting is irrelevant). Also, using the ORDER BY clause in a working query will overwrite the base filter's ORDER BY clause, allowing you to customize the default ordering of work items for that gadget.