Automation rule to send an email on missed Version Release Datete

Question

Environment: Jira Cloud

Space: Company-Managed

I have created a version with a specific release date. I want to notify the stakeholders if the version misses the release date.

Trigger (Scheduled daily 9 am) and Action (Send Email) are clear, but I am not able to find a way to detect that the version has missed the release date. I understand that Release Date is not a JQL field. Is there a way to achieve this?

Appreciate community's help on this.

Igor Medeiros - Modus Create · Answer

Hi @Parag Shah

Adding to what Rilwan and Trudy sent, the label-plus-tracking-issue path works as a quick fix. Create one issue per release with the release date as due date, label it `release-tracker`, and let a scheduled JQL rule fire the email. The cost is maintaining a parallel set of issues alongside the actual versions.

To drive the notification directly off the version's release date, our app Notification Assistant for Jira supports date-based and CRON triggers with JQL filters and custom recipients.

Feel free to reach out if you'd like to learn more.

Rilwan Ahmed · Answer

Hi @Parag Shah , I have a workaround. Check if its feasible for you. For each version, create a Jira ticket and make the version release date as ticket's Due date. You can also add some labels to each tickets (example: Release-dates) Based on this data, you can create an scheduled automation rule to check for due date and send email. Example JQL: labels = "Release-dates" AND due < now() AND status != Done Trigger: * Select Scheduled * Interval: Daily * Time: 9:00 AM Action 1: Lookup Issues * Click New component > Action > Lookup issues * JQL: labels = "Release-dates" AND due < now() AND status != Done Condition: * Click New component > Condition > Issue matches condition * Select Advanced compare condition * First value: {{lookupIssues.size}} * Condition: Greater than * Second value: 0 Action 2: Send Email * Click New component > Action > Send email * To: XXXXXX * Add required email Body as required.

Trudy P Claspill · Answer

Don't hesitate to ask if you have more questions about the action or the API!