fbpx

How Dynamic Filters: JQL Replacer add-on helps Project Managers each day

Are you busy with something? You can listen to this article in audio format:

As a project manager, you may have several development teams in Jira to work with on a sprint.

In addition, you may work in parallel with the other departments. E.g., Marketing to promote and improve your products; human resources to find new developers for future projects.

All these communications mean that every day you need to control the tasks you have created. Among other things, it’s also good to know:

  • what tasks have other departments have set for you;
  • what issues developers have completed during the sprint.

Let’s overview some common cases you may face every day and how Dynamic Filters: JQL Replacer will help you to speed up data sampling.

Case 1. You want to see a list of tasks you have created during 2 weeks or a month for 3 projects: Project 1, Project 2, Project 3.

That will help to control the statuses of the created issues.

1. Open Smart Fields Constructor. Choose your name for the first query, as in the example below.

How to filter issues and task by creator with Jira JQL

2. Use the IN operator to get 3 projects and choose the ones you need.

How to add 3 project for Jira at once by JQL

After that, you should select created 2 Smart Fields for your new brand JQL filter.

Click on “+Add Fields”, select “Smart Fields” and choose 2 new Smart Fields.

2 new conditions with Smart Fields will be added to the Tool Bar and all data will be filtered on the fly.

How to add Smart JQL field to the Filter

There is also another way to select a project – without the construction of conditions. You can use additional columns to control the display of projects using Jira Issue Fields through the menu “+ Add Fields”.

Go to the menu “+ Add Fields”, select “Jira Issue Fields” and type Project, and select it from the list.

How to select 3 jira projects at once

Now you can choose which projects will be used to filter tasks. Simply click the checkbox next to the appropriate project.

How to add 3 project to JQL Jira filter

We can now save the conditions of our sample to a shared Filter.

How to save shared filter Jira JQL

With the saved filter, you can:

Use visual information with Jira dashboard gadgets.

how to add Gadget Dynamic Filter to DashBoard

Use the “Configure” option to set Dynamic Filter Gadget

How to configure Jira Gadget

How to configure Dynamic Filter Gadget

Use this saved filter in other add-ons (e.g., Time in Status, to get data on 2 or 3 projects simultaneously).

Case 2. You want to monitor tasks for some time for a performance report.

Let’s take all the tasks assigned to you last week.

LAst week JQL filter Jira

Choose yourself as an assignee. Select those two created samples.

How to select and filter Assignee task by Jira JQL
How to run JQL filter by Smart Fields

You’ll receive a list of tasks according to the condition. But which tasks do belong to which projects?

Try to launch the Column Manager and add a new column to the results’ table – this is the project.

Now you have a list of projects for tasks assigned to you. You can improve the table format.

If you want to put the project closer to the issue key – try the Drag-and-drop option. To do this, you need to hold the column header with the mouse cursor and move it to the desired location.

If you’d like to sort the tasks according to their status, click on the status header.
All issues are sorted within their project.

Hot to add new column to Filtered table

Case 3. You want to see the issues that have changed during the current week for “Project 1”.

You need to determine the number of tasks that have changed their status from “To Do” to “In progress”.

Create a new search rule with Smart Field Manager (1,2). Select the created option. Set conditions for a week in the Smart Field Manager (3).

How to filter status what was changed Jira Cloud JQL

Have you tried the add-on yet? Is there a case you’d like to share or solve?

Sergey Kibitkin

The author of the article

I enjoy launching and managing projects in eCommerce, IT and WEB technology. To each project I bring expert domain knowledge, strategic vision, excellent communication skills, efficient management, and a lot of energy, enthusiasm and creativity.

Find out more about the Dynamic Filters: JQL Replacer & Gadgets

Visit the app page for more information

Leave a Reply

Your email address will not be published. Required fields are marked *