You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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)