Trigger to update latest due date of task on Opportunity

Create a new custom field on opportunity called Update_Due_Date_of_Task__c (Date/Time) and create the below trigger on task object. 

 Output : If there are multiple tasks on opportunity the above custom field will be updated by due date which is greater from all task's due date.


Trigger updateLastActvtyUpdateOnOpty on Task(after update, after insert) {

    Datetime lastUpdatedDate;
    Set < String > whatIDs = new Set < String > ();
    for (Task tskObj: Trigger.new) {
        if (tskObj.whatId != null && tskObj.ActivityDate != null) {
            whatIDs.add(tskObj.whatId);
        }
    }
    If(whatIDs.size() > 0) {
        Task taskObj = [select Id, ActivityDate, WhatId from Task where WhatId =: whatIDs
                                 order by ActivityDate DESC LIMIT 1]; 
        lastUpdatedDate = taskObj.ActivityDate;
         // update Opportunity 's custom field Update_Due_Date_of_Task__c
        opportunity[] optyObj = [select Id,Update_Due_Date_of_Task__c from opportunity where Id =: whatIDs LIMIT 1];
        if(optyObj.size() > 0){
        optyObj[0].Update_Due_Date_of_Task__c = lastUpdatedDate;
        }
        update optyObj;
    }
}


                                

Comments

Post a Comment

Popular posts from this blog

Email Messaging from Salesforce

SingleEmailMessage  &  MassEmailMessage  classes are provided by Salesforce, which can be used to send an email or email in bulk to the users. First of all we need to create a  Helper class ,we will call this class using Trigger, whenever the condition met, the trigger will call this Helper class, and all the stuffs whatever we are doing, will be in helper class. We are using an email template too. Here is the Helper class named  "HelperContactTrigger" public with sharing class HelperContactTrigger { //static method public static List  sendEmail(List  contacts) { //query on template object EmailTemplate et=[Select id from EmailTemplate where name=:'Sales: New Customer Email']; //list of emails List  emails = new List (); //loop for(Contact con : contacts){ //check for Account if(con.AccountId == null && con.Email != null){ //initiallize messaging method Messaging.SingleEmailMessage singleMail = new Messaging.SingleEmailMessa...
Read more

Test-Driven Development in Salesforce

Image
 Concept - To Get some functionality working now and  improve or refactor it afterwards Hi Developers !!. This post is regarding   Test Driven Development   approach in Salesforce. Before going into any details or explanation about  "Test Driven Development in Salesforce" we need to know about (Test-Driven Development).  What is Test Driven Development (TDD) ?  Test Driven Development is an evolutionary approach to development which combines test - first development where you write a test code before  you write just enough production code to fulfill that test and  refactor (making code clearer, cleaner and elegant) . We can also say that TDD is a method of software development in which UNIT Testing is repeatedly done on source code. TDD is a method which will help us to get a better code in less time with no defects.  Benefits: There are many benefits of using Test Driven Development approach for software development. Some of...
Read more

Setting a default 'From' address when sending an email from Cases

global class EmailPublisherLoader implements QuickAction.QuickActionDefaultsHandler { // Empty constructor global EmailPublisherLoader() { } public string customLabelValue{get;set;} // The main interface method global void onInitDefaults(QuickAction.QuickActionDefaults[] defaults) { QuickAction.SendEmailQuickActionDefaults sendEmailDefaults = null; // Check if the quick action is the standard Case Feed send email action for (Integer j = 0; j < defaults.size(); j++) { if (defaults.get(j) instanceof QuickAction.SendEmailQuickActionDefaults && defaults.get(j).getTargetSObject().getSObjectType() == EmailMessage.sObjectType && defaults.get(j).getActionName().equals('Case.Email') && defaults.get(j).getActionType().equals('Email')) { sendEmailDefaults = (QuickAction.SendEmailQuickActionDefaults)defaults.get(j); ...
Read more