Salesforce Archives

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

Article, Data Migration, Knowledge, Salesforce, Uncategorized

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

1 Comment / Salesforce, Uncategorized

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)

Salesforce, Uncategorized

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 »

Current User info in Lightning JS controller or Comunity without apex

173 Comments / Salesforce, Uncategorized

var userId = $A.get(“$SObjectType.CurrentUser.Id”);

How to insert CaseMilestone in Salesforce

Salesforce, Uncategorized

Sometimes we get such a scenario, we may need to create CaseMilestones– especially when you are doing data migration from Salesforce-to-Salesforce; but Salesforce does not allow to create CaseMilestone through custom means. But we can follow the below steps to insert it in new org same as we have in current org (assuming that you …

How to insert CaseMilestone in Salesforce Read More »

Filter Reports via URL Parameters in Lightning Experience

9 Comments / Salesforce, Uncategorized

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)

Salesforce, Uncategorized

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 »

Why Email publisher action is not visible on Case though it is added to the page layout?

8 Comments / Salesforce, Uncategorized

1. Ensure “Enable Case Feed Actions and Feed Items” is enabled under support settings. To modify Support settings : Go | Setup | Customize | Cases | Support Settings. 2. If you do not find the setting “Enable Case Feed Actions and Feed Items” under support settings, make sure “Feed Tracking” is enabled for case object. To …

Why Email publisher action is not visible on Case though it is added to the page layout? Read More »

Custom Domain Masking of Salesforce Communities

1 Comment / Salesforce, Uncategorized

Description Implementing a custom domain for your community creates brand recognition and gives you additional control and functionality. We’ll go through how you can get your custom domain implemented. Prerequisites & Assumptions Steps to setup the masking Prepare Host-name for CNAME configuration from Salesforce: Get Salesforce 18 digits organization id. You can get that easily …

Custom Domain Masking of Salesforce Communities Read More »