How to filter issues updated in a given time frame after created date?

Question

Hello!

I would like to see issues updated for example one month after the creation date.

Something like: updated >= (created + 30d)

How can I do it with JQL only (without add-on)?

Nic Brough -Adaptavist- · Accepted Answer

JQL doesn't support that function as yet, you will need an app to provide it.

Jack Brickey · Accepted Answer

OOTB you cannot do this w/ JQL. JQL doesn't support math functions. If this is something you will need on a regular basis then consider incorporating Automation and custom field. Something like this....

* create a custom date field
* set up a daily scheduled automation to check if an issue has been open for 30d and if so set today's date into the custom field
* use JQL to periodically check if the issue has been updated post the custom date.

Now maybe there is a better solution if I better understood what you are hoping to achieve. I'm used to seeing request for 'issue not updated for xx days' but this is different.

John Funk · Accepted Answer

Hi Robert,

You can probably get a list of issues using Automation For Jira as it has the ability to do a diff between date fields.

See this document for more guidance on using Smart Values to accomplish that:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/