Spring '21 Package Updates

1. From Salesforce, click on the gear icon and select Developer Console.
2. From the Developer Console, open the Debug menu and select Open Execute Anonymous Window.
3. Execute the following code block:

   List<FieloPLT__Version__c> versionsToUpdate = [SELECT Id, FieloPLT__RelatedObjectType__c, FieloPLT__Challenge__c, FieloPLT__Promotion__c, FieloPLT__Rule__c, FieloPLT__Level__c, FieloPLT__Mission__c, FieloPLT__ChallengeReward__c FROM FieloPLT__Version__c WHERE FieloPLT__RelatedObjectType__c = null AND (FieloPLT__Challenge__c != null OR FieloPLT__Promotion__c != null OR FieloPLT__Rule__c != null OR FieloPLT__Level__c != null OR FieloPLT__Mission__c != null OR FieloPLT__ChallengeReward__c != null) LIMIT 200];
    
   if (versionsToUpdate.isEmpty())
       throw new FieloPLT.FieloException('NOTHING TO FIX');
    
   for (FieloPLT__Version__c version : versionsToUpdate){
       if(version.FieloPLT__Promotion__c != null){
           version.FieloPLT__RelatedObjectType__c = 'Promotion';
       }
       else if(version.FieloPLT__ChallengeReward__c != null){
           version.FieloPLT__RelatedObjectType__c = 'Challenge Reward';
       }
       else if(version.FieloPLT__Challenge__c != null){
           version.FieloPLT__RelatedObjectType__c = 'Challenge';
       }
       else if(version.FieloPLT__Mission__c != null){
           version.FieloPLT__RelatedObjectType__c = 'Mission';
       }
       else if(version.FieloPLT__Level__c != null){
           version.FieloPLT__RelatedObjectType__c = 'Level';
       }
       else if(version.FieloPLT__Rule__c != null){
           version.FieloPLT__RelatedObjectType__c = 'Rule';
       }
   }
    
   FieloPLT__Triggers__c triggerVersion = FieloPLT__Triggers__c.getInstance(UserInfo.getUserId());
   triggerVersion.FieloPLT__Version__c = false;
   upsert triggerVersion;
   update versionsToUpdate;
   delete triggerVersion;

   • Repeat this step until you receive an Execute Anonymous Error that says "NOTHING TO FIX".
4. Now, clear the previous code and execute this code block:

   List<AggregateResult> versionsDuplicate = [SELECT FieloPLT__Level__c, FieloPLT__Promotion__c, FieloPLT__Rule__c, FieloPLT__Challenge__c, FieloPLT__Mission__c, FieloPLT__ChallengeReward__c, FieloPLT__IsCurrentVersion__c, COUNT(Id) totalDuplicates
   FROM FieloPLT__Version__c
   WHERE FieloPLT__IsCurrentVersion__c = true AND (FieloPLT__Level__c != null OR FieloPLT__Promotion__c != null OR FieloPLT__Rule__c != null OR FieloPLT__Challenge__c != null OR FieloPLT__Mission__c != null OR FieloPLT__ChallengeReward__c != null)
   GROUP BY FieloPLT__Level__c, FieloPLT__Promotion__c, FieloPLT__Rule__c, FieloPLT__Challenge__c, FieloPLT__Mission__c, FieloPLT__ChallengeReward__c, FieloPLT__IsCurrentVersion__c
   HAVING COUNT(Id) > 1
   LIMIT 100];
    
   if (versionsDuplicate.isEmpty())
       throw new FieloPLT.FieloException('NOTHING TO FIX');
    
   Set<Id> promotionIds = new Set<Id>();
   Set<Id> ruleIds = new Set<Id>();
   Set<Id> challengeIds = new Set<Id>();
   Set<Id> missionIds = new Set<Id>();
   Set<Id> challengeRewardIds = new Set<Id>();
   Set<Id> levelIds = new Set<Id>();
   for (AggregateResult version : versionsDuplicate){
      
       if(version.get('FieloPLT__Promotion__c') != null){
           promotionIds.add((Id) version.get('FieloPLT__Promotion__c'));
       }
       else if(version.get('FieloPLT__Rule__c') != null){
           ruleIds.add((Id) version.get('FieloPLT__Rule__c'));
       }
       else if(version.get('FieloPLT__Challenge__c') != null){
           challengeIds.add((Id) version.get('FieloPLT__Challenge__c'));
       }
       else if(version.get('FieloPLT__Mission__c') != null){
           missionIds.add((Id) version.get('FieloPLT__Mission__c'));
       }
       else if(version.get('FieloPLT__ChallengeReward__c') != null){
           challengeRewardIds.add((Id) version.get('FieloPLT__ChallengeReward__c'));
       }
       else if(version.get('FieloPLT__Level__c') != null){
           levelIds.add((Id) version.get('FieloPLT__Level__c'));
       }
   }
    
   List<FieloPLT__Version__c> versionsToFix = [SELECT FieloPLT__Level__c, FieloPLT__Promotion__c, FieloPLT__Rule__c, FieloPLT__Challenge__c, FieloPLT__Mission__c, FieloPLT__ChallengeReward__c, FieloPLT__VersionNumber__c, FieloPLT__IsCurrentVersion__c
   FROM FieloPLT__Version__c
   WHERE FieloPLT__IsCurrentVersion__c = true AND (FieloPLT__Level__c IN :levelIds OR FieloPLT__Promotion__c IN :promotionIds OR FieloPLT__Rule__c IN :ruleIds OR FieloPLT__Challenge__c IN :challengeIds OR FieloPLT__Mission__c IN :missionIds OR FieloPLT__ChallengeReward__c IN :challengeRewardIds)
   ORDER BY FieloPLT__VersionNumber__c];
    
   // build the list in ascending order
   Map<Id,List<FieloPLT__Version__c>> versionsByParent = new Map<Id,List<FieloPLT__Version__c>>();
   for (FieloPLT__Version__c version : versionsToFix) {
      
       version.FieloPLT__IsCurrentVersion__c = false;
    
       Id parentId = version.FieloPLT__Level__c != null ? version.FieloPLT__Level__c : version.FieloPLT__Promotion__c != null ? version.FieloPLT__Promotion__c : version.FieloPLT__Rule__c != null ? version.FieloPLT__Rule__c : version.FieloPLT__Challenge__c != null ? version.FieloPLT__Challenge__c : version.FieloPLT__Mission__c != null ? version.FieloPLT__Mission__c : version.FieloPLT__ChallengeReward__c != null ? version.FieloPLT__ChallengeReward__c : null;
      
       if (versionsByParent.containsKey(parentId)) {
           versionsByParent.get(parentId).add(version);
       } else {
           versionsByParent.put(parentId, new List<FieloPLT__Version__c>{version});
       }
   }
    
   // remove the last element from the list and build the final list to update
   List<FieloPLT__Version__c> versionsToUpdate = new List<FieloPLT__Version__c>();
   for (Id parentId : versionsByParent.keySet()) {
       List<FieloPLT__Version__c> versions = versionsByParent.get(parentId);
       versions.remove(versions.size()-1);
       versionsToUpdate.addAll(versions);
   }
    
   FieloPLT__Triggers__c triggerVersion = FieloPLT__Triggers__c.getInstance(UserInfo.getUserId());
   triggerVersion.FieloPLT__Version__c = false;
   upsert triggerVersion;
   update versionsToUpdate;
   delete triggerVersion;

   • Repeat this step until you receive an Execute Anonymous Error that says "NOTHING TO FIX".
5. Finally, from Salesforce Setup, search for and select Platform Cache. Click on the partition called Settings in the FieloPLT namespace, then select Clear Cache.

First Spring '21 version.