• JOHNATHAN WHITT 1
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
Hello All,
Been banging against this for a while.
Started in standard dev environment and was above 80%.
Now that i moved it to a full sandbox it is at 72%.

Any ideas on why or how to increase.

Thanks

TRIGGER CODE

trigger OTOpportunityTrigger on Opportunity (after insert)
{
//Begin Loop of OTM Lookup   
for(Opportunity oppty : trigger.New)
{
    List<OpportunityTeamMember> listOpptyTeamMem = new List<OpportunityTeamMember>();
     Account[] accts = [SELECT Id, Enterprise_Zip_Postal_Code__c FROM Account WHERE Id =: oppty.AccountId LIMIT 1]; 
     List<CTRAS__c> CTRAScic = new List<CTRAS__c>();
     List<CTRAS__c> CTRAScice = new List<CTRAS__c>();
     List<CTRAS__c> CTRASssc = new List<CTRAS__c>();
     List<CTRAS__c> CTRASssce = new List<CTRAS__c>();
     List<CTRAS__c> CTRASisc = new List<CTRAS__c>();
     List<CTRAS__c> CTRASisce = new List<CTRAS__c>();
     Set<Id> OpptyIdSet =  new Set<Id>();
     string a;
     string b;
if (accts.size() > 0) {
a = accts[0].Id;
b = accts[0].Enterprise_Zip_Postal_Code__c;
CTRAScice = [Select Aligned_Member__c from CTRAS__c where UID__c=:'CIC-'+ b.substring(0,5) + '-' + a.substring(0,15) limit 1];        
CTRASssce = [Select Aligned_Member__c from CTRAS__c where UID__c=:'SSC-'+ b.substring(0,5) + '-' + a.substring(0,15) limit 1];        
CTRAScic = [Select Aligned_Member__c from CTRAS__c where UID__c=:'CIC-'+ b.substring(0,5) + '-' limit 1];        
CTRASssc = [Select Aligned_Member__c from CTRAS__c where UID__c=:'SSC-'+ b.substring(0,5) + '-' limit 1];        
}
//Find Values used for assignment 
OpportunityTeamMember OTMC = new OpportunityTeamMember();
OpportunityTeamMember OTMS = new OpportunityTeamMember();
OpportunityTeamMember OTMI = new OpportunityTeamMember();
//Confirm Opp exists.      
if(oppty.Id != null)    
{
if(accts != null) // check if list is not empty
{
//Check for exceptions
CTRASisce = [Select Aligned_Member__c from CTRAS__c where UID__c=:'ISC-'+ UserInfo.getUserId().substring(0,15) + '-' + a limit 1];        
//Perform standard lookups
CTRASisc = [Select Aligned_Member__c from CTRAS__c where UID__c=:'ISC-'+ UserInfo.getUserId().substring(0,15) + '-' limit 1];        
}
 
//ADD CIC TO OT
if (CTRAScice.size() > 0)
{
            OTMC.OpportunityId = oppty.Id;
            OTMC.TeamMemberRole = 'CT CIC';
            OTMC.UserId = CTRAScice[0].Aligned_Member__c;
            listOpptyTeamMem.add(OTMC);
} else if (CTRAScic.size() > 0) {
            OTMC.OpportunityId = oppty.Id;
            OTMC.TeamMemberRole = 'CT CIC';
            OTMC.UserId = CTRAScic[0].Aligned_Member__c;
            listOpptyTeamMem.add(OTMC);
}
//ADD SSC TO OT
if (CTRASssce.size() > 0)
{
           OTMS.OpportunityId = oppty.Id;
           OTMS.TeamMemberRole = 'CT SSC';
           OTMS.UserId = CTRASssce[0].Aligned_Member__c;
           listOpptyTeamMem.add(OTMS);
} else if (CTRASssc.size() > 0) {
           OTMS.OpportunityId = oppty.Id;
           OTMS.TeamMemberRole = 'CT SSC';
           OTMS.UserId = CTRASssc[0].Aligned_Member__c;
           listOpptyTeamMem.add(OTMS);
}
//ADD ISC TO OT
if (CTRASisce.size() > 0)
{
            OTMI.OpportunityId = oppty.Id;
            OTMI.TeamMemberRole = 'CT ISC';
            OTMI.UserId = CTRASisce[0].Aligned_Member__c;
            listOpptyTeamMem.add(OTMI);
} else if (CTRASisc.size() > 0){
            OTMI.OpportunityId = oppty.Id;
            OTMI.TeamMemberRole = 'CT ISC';
            OTMI.UserId = CTRASisc[0].Aligned_Member__c;
            listOpptyTeamMem.add(OTMI);
}
insert listOpptyTeamMem;
}
}
}


TEST CLASS CODE

@isTest(SeeAllData=True)
public with sharing class TestOTOpportunityTrigger {

    public static testmethod void test_1() {
     string a;
        Opportunity o  = new Opportunity();
        o.OwnerID = UserInfo.getUserId();
        o.StageName = 'Opportunity Identified';
        o.CloseDate = Date.newInstance(2017,11,30);
        o.AccountId = '001E000001KJsA1';
        o.Name = 'TestOpportunityTriggers3';
        o.Shipper_Payor__c = 'Shipper';
        o.Ramp_Date__c = Date.newInstance(2017,11,30);
        o.RecordTypeId = '012E0000000DC1E';
        insert o;
       
        OpportunityTeamMember OTMC = new OpportunityTeamMember();
        OpportunityTeamMember OTMS = new OpportunityTeamMember();
        OpportunityTeamMember OTMI = new OpportunityTeamMember();

        OTMC.OpportunityId = o.Id;
        OTMC.TeamMemberRole = 'CT CIC';
        OTMC.UserId = '00544000008Hw08';
        insert OTMC;
       
        OTMS.OpportunityId = o.Id;
        OTMS.TeamMemberRole = 'CT SSC';
        OTMS.UserId = '00544000008Hw08';  
        insert OTMS;
           
        OTMI.OpportunityId = o.Id;
        OTMI.TeamMemberRole = 'CT ISC';
        OTMI.UserId = '00544000008HgiI';  
        insert OTMI;

        }
    }

Code Block missing 1Code block missing 2