nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter for Past Due Actions

Bruce Thomas_cu59nn

I would like to develop a filter to show all past due actions for the current date.

Example:

1. Actions which should have started but have not.

2. Actions which should have ended but have not.

Accepted answers

All comments

Max Foerster - K15t

Hi Bruce,

welcome to the community! How experienced are you using JQL? Because in general I'd say we can build the needed filter for you but we're lacking information here.

How does "actions which should have ended" translate to the way your Jira is configured and how you're using it? Are you using resolutions? Are you just using a specific status?
How does "actions which should have started" translate to the way your Jira is configured and how you're using it?
are you using the Due Date system field or any other field to determine what is past due and what not?

I also recommend reading the following articles and documentation:

JQL: The most flexible way to search JIRA (1/4)
JQL: The most flexible way to search JIRA (2/4)
JQL: The most flexible way to search JIRA (3/4)
JQL: The most flexible way to search JIRA (4/4)
JQL Advanced searching (Overview about all functions, operations, keywords etc.)

Best, Max

Bruce Thomas_cu59nn

Max,

Thanks for the response, below are responses to your questions.

How does "actions which should have ended" translate to the way your Jira is configured and how you're using it? Are you using resolutions? Are you just a specific status?
- Response - We are using "To Do," "Working," and "Resolved."
How does "actions which should have started" translate to the way your Jira is configured and how you're using it? are you using the Due Date system field or any other field to determine what is past due and what not?
- Response - We are using Start and End dates. Basically, the Start date is when we plan to start the action or Process Improvement event.

Max Foerster - K15t

Hey,

so from what you are saying the following query could be satisfying but you will have to check it yourself and make sure to reference the correct fields. The advanced issue search offers a great auto-complete feature to help you. It's just very important to use parentheses to glue the logical groups together

(status = "To Do" AND "Start date" < now()) OR (status != Resolved AND "End date" <= now())

The first half translates to "Every issue in the status "To Do" with a start date earlier than now". That seems correct, right?

And the second half translates to "Every issue which status is not equal to "Resolved" and with an end date earlier or equal to now.

Best, Max

Bruce Thomas_cu59nn

Thanks

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira