Need to trigger notification every business day once the Business elapsed percentage field crosses 1

Reddymahesh
Tera Contributor

I have created custom percentage field on change_request table similar to business elapsed percentage on task_sla table. Using BR I am populating this custom field to be in sync with business elapsed percentage field on task_sla table. Once this custom field crosses 100% I need to trigger notification once on each business day end. Any ideas how to achieve this.

 

I am also facing issue that custom field not getting updated after 100%  even though OOB field on task_sla is getting updated.

5 REPLIES 5

@Sohail KhiljiOnce OLA breached more than 100%  I need to trigger  notification every 8 business hours (once per day) This should be sent to Business approval group on the change_request