How to set a Dynamic Date range in search filter criteria?

[Ananda]

Hi all, I am looking to track last update of issues over the following date ranges: 1-10 days , 11-20 days, 21-30 days and so on... These date ranges are not restricted to the start of the month, i.e. if an issue was last updated on say 20th June then it would appear in my filter for 11-20 days as on 10th July and not on the 1-10 days filter. Any suggestions how to search for a dynamic date range? Thanks

[Joshua Thompson · Accepted solution]

I may have missed the boat but can't you just use the normal JQL syntax?

Last updated within 10 days: updatedDate > -10d

11-20: updatedDate > -20d and updatedDate < -10d

21-30: updatedDate > -30d and updatedDate < -20d

[Nic Brough -Adaptavist-]

That's exactly what I was going to post.

With the additional point that JQL has a couple of other potentially useful functions like endofweek, endofmonth etc (start ranges and years etc also there)

[Ananda]

Thanks Joshua, yes i seem to have skipped that rather simple solution!

[Bhushan Nagaraj]

Sorry I misunderstood the question. I thought you wanted to list all the issues irrespective of the month or year, but created between the 10th and 15th day of the month.

[Bhushan Nagaraj]

Hi Ananda,

You can write your own jql plugin to achieve this functionality. I have documented the steps for writing a jql function here.

https://bitbucket.org/bhushan154/jira-jql-plugin-tutorial/wiki/Home

You can download the source code from here.

https://bitbucket.org/bhushan154/jira-jql-plugin-tutorial/overview

If you are just interested in using the function, download the file from here and run the query

issue in dateRange(PROJECTKEY, startDate, endDate)

Example:

issue in dateRange(DEMO, 5, 10)

https://bitbucket.org/bhushan154/jira-jql-plugin-tutorial/downloads

Cheers