This page relates to an older version 1.20 of Rich Filters for Jira Dashboards for Server & Data Center. See the documentation index for other versions, or for the Cloud version of Rich Filters.

Use Working Queries

By the end of this tutorial, you’ll be able to split your list of issues in two groups: cancelled and non-cancelled issues issues. Each group will be displayed by a different Rich Filter Results gadget and both of them controlled by the same Controller.

In this example we consider cancelled all the issues that have a non-empty resolution different from 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 already have 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.

  1. Open the configuration of the Rich Filter Results gadget you already have in your dashboard
  2. In the Working Query add the JQL resolution in (EMPTY, Fixed). This JQL fragment will always be applied (ANDed) to the JQL filter that feeds the gadget. Therefore, this gadget will display only issues having no resolution or the resolution Fixed (this is what we consider to mean 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. 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 issues whose resolution is Fixed or empty (“Unresolved”).
    Click on the Closed static filter button. The filter results gadget reloads, and only fixed issues 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 two other gadgets. Add the working query resolution not in (EMPTY, Fixed). Set the title of the gadget to Cancelled so that users can tell easily what the gadget displays.
    Optionally, set a different color for this gadget.
  7. Click on Customize Views. Select only the Delivery view—the gadget will display only this view for the Cancelled issues. 
  8. Save the configuration of you gadget. The gadget will have the title Cancelled and will display only the cancelled issues (non-empty resolution different than Fixed) using the Delivery view.
  9. Click on 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 issues and the second one will show the Closed issues having a resolution other than Fixed.

The Working Query is a powerful mechanism allowing you to split your issues in as many groups an you want (overlapping or not). All Rich Filter Gadgets support this feature (except for the Controller, for which this setting is not relevant).

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