Variations of Deletion behavior in Salesforce and Rollback option

  1. If a child record (like a Contact or Opportunity) is deleted and the parent record is subsequently deleted (Like the Account), the child record is permanently deleted. Even if the parent record is undeleted, the child record cannot be recovered, but if the child record is undeleted first this won’t happen. 2. When …

Variations of Deletion behavior in Salesforce and Rollback option Read More »

How to find inline links/images in Salesforce knowledge using apex

We often get requirement to move articles/Knowledge from any platform to Salesforce but somehow we miss inline links to update. This script is just a quick way to find such affected articles: String artIds = ”;for(Knowledge__kav k : [SELECT ArticleBody__c FROM Knowledge__kav WHERE Language=’en_US’ AND PublishStatus=’Draft’]){    if(k.Answer__c!= null && k.ArticleBody__c.containsIgnoreCase(‘help.company.com’)){        //system.debug(k.Id);  …

How to find inline links/images in Salesforce knowledge using apex Read More »

Push notification in Lightning Service Console

There is a very powerful feature in classic console that whenever any changes happens at any record by other users, you can know it in list view and case detail page as well: https://trailhead.salesforce.com/en/content/learn/modules/service_console_customize/service_console_customize_push But unfortunately, Salesforce does not provide this feature in lightning service console yet — a real pain for support agent. Here is an idea …

Push notification in Lightning Service Console Read More »

Custom Fiscal Week (Monday to Sunday) in Wave Analytics (Salesforce Einstein Analytics)

https://success.salesforce.com/ideaView?id=0873A000000E4d2QAC   q = load “GR_Opportunities”; q = foreach q generate ‘CloseDate_day_epoch’ as ‘CloseDate_day_epoch’, ‘CloseDate_sec_epoch’ as ‘CloseDate_sec_epoch’, ‘Id’ as ‘Id’, ‘StageName’ as ‘StageName’,  daysBetween(toDate(“24-06-1985”, “dd-MM-yyyy”), toDate(CloseDate_sec_epoch)) % 7 as ‘datediff’; q= foreach q generate (case when datediff == 6 then (case when daysBetween(now(), toDate(CloseDate_sec_epoch))>=-6 and daysBetween(now(), toDate(CloseDate_sec_epoch))<=0 then “CurrentWeek” else “OtherWeek” end) when datediff == …

Custom Fiscal Week (Monday to Sunday) in Wave Analytics (Salesforce Einstein Analytics) Read More »

Filter Reports via URL Parameters in Lightning Experience

No need to futz with filters! Pass URL parameters to set filter values in Lightning Experience reports. When linking to reports or when bookmarking a report, add filter value parameters to the URL to customize how the report filters when opened. For example, bookmark your opportunities report and add a filter value parameter to specify …

Filter Reports via URL Parameters in Lightning Experience Read More »

Calculate Week Days between two Dates in Wave Einstein analytics (SAQL)

Requirement: a SAQL query to find the number of WEEKDAYS between two dates. Specifically, can use this SAQL query in a Compute Expression SAQL Expression: Here dataset name is “cases”. Start date is Created Date of a Case record and End Date is ClosedDate of Case. Algorithm is copied from here: https://help.salesforce.com/articleView?id=000004526&type=1. q = load “cases”; q = …

Calculate Week Days between two Dates in Wave Einstein analytics (SAQL) Read More »