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

JQL to search for issues older than 30 days from a specific date

Joseph Baker_6bz5ne

Hello all,

I'm trying to create a filter to see issues that older than 30 days old from a specific date (For example I want all issues older than 30 days from November 1st 2018). I've played around with "createdDate >= -30d" but that will give me issues older than 30 days from today.

Any way to enter a date into that query? I also have access to scriptrunner issuefunction if there's a way to do it through that.

Thanks!

Accepted answers

All comments

Antoine Berry

Hi,

If you are going to use a custom date, why are you not setting it directly, i.e.

created < "2018-10-01"

Joseph Baker_6bz5ne

I need the historical data on it, so rather than getting info on bugs with a specific createdDate, I need to get the issues 30 days old from a specific date.

Antoine Berry

I am not sure to understand. A filter returns a set of issues based on a request. If "created" is not satisfactory, you could use other system dates such as "updated" or "resolved", or any other date custom field.

For example, if you need to get issues that are between 1 month old and 2 month old on 1st November 2018 (using updated date), that would be :

updated > "2018-09-01" and updated < "2018-10-01"

If you need to know how old a specific issue is on a specific date, I am afraid you are gonna need some scripting to fill a custom field.

Antoine

Joseph Baker_6bz5ne

What I need is a query that gives me "On October 1st, these issues are 30 days old" or another way of putting it their created date is 30 days older than October 1st.

Mario Nigrovic

I'm surprised to discover that startOfMonth or startOfWeek accept a relative date, but "now" does not! That seems like kind of an oversight, doesn't it?

Antoine Berry

Hi,

If you want to use a relative date from "now", you do not have to write it, i.e.

created > -14d

will retrieve issues created in the last 14 days.

Mario Nigrovic

I also found that startOfDay takes a relative argument.

Thanks, though. I'm quite a novice at this and the definitions of the fields are not always obvious...

Antony Trucios

Also to expand this answer, if you want a very specific day this also works.

"Date field" <= -30d and "Date field" >= -31d

Cheers!

Frank_6z0d3j

Apparently this doesn't work for Confluence CQL although the fields are the same. The documentation is poor on examples. Any idea how to filter relative in CQL?

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-core

jql

atl-gruland

date

query