JIRA Custom Filter Query

Question

When we use KANBAN board, we would like to use custom filter which require below

・We would like to count how many days has passed since one ticket has been placed in particular status.

For example, we would like to filter more than 2 weeks has passed since ticket placed in planning status.

Does someone provide sample query of this kind of custom filter?

Thank you,

Masa

Masahiro Morikawa · Answer

Hi @Walter Buggenhout

May I ask add one more condition.

Please allow me to describe below.

As you can see in the attached, we have 5 stages, on-hold, planning, in progress, done, completed,

-Condition

We would like to count the number of tickets remain in either of "on-hold, planning, in progress, done" status meaning except for "Completed" status for more than 2 weeks.

Can this kind of query be created?

our logic is that if the ticket becomes completed status, then we don't need to take care but if the ticket exist in other status, we need to track them also we will count the number and report it to management level.

If you have any unclear point, please let me know.

Regards,

Masa Morikawa

Masahiro Morikawa · Answer

Hi @Walter Buggenhout

Thank you very much for your quick response.

>Do you want to add a quick filter to highlight issues that have been stuck in a certain status without being updated?

Yes, I wanted to do this.

Please let me try to create the filter suggested by you.

Regards,

Masa Morikawa

Walter Buggenhout · Answer

Hi @Masahiro Morikawa and welcome to the Community!

The JQL filter for your board retrieves all issues that you need to see on your board, that means in every status on the board. Because of that, I am not really sure what your requirement is exactly. Do you want to add a quick filter to highlight issues that have been stuck in a certain status without being updated? Do you want issues to appear in the backlog only after they have been placed in a certain status for some time? Something else?

Anyway, from the technical side of things you can filter for issues that have been sitting in a certain status for 2 weeks (14 days) using history searches, like in this example:

status = planning AND status CHANGED TO planning BEFORE -14d

Hope this helps!