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; } } }

How to find Ideas with Target Date dangerously approaching? :-)

Simone Longoni_kf26s2

Hi there!

I have a Date field "Target Date" that represents when an Idea should hit the market.

I would like to have a Jira JQL filter that detects Ideas that are about to approach their Target Date as I need to prioritize actions on them (I plan to have subscription on this filter...).

I was expecting to write a query on such Date field in the regular Jira way... something like

targetDate >= -30d

... but "<", ">", etc operators do not look supported.

Am I missing something?

Any suggested alternative to address to the above mentioned need?

Accepted answers

Chris Timms

Hello @Simone Longoni ,

The date field structure JPD uses isn't well supported in the rest of Jira yet and I have found JQL has quite a bit of difficulty with it.

But, you can do what you are looking for in JPD directly!

Set up a new view
Add a new filter for Target Date
- Date Starts within the next months
- Enter a number for how far you want to look. e.g. entering 3 today will return all issues with a target date starting in January

This will show you all the ideas in your JPD project that start in the next three months. You can add additional filters (for example, if you want to only look at items that are in your backlog and not in flight).

Hope that helps!

Regards,

- C

All comments

Chris Timms

Hello @Simone Longoni ,

The date field structure JPD uses isn't well supported in the rest of Jira yet and I have found JQL has quite a bit of difficulty with it.

But, you can do what you are looking for in JPD directly!

Set up a new view
Add a new filter for Target Date
- Date Starts within the next months
- Enter a number for how far you want to look. e.g. entering 3 today will return all issues with a target date starting in January

Hope that helps!

Regards,

- C

Bill Sheboy

Hi @Simone Longoni

You are correct, and...

After some digging and experimenting I found that the JPD team appears to have created a new "date range format", which is neither a date field nor JSON compatible. Which is probably one reason it does not work with JQL or directly with automation rules. (Although that second one can be hacked a bit using text functions and advanced edits...)

The format is plain text, like this {"start":"2023-11-13","end":"2023-12-13"}

I recommend regularly searching this group for "date field" to learn if the team has made any changes / improvements in using this field. Otherwise, the suggestion Chris made seems to help with your Target Date checks.

Kind regards,
Bill

Tanguy Crusson

Hi, you can use formatting on the date field to highlight the ideas for which a date is coming soon or overdue, then use that fields in your views: Screenshot 2023-10-26 at 11.07.08.png

Simone Longoni_kf26s2

Thanks @Chris Timms!

I am unfortunately looking for a way to send push notifications by email based on filter match.

Still, having a JPD view could enable a pull way to keep an eye on what is about to "expire".

Cheers,

Simone

Bill Sheboy

Just a follow-up...

Based on your other responses that you want to do a "push" message, I believe you could using an automation rule:

gather ideas with a non-empty date field using a lookup issues action and JQL
parse the field to get the date value and perform a comparison with smart value, list filtering to your target {{now.minusDays(30).jiraDate}}
and report out the results in a "push", such as email or message

Welcome!

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

Quick Links

Find more posts tagged with

jql

date

operators