Recently, I was writing some classes that needed to detect if the org they were in was a sandbox or not and determine which endpoint to call accordingly. Since there isn's an isSandbox method in Apex, I had to create my own. This will work in visualforce controllers/extensions and from standard classes. You can read the full details at http://www.ericsantiago.com/eric_santiago/2011/12/determining-salesforce-server-pod-and-if-sandbox-via-apex.html

Code as follows

public String currentPod { 
            String server;
            
            if (ApexPages.currentPage() != null){ //called from VF page
            		server = ApexPages.currentPage().getHeaders().get('X-Salesforce-Forwarded-To');
            } else { //called via standard class
            		server = URL.getSalesforceBaseUrl().getHost();
            }
            
            if ( server != null && server.length() > 0){
                server = server.substring(0 ,server.indexOf('.'));
                
            }
            return server ; 
   }

   public Boolean isSandbox {
            String pod = currentPod();
            if (pod != null && pod.length() > 0 && pod.toUpperCase().startsWith('C')){
                return true;
            }
            return false;
   }

Is there a way to render the merge fields in a string in Apex. As an example, I want to use email templates for a task. I've
written a VF page to override new task creation. It has a function that retrieves the body of the template but when its displayed
in the inputField it show the merge field syntax; i.e. Dear {!Contact.FirstName}.

public PageReference changeTemplate() {
EmailTemplate template = [Select TemplateType, Subject,
Name, Id, HtmlValue, Body, Description From EmailTemplate where id =:ApexPages.currentPage().getParameters().get('templateId')];

msg.Subject__c = template.Subject;
msg.Description__c = template.Body; //includes {!merge fields} as literal
}
return null ;
}

Is there a way to render the merge fields in a string in Apex. As an example, I want to use email templates for a task. I've
written a VF page to override new task creation. It has a function that retrieves the body of the template but when its displayed
in the inputField it show the merge field syntax; i.e. Dear {!Contact.FirstName}.

public PageReference changeTemplate() {
EmailTemplate template = [Select TemplateType, Subject,
Name, Id, HtmlValue, Body, Description From EmailTemplate where id =:ApexPages.currentPage().getParameters().get('templateId')];

msg.Subject__c = template.Subject;
msg.Description__c = template.Body; //includes {!merge fields} as literal
}
return null ;
}

trigger CallLineItemRename on Call_Line_Item__c (before insert, before update) { // this triger renames the call line item id to be // the specified inventory item name or the product name List<Call_Line_Item__c> callItems = new List<Call_Line_Item__c>(); callItems = Trigger.new; for (Call_Line_Item__c callItem : callItems) { //check if inventory or product was specified if (callItem.Inventory_Item__c <> NULL) { callItem.Name = callItem.Inventory_Item__r.Name; callItem.Name = 'inv item name'; } else if (callItem.Products__c <> NULL) { callItem.Name = callItem.Products__r.Name; } } update callItems; }

I've got an issue with a test class. I'm stuck at 56% coverage. My test method creates all the objects referenced in my controller and works fine. When I run the tests, it tells me the whole catch (QueryException ex) section of the methods is not covered. Here's a sample of what I have so far.

public static Employee__c getEmployee() {
     try {
      Employee__c employee=  [select id, kiosk__r.name, kiosk__c from Employee__c where user_name__c = :UserInfo.getUserId() Limit 1];
      return employee;
      } catch (QueryException ex) {
          ApexPages.Message myMsg = new ApexPages.Message(ApexPages.Severity.ERROR,'No employee record found for current user!');
          ApexPages.addMessage(myMsg);
          return null;
     }
    }

public static testMethod void testDashboardControllerMethods()
      {
      //create employee      
            Employee__c employee1=new Employee__c();
            employee1.Name='Test emp 1';
            employee1.Emp_ID__c='xtyooyuoowow';
            employee1.Kiosk__c=kiosk.Id;
            employee1.Quota_Status__c='Active';
            employee1.Sys_ID__c='127uijo90';
            employee1.User_Name__c=[Select Id from user where Isactive=true Limit 1].Id;
            employee1.Weekly_Hours__c=20;
            insert employee1;
            dashboardController.getEmployee();
       }

I tried creating a QueryException in the test method by adding a second test method that creates a employee record but not specifying user_name__c.

public static testMethod void testDashboardControllerMethods2() {
            //test the exception errors
            Employee__c employee1=new Employee__c();
            insert employee1;
            dashboardController.getEmployee();
      }

That doesn't seem to work. Any suggestions?

Recently, I was writing some classes that needed to detect if the org they were in was a sandbox or not and determine which endpoint to call accordingly. Since there isn's an isSandbox method in Apex, I had to create my own. This will work in visualforce controllers/extensions and from standard classes. You can read the full details at http://www.ericsantiago.com/eric_santiago/2011/12/determining-salesforce-server-pod-and-if-sandbox-via-apex.html

Code as follows

public String currentPod { 
            String server;
            
            if (ApexPages.currentPage() != null){ //called from VF page
            		server = ApexPages.currentPage().getHeaders().get('X-Salesforce-Forwarded-To');
            } else { //called via standard class
            		server = URL.getSalesforceBaseUrl().getHost();
            }
            
            if ( server != null && server.length() > 0){
                server = server.substring(0 ,server.indexOf('.'));
                
            }
            return server ; 
   }

   public Boolean isSandbox {
            String pod = currentPod();
            if (pod != null && pod.length() > 0 && pod.toUpperCase().startsWith('C')){
                return true;
            }
            return false;
   }

trigger CallLineItemRename on Call_Line_Item__c (before insert, before update) { // this triger renames the call line item id to be // the specified inventory item name or the product name List<Call_Line_Item__c> callItems = new List<Call_Line_Item__c>(); callItems = Trigger.new; for (Call_Line_Item__c callItem : callItems) { //check if inventory or product was specified if (callItem.Inventory_Item__c <> NULL) { callItem.Name = callItem.Inventory_Item__r.Name; callItem.Name = 'inv item name'; } else if (callItem.Products__c <> NULL) { callItem.Name = callItem.Products__r.Name; } } update callItems; }

Recently, I was writing some classes that needed to detect if the org they were in was a sandbox or not and determine which endpoint to call accordingly. Since there isn's an isSandbox method in Apex, I had to create my own. This will work in visualforce controllers/extensions and from standard classes. You can read the full details at http://www.ericsantiago.com/eric_santiago/2011/12/determining-salesforce-server-pod-and-if-sandbox-via-apex.html

Code as follows

public String currentPod { 
            String server;
            
            if (ApexPages.currentPage() != null){ //called from VF page
            		server = ApexPages.currentPage().getHeaders().get('X-Salesforce-Forwarded-To');
            } else { //called via standard class
            		server = URL.getSalesforceBaseUrl().getHost();
            }
            
            if ( server != null && server.length() > 0){
                server = server.substring(0 ,server.indexOf('.'));
                
            }
            return server ; 
   }

   public Boolean isSandbox {
            String pod = currentPod();
            if (pod != null && pod.length() > 0 && pod.toUpperCase().startsWith('C')){
                return true;
            }
            return false;
   }

Hi,

I have a button on a page, onclick of which i am creating tasks and attachments related to those tasks. This works fine when i launch the page from the salesforce org. However, when i use this page as a site page, i get the below error:

"Insufficient Privileges

Insert failed. First exception on row 0; first error: INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY, insufficient access rights on cross-reference id: []"

Below is my function:

      public void saveEmailAsActivity(String appId, Messaging.SingleEmailMessage email)
        {
            /* Start - Added on 12th September 2011*/
            User objUser = new User();
            String strUserName = 'test@sfdcsiteuser.com';
            objUser = [Select Id from User where username=:strUserName];
            /* End - Added on 12th September 2011*/
            
            //Create an activty related to Applicant.
            Task objTask = new Task();
            objTask.Status = 'Completed';
            objTask.whatId = appId;
            objTask.Subject = 'Email:' + email.subject;
            objTask.Description = 'Body:' + email.getHTMLBody();
            objTask.OwnerId = objUser.Id; //Added on 12th September 2011
            insert objTask;

            //Create Attachment(s) if present within the email related to the above activity.
            List<Attachment> lstAttach = new List<Attachment>();
            if(email.getFileAttachments() != null)
            {
                for(Messaging.EmailFileAttachment objEFA: email.getFileAttachments())
                {              
                    Attachment objAttach = new Attachment();
                    objAttach.ParentId = objTask.Id;
                    objAttach.Name = objEFA.getFileName();  
                    objAttach.Body = objEFA.getBody();
                    objAttach.ownerId = objUser.Id;
                    lstAttach.add(objAttach);
                }
                if(lstAttach.size() > 0)
                    insert lstAttach;
            }      
        }

Now if i comment out the "insert lstAttach" portion, the code works fine. However it gives an error only when i try to insert the attachment.  I cannot remove the "objAttach.ownerId = objUser.Id" line, because it gives me another error saying that the "Owner of the attachment must be the same as that of parent task" and if i keep that line i get the "Insufficient Cross Reference Entity" Error.

Can anybody help me with this?

Thanks,

Shailesh.

Is it possible to use a trigger to automate the creation of Campaign Member Status? For example, when a campaign of certain type is created, I would like to automatically add 'Show', 'No show' i nthe list of Campaign Member Status. Is it possible?

Thanks

Pierre 

Is there a way to render the merge fields in a string in Apex. As an example, I want to use email templates for a task. I've
written a VF page to override new task creation. It has a function that retrieves the body of the template but when its displayed
in the inputField it show the merge field syntax; i.e. Dear {!Contact.FirstName}.

public PageReference changeTemplate() {
EmailTemplate template = [Select TemplateType, Subject,
Name, Id, HtmlValue, Body, Description From EmailTemplate where id =:ApexPages.currentPage().getParameters().get('templateId')];

msg.Subject__c = template.Subject;
msg.Description__c = template.Body; //includes {!merge fields} as literal
}
return null ;
}

Below is some Apex code I found to copy an opportunity.  However, I have a custom field "Membership_Expires" on the opportunity tab.  I would like the new opportunity to add 365

try{

   {!REQUIRESCRIPT("/soap/ajax/14.0/connection.js")}

   // ** EDIT THIS QUERY TO LIST THE FIELDS YOU WANT TO COPY **

   var result = sforce.connection.query("Select o.Type, o.StageName,  o.Membership_Expires__C, o.CampaignId,  o.Amount, o.AccountId From Opportunity o WHERE o.Id = '{!Opportunity.Id}'");

   var newOpp = result.getArray("records");

   // Reset the Opp Id and reset fields to default values

   newOpp[0].Id = '';
   newOpp[0].Name = " {!Opportunity.Name}";
  

   // ** EDIT THESE FIELDS TO SET DEFAULT ANY VALUES **
   newOpp[0].StageName = "Pledge";
  newOpp[0].CloseDate = new Date(2099, 0, 1);
  

  newOpp[0].Membership_Expires__c  = {!Opportunity.Membership_Expires__c}

//This was my attempt to get the field to copy but that failed... once I got it to copy I was going to fiquer out how to add 365 days to the filed// 

   var saveResult = sforce.connection.create(newOpp);

   if (saveResult[0].getBoolean("success")) {
      newOpp[0].id = saveResult[0].id;
      alert("Opportunity cloned without line items");
   }
   else {
      alert("Failed to create clone: " + saveResult[0]);
   }

   // Refresh the page to display the new oppportunity
   window.location = newOpp[0].id;
}
catch (err) {
   alert (err.description );
} days to this custom field.  

trigger CallLineItemRename on Call_Line_Item__c (before insert, before update) { // this triger renames the call line item id to be // the specified inventory item name or the product name List<Call_Line_Item__c> callItems = new List<Call_Line_Item__c>(); callItems = Trigger.new; for (Call_Line_Item__c callItem : callItems) { //check if inventory or product was specified if (callItem.Inventory_Item__c <> NULL) { callItem.Name = callItem.Inventory_Item__r.Name; callItem.Name = 'inv item name'; } else if (callItem.Products__c <> NULL) { callItem.Name = callItem.Products__r.Name; } } update callItems; }

Looking at writing a simple Apex trigger to update a lead or contact field based on a task being added.

Have written an after insert Task trigger.  Quick question...

What is the best way to determine if the WhatID references a lead or contact?  Can the ID field be treated as a string and what are the ID prefixes for the Lead and Contact table?

Thanks!