I have the following trigger for the Account object:
trigger LatestCaseBatchTrigger on Account (after update, before update) {
public list<Issues__c> listCases = new List<Issues__c>();
Set<Id> AccountId = trigger.newMap.keySet();
public List<Account> account = [Select Id from Account where id IN :AccountId];
List<Issues__c> casesUK = [SELECT Id, Name, RecordTypeId, CreatedDate FROM Issues__c WHERE Account__c = :AccountId AND Status__c IN ('KYC Review Complete', 'KYC Finalized', 'On-boarding Finalized') AND Client_Setup_with__c = 'BCS UK' AND RecordTypeId IN ('012b0000000kHRa', '012b0000000ULxm', '012b0000000kH4g', '012b0000000US2R') ORDER BY CreatedDate DESC NULLS LAST limit 1];
Set<Issues__c> setCaseToUpdate = new Set<Issues__c>();
listCases = new List<Issues__c>();
for(Account acc : account){
for(Issues__c iss : casesUK){
iss.Latest__c = true;
setCaseToUpdate.add(iss);
}
}
listCases.addAll(setCaseToUpdate);
update listCases;
}
It works fine when I update an account record manually. But when I try to make updates for all account records (through DataLoader) it doesn't run for all the accounts that I update. Please point out where I made a mistake.