Hello,

We use a tabbedaccount visualforce page and I would like to add Desk.com as a tab. Below is my code and specifically the BOLD area where I attempted to add Desk.com: 

<apex:page standardController="Account" showHeader="true" tabStyle="account" >
   <style>
      .activeTab {background-color: #236FBD; color:white;
         background-image:none}
      .inactiveTab { background-color: lightgrey; color:black;
         background-image:none}
   </style>
   <apex:tabPanel switchType="client" selectedTab="tabdetails" id="AccountTabPanel" tabClass="activeTab" inactiveTabClass="inactiveTab">  
      <apex:tab label="Details" name="AccDetails" id="tabdetails">
         <apex:detail relatedList="false" title="true"/>
      </apex:tab>
      <apex:tab label="Contacts" name="Contacts" id="tabContact">
         <apex:relatedList subject="{!account}" list="contacts" />
      </apex:tab>
      <apex:tab label="Opportunities" name="Opportunities" id="tabOpp">
         <apex:relatedList subject="{!account}" list="opportunities" />
      </apex:tab>
      <apex:tab label="Open Activities" name="OpenActivities" id="tabOpenAct">
         <apex:relatedList subject="{!account}" list="OpenActivities" />
      </apex:tab>
      <apex:tab label="Notes and Attachments" name="NotesAndAttachments" id="tabNoteAtt">
         <apex:relatedList subject="{!account}" list="NotesAndAttachments" />
      </apex:tab>
       <apex:tab label="Activity History" name="Activity History" id="tabActivityHistory">
         <apex:relatedList subject="{!account}" list="ActivityHistories" />
       </apex:tab>
       <apex:tab label="Projects" name="Projects" id="tabProjects">
         <apex:relatedList subject="{!account}" list="Projects__r" />
       </apex:tab>     
       <apex:tab label="Contracts" name="Contracts" id="tabContracts">
         <apex:relatedList subject="{!account}" list="contracts" />
       </apex:tab> 
       <apex:tab label="Desk.com" name="Desk" id="tabDeskcom">
         <apex:relatedList subject="{!account}" list="Deskcom__Case__r" />
       </apex:tab>
   </apex:tabPanel>
</apex:page>


I am recieving an error:

'Deskcom__Case__r' is not a valid child relationship name for entity Account.

Any insight, help, suggestions would be greatly appreciated.

Thanks!
Doug

I downloaded the Salesforce labs case assignment unmanaged package and hacked the trigger to round robin assign leads, which works great.

I tried to update the test code, but every time I run the test I get a MIXED_DML_OPERATION error on 4 different lines of code.  I've researched the error and found some advice, but I haven't been able to implement the fixes that people suggested.  Can any help me fix these errors?

Here is the test class:
 
@isTest
public class TestLeadAssignment{

    static testMethod void myTest1() {

        // This code runs as the system user

        User u1;

        try{
          u1 = [select Id from User WHERE IsActive=True AND Profile.Name = 'System Administrator'  LIMIT 1];
        } catch (QueryException qe){

        List<User> users = [SELECT Id, Profile.PermissionsModifyAllData FROM User WHERE IsActive = true LIMIT 1000];

        for(User u : users){
            if(u.Profile.PermissionsModifyAllData = true){
              u1 = u;
              break;
        }
        }

        }

        System.debug(u1);

       //*****Create Queue
      
       Group testGroup = new Group ();
       testGroup.Name = 'TestQueue';
       testGroup.Type = 'Queue';
       insert testGroup;
      
       QueueSObject testQueue = new QueueSObject();
       testQueue.QueueId = testGroup.id;
       testQueue.SObjectType = 'Lead';
       insert testQueue;

       // Second Queue      
       Group testGroup2 = new Group ();
       testGroup2.Name = 'TestQueue2';
       testGroup2.Type = 'Queue';
       insert testGroup2;
      
       QueueSObject testQueue2 = new QueueSObject();
       testQueue2.QueueId = testGroup2.id;
       testQueue2.SObjectType = 'Lead';
       insert testQueue2;


       test.starttest();
       
        //Run test

        //Assign Lead with out any Assignment Groups
        Lead ld = new Lead (FirstName='Tim',LastName='Jones', Company='ABC Corp', tempOwnerID__c=testGroup2.id, OwnerID=u1.id); //tempOwnerID__c=testGroup2.id, 
        insert ld;
        update ld;
       
       
        //Create Assignment Group
        Assignment_Group_Name__c ag1 = new Assignment_Group_Name__c (Name='TestAG', Type__c = 'Lead');
        insert ag1;

        
        //Add bad queue name
        Assignment_Group_Queues__c agqBad = new Assignment_Group_Queues__c(name='Bad Queue',Assignment_Group_Name__c = ag1.id );

        try {
            insert agqBad;
        } catch (DmlException e){
             System.assert(e.getMessage().contains('CUSTOM_VALIDATION_EXCEPTION'), e.getMessage());
       
        } //catch

        test.stoptest();
       
    }
   
    static testMethod void myTest2() {

        // This code runs as the system user

        User u1;

        try{
          u1 = [select Id from User WHERE IsActive=True AND Profile.Name = 'System Administrator'  LIMIT 1];
        } catch (QueryException qe){

        List<User> users = [SELECT Id, Profile.PermissionsModifyAllData FROM User WHERE IsActive = true LIMIT 1000];

        for(User u : users){
            if(u.Profile.PermissionsModifyAllData = true){
              u1 = u;
              break;
        }
        }

        }

        System.debug(u1);

       //*****Create Queue
      
       Group testGroup = new Group ();
       testGroup.Name = 'TestQueue';
       testGroup.Type = 'Queue';
       insert testGroup;
      
       QueueSObject testQueue = new QueueSObject();
       testQueue.QueueId = testGroup.id;
       testQueue.SObjectType = 'Lead';
       insert testQueue;

       // Second Queue      
       Group testGroup2 = new Group ();
       testGroup2.Name = 'TestQueue2';
       testGroup2.Type = 'Queue';
       insert testGroup2;
      
       QueueSObject testQueue2 = new QueueSObject();
       testQueue2.QueueId = testGroup2.id;
       testQueue2.SObjectType = 'Lead';
       insert testQueue2;


       test.starttest();
       
        //Run test
      
       
        //Create Assignment Group
        Assignment_Group_Name__c ag1 = new Assignment_Group_Name__c (Name='TestAG', Type__c = 'Lead');
        insert ag1;       

        //Add Good Queue to Assignment Group
        Assignment_Group_Queues__c agq1 = new Assignment_Group_Queues__c(name=testGroup.Name ,Assignment_Group_Name__c = ag1.id );
        insert agq1;
       
       
        //Add User to Assignment Groups Users
        Assignment_Groups__c agu1 = new Assignment_Groups__c (User__c = u1.id, Active__c='True', Group_Name__c = ag1.id, Last_Assignment__c = datetime.valueOf('2009-01-01 21:13:24') );
        insert agu1;

        Lead l2 = new Lead (FirstName='Tom',LastName='Dunn', Company='JKL Corp', tempOwnerID__c=testGroup2.id , OwnerID=testGroup.id); //Set owner ID to Queue
        insert l2;
        update l2;       

        test.stoptest();
       
    }

    static testMethod void myTest3() {

        // This code runs as the system user

        User u1;

        try{
          u1 = [select Id from User WHERE IsActive=True AND Profile.Name = 'System Administrator'  LIMIT 1];
        } catch (QueryException qe){

        List<User> users = [SELECT Id, Profile.PermissionsModifyAllData FROM User WHERE IsActive = true LIMIT 1000];

        for(User u : users){
            if(u.Profile.PermissionsModifyAllData = true){
              u1 = u;
              break;
        }
        }

        }

        System.debug(u1);

       //*****Create Queue
      
       Group testGroup = new Group ();
       testGroup.Name = 'TestQueue';
       testGroup.Type = 'Queue';
       insert testGroup;
      
       QueueSObject testQueue = new QueueSObject();
       testQueue.QueueId = testGroup.id;
       testQueue.SObjectType = 'Lead';
       insert testQueue;

       test.starttest();
       
        //Run test       
       
        //Create Assignment Group
        Assignment_Group_Name__c ag1 = new Assignment_Group_Name__c (Name='TestAG', Type__c = 'Lead');
        insert ag1;       

        //Add Good Queue to Assignment Group
        Assignment_Group_Queues__c agq1 = new Assignment_Group_Queues__c(name=testGroup.Name ,Assignment_Group_Name__c = ag1.id );
        insert agq1;
       
       
        //Add User to Assignment Groups Users
        Assignment_Groups__c agu1 = new Assignment_Groups__c (User__c = u1.id, Active__c='True', Group_Name__c = ag1.id, Last_Assignment__c = datetime.valueOf('2009-01-01 21:13:24') );
        insert agu1;     

        Lead l3 = new Lead (FirstName='Dave',LastName='Barry', Company='CBS Corp', OwnerID=testGroup.id); //Set owner ID to Queue
        insert l3;
        update l3;

        test.stoptest();
       
    }

    static testMethod void myTest4() {

        // This code runs as the system user

        User u1;

        try{
          u1 = [select Id from User WHERE IsActive=True AND Profile.Name = 'System Administrator'  LIMIT 1];
        } catch (QueryException qe){

        List<User> users = [SELECT Id, Profile.PermissionsModifyAllData FROM User WHERE IsActive = true LIMIT 1000];

        for(User u : users){
            if(u.Profile.PermissionsModifyAllData = true){
              u1 = u;
              break;
        }
        }

        }

        System.debug(u1);

       //*****Create Queue
      
       Group testGroup = new Group ();
       testGroup.Name = 'TestQueue';
       testGroup.Type = 'Queue';
       insert testGroup;
      
       QueueSObject testQueue = new QueueSObject();
       testQueue.QueueId = testGroup.id;
       testQueue.SObjectType = 'Lead';
       insert testQueue;
     

       test.starttest();
       
        //Run test

        //Create Assignment Group
        Assignment_Group_Name__c ag1 = new Assignment_Group_Name__c (Name='TestAG', Type__c = 'Lead');
        insert ag1;       

        //Add Good Queue to Assignment Group
        Assignment_Group_Queues__c agq1 = new Assignment_Group_Queues__c(name=testGroup.Name ,Assignment_Group_Name__c = ag1.id );
        insert agq1;
       
          //Test for AG-Queues already assigned to another Assignment Group
        Assignment_Group_Queues__c agq2 = new Assignment_Group_Queues__c(name=testGroup.Name,Assignment_Group_Name__c = ag1.id );
        try {
            insert agq2;
        } catch (DmlException e){
             System.assert(e.getMessage().contains('CUSTOM_VALIDATION_EXCEPTION'), e.getMessage());
        } //catch

        test.stoptest();
    
 
  }
}

Hello,

We use a tabbedaccount visualforce page and I would like to add Desk.com as a tab. Below is my code and specifically the BOLD area where I attempted to add Desk.com: 

<apex:page standardController="Account" showHeader="true" tabStyle="account" >
   <style>
      .activeTab {background-color: #236FBD; color:white;
         background-image:none}
      .inactiveTab { background-color: lightgrey; color:black;
         background-image:none}
   </style>
   <apex:tabPanel switchType="client" selectedTab="tabdetails" id="AccountTabPanel" tabClass="activeTab" inactiveTabClass="inactiveTab">  
      <apex:tab label="Details" name="AccDetails" id="tabdetails">
         <apex:detail relatedList="false" title="true"/>
      </apex:tab>
      <apex:tab label="Contacts" name="Contacts" id="tabContact">
         <apex:relatedList subject="{!account}" list="contacts" />
      </apex:tab>
      <apex:tab label="Opportunities" name="Opportunities" id="tabOpp">
         <apex:relatedList subject="{!account}" list="opportunities" />
      </apex:tab>
      <apex:tab label="Open Activities" name="OpenActivities" id="tabOpenAct">
         <apex:relatedList subject="{!account}" list="OpenActivities" />
      </apex:tab>
      <apex:tab label="Notes and Attachments" name="NotesAndAttachments" id="tabNoteAtt">
         <apex:relatedList subject="{!account}" list="NotesAndAttachments" />
      </apex:tab>
       <apex:tab label="Activity History" name="Activity History" id="tabActivityHistory">
         <apex:relatedList subject="{!account}" list="ActivityHistories" />
       </apex:tab>
       <apex:tab label="Projects" name="Projects" id="tabProjects">
         <apex:relatedList subject="{!account}" list="Projects__r" />
       </apex:tab>     
       <apex:tab label="Contracts" name="Contracts" id="tabContracts">
         <apex:relatedList subject="{!account}" list="contracts" />
       </apex:tab> 
       <apex:tab label="Desk.com" name="Desk" id="tabDeskcom">
         <apex:relatedList subject="{!account}" list="Deskcom__Case__r" />
       </apex:tab>
   </apex:tabPanel>
</apex:page>


I am recieving an error:

'Deskcom__Case__r' is not a valid child relationship name for entity Account.

Any insight, help, suggestions would be greatly appreciated.

Thanks!
Doug

I'm getting an error message periodically: attempt to de-reference a null object on line 79 column 13.  Can someone tell me what's wrong?

 

• trigger leadRoundRobin on Lead (before insert, before update) {
      //
      //Check if assignment owner has changed
      //
      Map<Integer,Id> queueIds = new Map<Integer,Id>();   //Trigger index --> Queue ID
      
      Integer idx = 0;
      for (Lead cs : Trigger.new)
      {
          if(Trigger.isUpdate) {  
              if(cs.OwnerId <> Trigger.oldMap.get(cs.id).OwnerId) {
                  if (cs.TempOwnerId__c == 'SKIP') {
                      Trigger.new[idx].TempOwnerId__c = '';
                  } else {
                      queueIds.put(idx, cs.OwnerId);
                  }
              }           
          }else {
              queueIds.put(idx, cs.OwnerId);
          }   
          idx++;
      }
      System.debug('>>>>>queueIds: '+queueIds);
      if (queueIds.isEmpty()) return;
      
      //
      //Find active Assignment Group for Queue
      //
      Map<Integer,Id> asgnGroupNameIds = new Map<Integer,Id>();   //Trigger index --> Assignment_Group_Name ID
      Map<Id,Assignment_Group_Queues__c> asgnGroupQueues = new Map<Id,Assignment_Group_Queues__c>(); //Queue ID --> Assignment Group Queues
      
      for(Assignment_Group_Queues__c[] agq : [SELECT Assignment_Group_Name__c, QueueId__c
                                            FROM Assignment_Group_Queues__c 
                                            WHERE QueueId__c in :queueIds.values()
                                            AND Active__c = 'True'])
      {
          for (Integer i = 0; i < agq.size() ; i++) {
              asgnGroupQueues.put(agq[i].QueueId__c, agq[i]);
          }                                           
      }
      System.debug('>>>>>asgnGroupQueues: '+asgnGroupQueues); 
      if (asgnGroupQueues.isEmpty()) return;
  
      for (Integer i : queueIds.keySet()) {
          Assignment_Group_Queues__c agq = asgnGroupQueues.get(queueIds.get(i));
          
          if (agq <> null) {
              asgnGroupNameIds.put(i, agq.Assignment_Group_Name__c);
          }
          //else no active assignment group queue error
      }
      System.debug('>>>>>asgnGroupNameIds: '+asgnGroupNameIds);
      if (asgnGroupNameIds.isEmpty()) return;
      
      //
      //Determine next valid user in Queue/Assignment Group for round robin
      //User with earliest last assignment date wins.
      //
      Map<Id,Assignment_Groups__c[]> asgnGroups = new Map<Id,Assignment_Groups__c[]>(); // Assignment Group Name ID --> User ID
      for(Assignment_Groups__c[] ags : [SELECT Group_Name__c, User__c, Last_Assignment__c, Millisecond__c 
                                     FROM Assignment_Groups__c 
                                     WHERE Group_Name__c in :asgnGroupNameIds.values() 
                                     AND Active__c = 'True' AND User_Active__c = 'True'
                                     ORDER BY Last_Assignment__c, Millisecond__c])
      {
          if (ags.size()>0) {
              asgnGroups.put(ags[0].Group_Name__c, ags);
          }
      }
      System.debug('>>>>>asgnGroups: '+asgnGroups);   
      if (asgnGroups.isEmpty()) return;
  
      Map<Id,Assignment_Groups__c> updateAssignmentGroups = new Map<Id,Assignment_Groups__c>();
      Map<Id, datetime> latestAGDateTime = new Map<Id,datetime>();
      idx = 0;    
      for (Integer i : queueIds.keySet())
      {
          Assignment_Groups__c[] ags = asgnGroups.get(asgnGroupNameIds.get(i));
   if (ags.size()>0)
          {   
              //Choose next user in line if user ID has already been used but not committed in this trigger batch 
              Assignment_Groups__c ag = ags[math.mod(idx, ags.size())];
                  
              //Assign User to Lead as the new owner
              System.debug('>>>>>Owner changed for Lead ' + Trigger.new[i].Id + ' from '+Trigger.new[i].OwnerId+' to '+ ag.User__c);
              Trigger.new[i].OwnerId = ag.User__c;    
              Trigger.new[i].TempOwnerId__c = ag.User__c; 
  
              //Set last assignment datetime
              datetime now = datetime.now();
              ag.Last_Assignment__c = now;
              ag.Millisecond__c = now.millisecondGMT();
              
              //update only latest Assignment Groups per ID
              if (latestAGDateTime.containsKey(ag.id)) {
                  if(latestAGDateTime.get(ag.id) < now) {
                      updateAssignmentGroups.put(ag.id, ag);
                      latestAGDateTime.put(ag.id, now);
                  }
              } else {
                  updateAssignmentGroups.put(ag.id, ag);
                  latestAGDateTime.put(ag.id,now);
              }
              
              idx++;
          }
      }
      //Map --> List/Array for DML update
      List<Assignment_Groups__c> updateAG = new List<Assignment_Groups__c>();
      for (Id agId : updateAssignmentGroups.keySet()) {
          updateAG.add(updateAssignmentGroups.get(agId));
      }
  
      System.debug('>>>>>Update Assignment Groups: '+updateAG);   
      
      //
      //Update last assignment for Assignment Group in batch
      //
      if (updateAG.size()>0) {
          try {
              update updateAG;
          } catch (Exception e){
              for (Integer i : queueIds.keySet())
              {
                  Trigger.new[i].addError('ERROR: Could not update Assignment Group records ' + ' DETAIL: '+e.getMessage());  
              }
          }
      }
  }