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

[Robert]

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)?

[John Funk · Accepted solution]

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/

[Jack Brickey · Accepted solution]

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....

1. create a custom date field
2. 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
3. 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.

[Robert]

Hello @Jack Brickey 

I was looking for a simple JQL approach, but as I see I won't get it :) I also search for issues not updated for x days, but this time I was asked to provide a simple solution to filter issues where nothing happened x days after creation time (and maybe those issues are older).

Thank you

[Nic Brough -Adaptavist- · Accepted solution]

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