Use working queries

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.

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.

In the Dashboards page, click the Rich Filters icon () > Configure gadget for the Rich Filter Results gadget you already have in your dashboard.
Add the JQL resolution in (EMPTY, Fixed) in the Working query. This JQL fragment will always be applied (ANDed) 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).
Customize the Title of your gadget: write Not Cancelled so that users easily understand what the gadget displays.
Click Submit to save the configuration of your gadget.
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.
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.
Click Customize shown views. Select only the Delivery view—the gadget will display only this view for the canceled work items.
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.
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.