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

Can I create a "dynamic" filter that shows all issues more than a year old?

Justin Corcoran

I know I can create a filter that is NOT dynamic that will show all issues more than a year old like this:

project = "System Issues" and createdDate < '2011/01/25'

But I'd like the date to be dynamic, so it'd be something like project = "System Issues" and createdDate < 'now() + 365d'

Is this possible? The exact query I have above does not accomplish this goal.

Accepted answers

Nic Brough -Adaptavist-

Leave out the "now" function and use a - to say "ago". Createddate >-365d

Actually, try to swap to the simple filter and use the helpful "from / to" help popup to get the clause you need, then swap back to JQL if you need to.

All comments

Nic Brough -Adaptavist-

Leave out the "now" function and use a - to say "ago". Createddate >-365d

Actually, try to swap to the simple filter and use the helpful "from / to" help popup to get the clause you need, then swap back to JQL if you need to.

NielsJ

Cool, I didn't knew that :-)

NielsJ

The JQL Enhancement Functions plugin seems to provide what you like:

created <= periodstart(year, -1)

https://plugins.atlassian.com/plugin/details/22514

Justin Corcoran

worked like a charm, thanks!

Mike Huber

created < -365d

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

filter