Given a list of Opportunity records named opportunityList, which code snippet is best for querying all Contacts of the Opportunity’s Account?

March 23, 2021March 23, 2021 konaguru Leave a comment

code Snippet #1 is the correct answer as you won’t end up pulling duplicate contacts into the contact list

Code Snippet #1:

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];

List<Contact> contactList = new List<Contact>(); 
Set<Id> accountIds = new Set<Id>();
 
for(Opportunity o : opportunityList) { accountIds.add(o.AccountId);
}

for(Account a : [SELECT Id, (SELECT Id FROM Contacts) FROM Account WHERE Id IN :accountIds])
{
contactList.addAll(a.Contacts);
}
System.debug(' ContactList Size ' + contactList.size());

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];

List<Contact> contactList = new List<Contact>();

Set<Id> accountIds = new Set<Id>();

for(Opportunity o : opportunityList) { accountIds.add(o.AccountId);

}

for(Account a : [SELECT Id, (SELECT Id FROM Contacts) FROM Account WHERE Id IN :accountIds])

{

contactList.addAll(a.Contacts);

}

System.debug(' ContactList Size ' + contactList.size());

Code Snippet #2 : Issue: Coding Error : List defined incorrectly

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];

List<Contact> contactList = new List()<Contact>; 
Set<Id> accountIds = new Set<Id>(); 
for(Opportunity o : opportunityList) {
   contactIds.add(o.ContactId);
}
 for(Contact c : [SELECT Id FROM Contact WHERE Id IN :contactIds]){ 
    contactList.add(c);
}

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];

List<Contact> contactList = new List()<Contact>;

Set<Id> accountIds = new Set<Id>();

for(Opportunity o : opportunityList) {

contactIds.add(o.ContactId);

}

for(Contact c : [SELECT Id FROM Contact WHERE Id IN :contactIds]){

contactList.add(c);

}

Code Snippet #3 :

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];
System.debug(' Opportunity List ' + OpportunityList);
List<Contact> contactList = new List<Contact>(); 
for(Opportunity o : opportunityList) {
    System.debug(' Opportunity Account Id ' + o.accountId );
    if(o.accountId != null ) {
 Account a = [SELECT Id, (SELECT Id FROM Contacts) FROM Account WHERE Id = :o.AccountId];
   contactList.addAll(a.Contacts);
    }
}
System.debug(' Size of Contact List ' + contactList.size());

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];

System.debug(' Opportunity List ' + OpportunityList);

List<Contact> contactList = new List<Contact>();

for(Opportunity o : opportunityList) {

System.debug(' Opportunity Account Id ' + o.accountId );

if(o.accountId != null ) {

Account a = [SELECT Id, (SELECT Id FROM Contacts) FROM Account WHERE Id = :o.AccountId];

contactList.addAll(a.Contacts);

}

System.debug(' Size of Contact List ' + contactList.size());

Code Snippet #4 : Issue: Coding error : you can’t read a list directly from OpportunityList

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];

List<Contact> contactList = new List<Contact>();
for(Contact c : [SELECT Id FROM Contact WHERE AccountId IN :opportunityList.accountId]){ contactList.add(c);
}

List<Opportunity> OpportunityList = [select id, accountId from Opportunity];

List<Contact> contactList = new List<Contact>();

for(Contact c : [SELECT Id FROM Contact WHERE AccountId IN :opportunityList.accountId]){ contactList.add(c);

}

Test.startTest and Test.stopTest for asynchronous execution

March 23, 2021March 23, 2021 konaguru Leave a comment

You can also use this method with stopTest to ensure that all asynchronous calls that come after the startTest method are run before doing any assertions or testing. Each test method is allowed to call this method only once. All of the code before this method should be used to initialize variables, populate data structures, and so on, allowing you to set up everything you need to run your test. Any code that executes after the call to startTest and before stopTest is assigned a new set of governor limits.

@isTest
public class testIncrement {
    
    @isTest
    static void testIncrement2() {
        
        Account acct = new Account(Name='test');
        acct.Number_of_Times_Viewed__c = 0;
        insert acct;
   
        System.debug(' Account Id ' + acct.id);
        
        Test.startTest();
     
        AuditUtil.incrementViewed(acct.id);
        
        Test.stopTest();
    
        Account acctAfter = [ select Number_of_Times_Viewed__C from Account where Id = :acct.id];  
        System.assertEquals(1, acctAfter.Number_of_Times_Viewed__c);
        
        
    }
    
}

@isTest

public class testIncrement {

@isTest

static void testIncrement2() {

Account acct = new Account(Name='test');

acct.Number_of_Times_Viewed__c = 0;

insert acct;

System.debug(' Account Id ' + acct.id);

Test.startTest();

AuditUtil.incrementViewed(acct.id);

Test.stopTest();

Account acctAfter = [ select Number_of_Times_Viewed__C from Account where Id = :acct.id];

System.assertEquals(1, acctAfter.Number_of_Times_Viewed__c);

}

public class AuditUtil {
    
    @future
    public static void incrementViewed(Id accountId) {
        
        System.debug('Account Id Passed ' + accountId);
        
        if  (accountId != null ) {
            Account accountObj = new Account();
            		accountObj = [select Number_of_Times_Viewed__c from account where id = :accountId ];
            accountObj.Number_of_Times_Viewed__c = accountObj.Number_of_Times_Viewed__c + 1;
            upsert accountObj;
        }
    }

}

public class AuditUtil {

@future

public static void incrementViewed(Id accountId) {

System.debug('Account Id Passed ' + accountId);

if (accountId != null ) {

Account accountObj = new Account();

accountObj = [select Number_of_Times_Viewed__c from account where id = :accountId ];

accountObj.Number_of_Times_Viewed__c = accountObj.Number_of_Times_Viewed__c + 1;

upsert accountObj;

}

Invoking a Queueable class from LWC

July 5, 2020July 5, 2020 konaguru Leave a comment

Execute a Queueable class when Salesforce community user access Lightning URL

APEX Class invoking Queueable Class

1	APEX Class invoking Queueable Class

public with sharing class GenerateQuoteCommunity {
  @AuraEnabled
  public static String runGenerateQuoteQueueable() {
    GenerateQuoteQueueable gqf = new GenerateQuoteQueueable(
      '0Q011000000OyGX',
      false,
      true,
      false,
      true,
      '0DB0Z0000007k4t',
      'Excel'
    );
    Id jobId = System.enqueueJob(gqf);
    return 'executed';
  }

  public GenerateQuoteCommunity() {
  }
}

public with sharing class GenerateQuoteCommunity {

@AuraEnabled

public static String runGenerateQuoteQueueable() {

GenerateQuoteQueueable gqf = new GenerateQuoteQueueable(

'0Q011000000OyGX',

false,

true,

false,

true,

'0DB0Z0000007k4t',

'Excel'

);

Id jobId = System.enqueueJob(gqf);

return 'executed';

}

public GenerateQuoteCommunity() {

}

LWC - JS File

1	LWC - JS File

import { LightningElement, wire,track } from 'lwc';
import getJobId from '@salesforce/apex/GenerateQuoteCommunity.runGenerateQuoteQueueable';

export default class GenerateQuoteTest extends LightningElement {

  @track jobId;

    handleLoad() {
        getJobId().then(result => {
            this.jobId = result;
        })
        .catch(error => {
            this.error = error;
        })
    }

}

import { LightningElement, wire,track } from 'lwc';

import getJobId from '@salesforce/apex/GenerateQuoteCommunity.runGenerateQuoteQueueable';

export default class GenerateQuoteTest extends LightningElement {

@track jobId;

handleLoad() {

getJobId().then(result => {

this.jobId = result;

})

.catch(error => {

this.error = error;

})

}

LWC - HTML File

1	LWC - HTML File

<lightning-card title=”Execute GenerateQuoteQueueable” icon-name=”custom:custom63″>

<lightning-button label=”Execute Queue” onclick={handleLoad}></lightning-button>

</p>
<div class=”slds-m-around_medium”>

<template if:true={responseReceived}> {jobId} </template>

</div> </lightning-card></template>

Salesforce Einstein – Data Builder/Dataflow Transformations

June 6, 2020June 6, 2020 konaguru Leave a comment

Vlocity Dataraptor – visual representation of input type/output types flow

May 3, 2020May 3, 2020 konaguru Leave a comment

Created below Picture to easily understand the Input Types to Output Types that DataRaptor would support. One picture speaks it all.

Practice simplifying object- and field-level security checks with new Spring ’19 in Apex code

August 8, 2019August 8, 2019 konaguru Leave a comment

updated challenge code

@RestResource(urlMapping='/secureApexRest')
global with sharing class SecureApexRest {
    @HttpGet
    global static Contact doGet(){
        Id recordId = RestContext.request.params.get('id');
        Contact result;
        if (recordId == null){
            throw new FunctionalException('Id parameter is required');
        }
        try {
            List&lt;Contact> results = [SELECT id, Name, Secret_Key__c FROM Contact WHERE Id = :recordId WITH SECURITY_ENFORCED];
            if (!results.isEmpty()) {
                result = results[0];
            }
        }
        catch(QueryException  ex) {
            throw new SecurityException('You don\'t have access to all contact fields required to use this API');
        }
        return result;
    }
    public class FunctionalException extends Exception{}
    public class SecurityException extends Exception{}
}

@RestResource(urlMapping='/secureApexRest')

global with sharing class SecureApexRest {

@HttpGet

global static Contact doGet(){

Id recordId = RestContext.request.params.get('id');

Contact result;

if (recordId == null){

throw new FunctionalException('Id parameter is required');

}

try {

List<Contact> results = [SELECT id, Name, Secret_Key__c FROM Contact WHERE Id = :recordId WITH SECURITY_ENFORCED];

if (!results.isEmpty()) {

result = results[0];

}

catch(QueryException ex) {

throw new SecurityException('You don\'t have access to all contact fields required to use this API');

}

return result;

}

public class FunctionalException extends Exception{}

public class SecurityException extends Exception{}

}

Get to know more about AI, Machine Learning

November 8, 2018November 27, 2018 konaguru Leave a comment

Important articles stumbled upon while exploring on AI, Machine Learning

Amazon’s own ‘Machine Learning University’ now available to all developers

https://aws.training/machinelearning

How to identify User Theme?

November 6, 2018November 8, 2018 konaguru Leave a comment

Use these variables to identify the CSS used to render Salesforce web pages to a user. Both variables return one of the following values.

Theme1—Obsolete Salesforce theme
Theme2—Salesforce Classic 2005 user interface theme
Theme3—Salesforce Classic 2010 user interface theme
Theme4d—Modern “Lightning Experience” Salesforce theme
Theme4t—Salesforce mobile app theme
Theme4u—Lightning Console theme
PortalDefault—Salesforce Customer Portal theme
Webstore—Salesforce AppExchange theme

<apex:page>
    <apex:pageBlock title="My Content" rendered="{!$User.UITheme == 'Theme2'}">
        // this is the old theme...
    </apex:pageBlock>

    <apex:pageBlock title="My Content" rendered="{!$User.UITheme == 'Theme3'}">
       // this is the classic theme ...
    </apex:pageBlock>
</apex:page>

<apex:page>

<apex:pageBlock title="My Content" rendered="{!$User.UITheme == 'Theme2'}">

// this is the old theme...

</apex:pageBlock>

<apex:pageBlock title="My Content" rendered="{!$User.UITheme == 'Theme3'}">

// this is the classic theme ...

</apex:pageBlock>

</apex:page>

Did you know?

October 30, 2018October 30, 2018 konaguru Leave a comment

Manage License link doesn't exists for Managed Packages in Sandbox orgs. 
All the users by default will have access to Managed Package in Sandbox orgs.

1 2	Manage License link doesn't exists for Managed Packages in Sandbox orgs. All the users by default will have access to Managed Package in Sandbox orgs.

2. The inner class will be the only thing that runs outside of sharing context, everything else will still be in sharing context.

public with sharing class MyClass
{
	public static void doStuff()
	{		
		Records[] list = new MyClassUtil().executeQuery();		
		//Do stuff here
	}
	
	/**
	 * Class to bypass sharing for the single case where non-admins need to query the permission set
	 */
	private without sharing class MyClassUtil
	{
		public Records[] executeQuery()
		{
			//execute and return the records here
		}
	}
}

public with sharing class MyClass

{

public static void doStuff()

{

Records[] list = new MyClassUtil().executeQuery();

//Do stuff here

}

/**

* Class to bypass sharing for the single case where non-admins need to query the permission set

private without sharing class MyClassUtil

{

public Records[] executeQuery()

{

//execute and return the records here

}

APEX Code Snippets

October 25, 2018October 25, 2018 konaguru Leave a comment

Reading inline Query data in APEX

/* Code snippet to read inline query data into APEX */
 
List<Account> accounts = new List<Account>();

accounts = [select id, (select id, firstname, lastname from contacts ) from Account where id in (select accountid from AccountShare where USerOrGroupId = '00531000007eCfF')];

List<Contact> contacts = new List<Contact>();

for(Account account : accounts ) {
    
    for(Contact contact: account.Contacts) {
        
        System.debug('Contact Object details  ' + contact );
    }
    
}

/* Code snippet to read inline query data into APEX */

List<Account> accounts = new List<Account>();

accounts = [select id, (select id, firstname, lastname from contacts ) from Account where id in (select accountid from AccountShare where USerOrGroupId = '00531000007eCfF')];

List<Contact> contacts = new List<Contact>();

for(Account account : accounts ) {

for(Contact contact: account.Contacts) {

System.debug('Contact Object details ' + contact );

}

JSONGenerator

This example generates a JSON string in pretty print format by using the methods of the JSONGenerator class

/*
 This example generates a JSON string in pretty print 
 format by using the methods of the JSONGenerator class
*/

// JSON Generate - Start  
        JSONGenerator gen = JSON.createGenerator(true);
        gen.writeStartArray();
        for(Opportunity opt : opty) {            
            gen.writeStartObject();
            gen.writeStringField('Id', opt.Id);
            gen.writeStringField('Type', opt.Type);
            gen.writeStringField('Name', opt.name);
            gen.writeStringField('StageName', opt.StageName);
            gen.writeNumberField('Probability', opt.Probability);
            gen.writeDateTimeField('LastModifiedDate', opt.LastModifiedDate);
            gen.writeDateField('CloseDate', opt.CloseDate);   
            gen.writeEndObject();
        }
        gen.writeEndArray();
        // JSON Generate - End

This example generates a JSON string in pretty print

format by using the methods of the JSONGenerator class

// JSON Generate - Start

JSONGenerator gen = JSON.createGenerator(true);

gen.writeStartArray();

for(Opportunity opt : opty) {

gen.writeStartObject();

gen.writeStringField('Id', opt.Id);

gen.writeStringField('Type', opt.Type);

gen.writeStringField('Name', opt.name);

gen.writeStringField('StageName', opt.StageName);

gen.writeNumberField('Probability', opt.Probability);

gen.writeDateTimeField('LastModifiedDate', opt.LastModifiedDate);

gen.writeDateField('CloseDate', opt.CloseDate);

gen.writeEndObject();

}

gen.writeEndArray();

// JSON Generate - End

S	M	T	W	T	F	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30