JQL Query to send mails to everyone nearing an expiry date

Question

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.

unknown · Answer

Thanks!

Fabio Racobaldo _Catworkx_ · Answer

Hi @[deleted],

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 · Answer

Hi @[deleted]

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