It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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 votes


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 :)

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.

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.

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 :)  

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,

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
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

1,971 views 8 3
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you