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.
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.
Well you cannot subtract days from a specific date. But you can from jira built-in date functions such as :
startOfMonth(-1) // the first day of the previous month
startOfMonth(-14d) // 14 days prior to the first day of this month
So in your case, because you cannot do
created <= "2018-10-01" -30d (but you can do created <= -30d)
what you actually need is
created <= "2018-09-01" (since there are 30 days in September). You could as well use
created <= startOfMonth(-7) (since september was 7 months ago)
Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events