Blog

• Business leadership: Help companies define and achieve a multi-cloud vision.
• Delivery leadership: Drive successful outcomes with best practices and use-case expertise.
• Technical leadership: Select the right product features to meet business goals.

SELECT Case__c, System_Type__c, COUNT(Id) 
FROM Message__c
WHERE System_Type__c = 'reminder'
GROUP BY Case__c, System_Type__c
HAVING COUNT(Id) > 4
 

public class BusScheduleCache {
    private Cache.OrgPartition part;    
     public BusScheduleCache() {
        part = new Cache.OrgPartition('local.BusSchedule');
    }
    
    public void putSchedule(String busLine, Time[] schedule) {
        part.put(busLine, schedule);        
    }
    
    public Time[] getSchedule(String busLine){
        Time[] schedule = (Time[])part.get(busLine);
        if (schedule == null) {
            schedule = new List<Time>();
            schedule.add(Time.newInstance(8, 0, 0, 0));
            schedule.add(Time.newInstance(17, 0, 0, 0));
... Read more »

{!'Basic ' & BASE64ENCODE(BLOB($Credential.BalancedLivingCredential.Username & ':' & $Credential.BalancedLivingCredential.Password))}

/flow/Disconnect_Assets?recordId={!Contact.Id}&retURL={!Contact.Id}

Problem: a random user should be selected from a queue to assign a lead. The number of users in the queue is unknown and calculated on the go (variable UserCount).

Implications: multiple records may enter the flow at the same time, so the random number should be generated for those (and the timestamp can't be used to generate the random number).

Solution: Use date with the combination with data that came with a record to generate a random number. The seed (the starting number to generate a random(~er) number) is a concatenation of date and length of the Lead Name (variable getLead.Name)

Implication: we don't know the span of a random number (max and min), so, we can't normalize the output.
Solution: use last digit of the random number -> this normalizes the span [0-9]

Final solution:

ROUND(value(Right(text(ROUND(sqrt(
(value(
 (left(right(text(now()),6),2)
		
		... 
		
			Read more »
		

Validation

Contacts

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
  <entity name="contact" >

    <attribute name="contactid" />
    <attribute name="hsl_forecordid" />
    <attribute name="fullname" />
    <attribute name="firstname" />
    <attribute name="lastname" />
    <attribute name="emailaddress1" />
    <attribute name="hsl_legacyid" />
    <attribute name="hsl_id18salesforcelegacy" />
  </entity>
</fetch>

Brand Preferences

Addresses

<fetch version="1.0" output-format="xml-platform" mapping="logical ... Read more »

WHERE Brand_Name__c != 'Etude' AND RecordTypeId = '012E000000066VlIAI' AND LastModifiedDate < 2020-03-03T00:00:00.000+0000

Select LastModifiedDate from Contact WHERE LastModifiedDate < 2020-03-03T00:00:00.000+0000 LIMIT 2

FROM Contact where RecordTypeId = '012E000000066VlIAI' AND (Brand_Name__c = '19 Crimes' OR Brand_Name__c = 'Acacia' OR Brand_Name__c = 'Cavalieredoro' OR Brand_Name__c = 'Cellar360' OR Brand_Name__c = 'Chateau St. Jean' OR Brand_Name__c = 'Embrazen' OR Brand_Name__c = 'Main & Vine' OR Brand_Name__c = 'Maison De Grand Esprit' OR Brand_Name__c = 'Meridian Vineyards' OR Brand_Name__c = 'Penfolds US' OR Brand_Name__c = 'St. Clement' OR Brand_Name__c = 'The Cellar' OR Brand_Name__c = 'The Walking Dead Wine' OR Brand_Name__c = 'Treasury Wine Event')

**

Select Id FROM Club_Member__c Where Club__r. ... Read more »

list fixCity = new list([Select Id, City__c from Contact where City__c like '%,%' LIMIT 2);
//system.debug(tweContact.size());

for (Contact c: fixCity ) {
    Set<String> city = new Set<String>();
     c.addAll(city.City__c.split(','));
    system.debug(city);
}

Just checking in to see how things are going on your side and to also confirm back to you that we will have our team ready, and to call out some items we need in order to prepare.   Amy and I had a quick planning session and here are our asks:

• Given our staffing and availability we would like to do our testing on Monday ***  ** – we have fully open calendars (except for 1:00-1:30pm) and would allow us to completely focus on getting done in one day.
• How much time will you need to Demo to our team to get them prepared for UAT? We would like to get that on calendars for 3/11 now, to block out time for the overview as well as testing. ... Read more »