Hi there,

I need to retrieve the tasks related to an account having the account id.

I am developing a trigger that, when an activity is deleted has to check if there is any other activity for that account in order to update the field "Evolution stage". If the last activity is deleted the evolution stage must go back to "Agency to be contacted".Here is my code:

trigger TaskSumTrigger on Task (after insert,after update,after delete,after undelete) {

    if (Trigger.isDelete){
           List<Task> tasks = new list<task>();
            tasks= Trigger.old;   
            if (tasks.size()== 1){
               List<ID> acctIds = new List<ID>();
                for (Task tk : tasks) {
                    acctIds.add(tk.AccountId);
                }  
               Account account =new Account(Id=acctIds.get(0));

             //HERE I NEED TO CHECK IF IT HAS MORE ACTIVITIES TO DO THE FOLLOWING OR NOT
            task[] rest=[select id from task where AccountId ????????]
            if (rest.size()==0){//IF THERE ARE NO MORE ACTIVITIES DO THE FOLLOWING

                if (account.Evolution_Stage__c=='4 - Bookings done'){
                   No hacer nada    
                }else if (account.Access_codes_sent__c==NULL){
                    account.Evolution_Stage__c='1 - Agency to be contacted';
                    update account;
                }else{
                 /  account.Evolution_Stage__c='2 - Access codes created';
                   update account;
               }
             }           
             }
    }
    else{
    Task[] tasks;

        tasks= Trigger.new;
       
    // creo un conjunto set de ID   
    List<ID> acctIds = new List<ID>();  
    //cargo este set con los id de las cuentas de los eventos  
    for (Task tk : tasks) {
        if ((tk.Status=='Completed') & (tk.BOL_Level_III_Result__c!='')){
            acctIds.add(tk.AccountId);
        }
    }   //ahora acctIds es una lista sin repeticiones de identificadores de cuentas
   
    //Actualizar los evolution stage de las cuentas si cumplen las condiciones
    for(Integer i=0; i< acctIds.size();i++){
        Account account =new Account(Id=acctIds.get(i));
        if (account.Evolution_Stage__c!='4 - Bookings done'){
            account.Evolution_Stage__c='3 - Agency Contacted (Visit / Call)';
            update account;
        }
    }
    }

}

I got completely stucked in the part where I want to check if there is any other activity related to the account. could you please help me?Any ideas??

Thanks a lot for your help!!