Auto mail filter subscription every 10days

[Madhura sarwade]

HI,

I want to introduce auto-email alerts to be sent from Jira for the requests post ‘25’ days of ageing.

ageing is defined in JQL as "created before 25days and not resolved".

If still no response /progress, a reminder to be sent at every 10 days post 25 days of ageing.

Please help with accurate JQL and filter subscription.

If I use cron expression of every 10 days, it will get triggered after 10 days and tickets between day1- day 10 will exceed the ageing by 10+days

[Earl McCutcheon]

Hello @Madhura sarwade ,

Conceptually having any gap in the interval that is relaying on a cycle there will always be a possibility of missing that gaps worth of data on the overlapping time period, and you would need the subscription to send with the minimal amount of overlap that is acceptable or use an approach when you are looking at both the issues that will become invalid in the time period as well as which ones are past the time period already.

As an example using creared you could look into defining two queries the first being the one you noted already on the 25day cycle for already breached, the second on a created before 15 days (based on 25 days -10 day possible gap) for an indicator of what issues have a potential to go into the second query if not actioned in the next 10 days,  subscribing to both on the same interval.

Another approach would be to use a date field such as the due date instead of basing it on the created date so you can query against the expected completion and past completion rather than based on creation time.  to do this  look into either add-ons to set a date field automatically or require a date field be set manually on creation and still using a similar 2 filter approach.  A method like looking into populating a date field, such as the duedate field as described in this post using the third party tool ScriptRunner would allow you to have the due date set for the desired 25 days out from creation:

• https://community.atlassian.com/t5/Jira-Core-questions/Automatically-Set-Due-Date/qaq-p/240779

Then there is an example of using the duedate for the filter subscriptions in the following post for a Approaching due date and past due date JQL:

• https://community.atlassian.com/t5/Jira-questions/Re-Due-date-reminder-emails/qaq-p/641859/comment-id/210979#M210979

Regards,
Earl