How to set priority based on date calculation?

[Devin Smith]

So I'm a fairly new JIRA admin and I'm trying to set something up so that JIRA will:

• Calculate the number of days between today's date and the "Target Finish Date" (a date picker custom field value)
• Set the priority of job to a specific value based on the results of the above calculation
  • For example, number of days >200; set priority to LOWEST
  • 100<number of days<200; set priority to MEDIUM
  • number of days < 100; set priority to HIGH
  • etc.
• This should be updated on a set interval, either once a day at like midnight or some other off peak hour, or set it up so that one person can simply run this script and bulk update all the issues in the project.

[Lauren Christianson]

You could do this by setting up filters for each, something like:

Filter 1:
project = "Project Name" AND targetFinishDate > 200d

Then use the bulk edit option to select all results and update the priority manually (3x, once for each filter). This wouldn't take too long but would still require some manual work. Hopefully someone else could answer with a better way to do it automatically, but you could do this in the meantime.

[Devin Smith]

Thanks for the reply! That's not a bad temporary application, and in all honesty that's sort of what we've been doing already - fortunately our engineers have been getting work done way before target finish dates, so the automatic update for priorities haven't been critical, but as our program continues to grow, I wanted this to be something already in the works for when it becomes more relevant.