function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
bhanu_prakashbhanu_prakash 

update status based on realted list

Hi team,

I have written a trigger to update status on case
Note : If none of apporval not accept case status need to became reject

trigger updatestaus1 on Case_Approval_Tracker__c(after update) {Set <ID> case_ids = new Set <ID>();
 for(Case_Approval_Tracker__c c : Trigger.new) {
  case_ids.add(c.caseid);
 }

 List <Case> caList = [SELECT Id, Status, (SELECT Id,Approval_Status__c FROM Case_Approval_Tracker__c) FROM Case WHERE Id IN : case_ids];

 for(Case a : caList){
   integer count=0;
   for(Case_Approval_Tracker__c c : a.Case_Approval_Tracker__c ){
    if(c.Approval_Status__c == 'Approved'){
     a.Status = 'Approved';
    }
    else{
     a.Status = 'Rejected';  
   }  
   if(a.Case_Approval_Tracker__c.size()==count){
       a.Status = 'Rejected';
   }

  }
  update caList;
}
}


Error :  
(SELECT Id,Approval_Status__c FROM Case_Approval_Tracker__c) FROM Case
                                   ^
ERROR at Row:1:Column:55
Didn't understand relationship 'Case_Approval_Tracker__c' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.

Help me to fix error :)
Kalpesh Vyas 14Kalpesh Vyas 14
put SELECT Id,Approval_Status__c FROM Case_Approval_Tracker__r (use __r here)
or check name of relationship of Case lookup in Case_Approval_Tracker__c object
bhanu_prakashbhanu_prakash
thanks its resloved but
line 4 :   case_ids.add(c.caseid);        Error :  Variable does not exist: caseid 
line 11 :    for(Case_Approval_Tracker__c c : a.Case_Approval_Tracker__c ){                Error : Variable does not exist: Case_Approval_Tracker__c

please help me reslove Case_Approval_Tracker__c (is custom object is correct )
Kalpesh Vyas 14Kalpesh Vyas 14
The same use here as well
 for(Case_Approval_Tracker__c c : a.Case_Approval_Tracker__r ){ 
Kalpesh Vyas 14Kalpesh Vyas 14
case_ids.add(c.caseid);  //here also it should be custom field c.caseid__c like this