JQL Query to send mails to everyone nearing an expiry date

[Kiran]

I have an expiry date and would like to send mails to everyone once the expiry date is 30 days ahead of current date. Need a JQL for that.

[Fabio Racobaldo _Herzum_]

Hi @Kiran ,

you can do that using filter subscription https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-3-of-4

Hope this helps,

Fabio

[Hamza Chundrigar]

Hi @Kiran 

You can accomplish this by using a combination of JQL + Subscription Filters as well as with Jira Automation.

There’s another community post that explains how to accomplish this using these methods:

• https://community.atlassian.com/t5/Jira-Software-questions/Send-notifications-when-due-date-is-occuring/qaq-p/1822239
  
  
• For reference: JQL - using filters and subscriptions

Hope it helps!

Hamza

[Kiran]

Thanks!