Apex Video Tutorial: SOQL & Core Apex

Preface: This video is part 2 of the Official #Apex4Admins series presented by Salesforce and I!

Learn fundamental Apex tools and SOQL!

1. How to write a SOQL query!
2. Core Apex: variables, IF statements, loops!
3. Write a new Salesforce trigger!

View slides

Basic SOQL

[SELECT Id, Name, Website, Sells_Chocolate__c FROM Account];

Cross-object

[SELECT Account.Owner.Manager.Needs_Chocolate__c FROM Contact];

WHERE

[SELECT Id, Name FROM Contact WHERE Eats_Chocolate__c = true];

Operators

[SELECT Id, Title FROM Lead WHERE Favorite_Chocolate__c != null];

AND

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c   = true
    AND Allergic_to_Nuts__c = false
    AND Chocolate_Rehab__c  = false];

Mixing ANDs & ORs

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c  = true
    AND (Milk_Chocolate__c = true OR Dark_Chocolate__c = true)];

Text, Picklist, IDs

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c     = true
    AND Favorite_Chocolate__c = 'Snickers'
    AND OwnerId = '005i0000000OAOO'];

Numbers

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c          = true
    AND Chocolate_Bars_Consumed__c > 10
     OR Broccoli_Consumed__c       <= 1];

Dates

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c  = true    
    AND Diet_Start_Date__c = null
     OR Diet_Start_Date__c > TODAY];

Fuzzy Matching

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c   = true
    AND Preferred_Fillings__c LIKE '%Caramel%'];

Sorting

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c = true    
    AND Last_Chocolate_Consumption__c < 2014-01-01
  ORDER BY LastName ASC];

Limiting Results

[SELECT Id, Name, Email, Birthdate, Account.Name FROM Contact 
  WHERE Eats_Chocolate__c = true    
    AND Last_Chocolate_Consumption__c = YESTERDAY
  LIMIT 10];

Apex FUNdamentals

Variables

// Text
String favoriteMovie = 'Frozen';

// Numbers
Integer timesWatched     = 8;
Decimal merchandiseSpend = 55.20;

// True or False
Boolean ownsTheSoundtrack = true;

// Dates
Date dateLastWatched  = Date.newInstance(2014, 5, 20);
DateTime nextShowtime = DateTime.now().addHours(7);

// SObjects
Movie__c frozen = [SELECT Id FROM Movie__c WHERE Name = 'Frozen'];

IF Statements and Comparison Operators

// How to compare values
Greater than:  >      Less than:     <
Equals:        ==     Not Equals:    !=
AND:           &&     OR:            ||

// IF Statements
if (david.Twtr_Follows__c < leeAnne.Twtr_Follows__c) {
    david.Emotions__c = 'Crushed.';
} else if (david.Twtr_Follows__c == leeAnne.Twtr_Follows__c) {
    david.Emotions__c = 'Showdown! Last man standing!';
} else if (david.Twtr_Follows__c < 1200 || david.Tweets__c < 500){
    david.Emotions__c = 'A petty victory.';
} else {
    david.Emotions__c = 'Life is good.';
}

Loops

// FOR EACH Loop: Eat every Reeses in our trigger!
for (Chocolate__c choco : Trigger.new) {
    if (choco.Name == 'Reeses') {    
        choco.Status__c = 'In my belly!';
        update choco;
    }
}

// FOR Loop: Eat 100 Reeses!
for (Integer i = 0; i < 100; i++) {
    Chocolate__c choco = new Chocolate__c();
    choco.Name      = 'Reeses';
    choco.Status__c = 'In my belly!';
    insert choco;
}

// Eat 10 Reeses every time you watch Frozen!
trigger Snacks on Movie__c (after insert) {
    // Loop through all records in the trigger
    for (Movie__c movie : Trigger.new) {
        if (movie.Name == 'Frozen') {
            // Loop a specific number of times
            for (Integer i = 0; i < 10; i++) {
                Chocolate__c choco = new Chocolate__c();
                choco.Name         = 'Reeses';
                choco.Status__c    = 'In my belly!';
                insert choco;
            }
        }
    }
}

Final “Non-Profit” Trigger:

trigger AutoCreateOpp on Account (after insert) {
    // Every trigger has this loop!
    for (Account a : Trigger.new) {
        // Check if it's a 'Prospect' Account
        if (a.Type == 'Prospect') {
            // Create a new Opp (but don't save yet)
            Opportunity o = new Opportunity();
            o.Name = 'Big Deal';
            o.StageName = 'Prospecting';
            o.CloseDate = Date.today().addDays(30);
            o.AccountId = a.Id;
            
            // Set the Opp amount based on the Industry
            if (a.Industry == 'Technology') {
                o.Amount = 5000000;
            } else if (a.Industry == 'Non-Profit') {
                o.Amount = 1000;
            } else {
                o.Amount = 5000;
            }
            
            // Double the Opp amount if there are many employees!
            Integer bigCompanyMultiplier = 2;
            if (a.NumberOfEmployees > 1000) {
                o.Amount = o.Amount * bigCompanyMultiplier;
            }
            
            // Don't forget to save!
            insert o;
        }
    }
}

Continue to Part 3: Combine SOQL & Apex!