How to trigger an email just 7 days before the quote/jira issue expires

If the Current date is less than 7 days for the Quote Valid Until(field) Date and the Quote is in “Quote Positive”(status) and “Catalogue Positive”(status) then a email should be triggered.

Need to implement this logic in JIRA tool. Please help.

1 answer

0 vote
Alexey Matveev Community Champion Dec 07, 2017


1. You should create a filter with a JQL condition like this

assignee = currentUser() and "Quote Valid Until(field) Date" < -7d and status in ("Quote Positive", "Quote Positive")

2. Make subscription for the filter which would send a email on schedule. You can choose an option if you want an empty result list to be sent or not.

You can read more about filters in the following article


Hello Alexey,

I have implemented this logic and It's working for me too.However, I am unable to find the place where I can change email/subscription content.

Could you please suggest any solution for this.


Thanks in Advance :)

Alexey Matveev Community Champion Dec 13, 2017

What do you mean by content? Do you mean where to schedule the email sending? If so, then kindly read the article


Now, I am getting details about filter name, Subscriber, Key, Summary in the email body and I need to send email including custom field values.

Can we edit the email body for the above requirement.

Alexey Matveev Community Champion Dec 13, 2017

I see. You need to configure filter fields. If you open your filter in issue navigator then push "Columns" button, then choose "Filter" tab and choose all columns which you want to be sent. You will receive email with all these fields.


I can see selected columns in the filter, however getting the email with no field details, 

Any step, I'm missing.

Alexey Matveev Community Champion Dec 13, 2017

You need to configure columns for the Filter tab. 

Kindly read more info here

I did the same, still not getting the field info


Hello Alexey,

I updated User Preferences for Email Type to HTML, now I am getting mail with filtered columns.

Thank You :)  

Alexey Matveev Community Champion Dec 13, 2017

Nice to hear. Thank you for letting know :)


Hello Alexey,

I have to meet the deadline, my code is not working.

Could you please suggest any solution for the below query,

Alexey Matveev Community Champion Dec 14, 2017

Do not take me wrong but I participate in this community in my free time as a volunteer. Answering your linked question would take more time than I can afford. I am really sorry. I hope everything will be fine. Do not give up.


Hello Alexey,


I understand, no worries.

Thanks for the reply  :)

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Fadoua M. Boualem
Published yesterday in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

446 views 6 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you