Contact Me


Comments

Post a Comment

Popular posts from SFDC Drona

Retrieve IP Address for the Guest Users in Lightning Community

Recently, we received a requirement where we needed to track the IP address of the guest users on the Salesforce Lightning Community. One of the ways to get the IP address of the current user in Apex is using the following method: Auth.SessionManagement.getCurrentSession().get('SourceIp') But this method works only for logged in users and gives an error for the guest users. We tried getting the IP address from the cookies also, but it's not a good idea because it is really not necessary that for guest users, you will get the IP address in the cookies always. At last, we came up with the following workaround to solve this riddle: 1) Create the following apex controller (ViewIPAddressController):  public class ViewIPAddressController{     public String ipAddress{get; set;}     public ViewIPAddressController(){         //this will work if no caching is in place or         //user is logged in via secure URL         ipAddress = ApexPages.currentPage().getHeade
Read more

Email Alert to Parent object's email field without apex

Image
Workflow! When you hear this term, a fantastic way to automate many business processes comes to your mind. Using workflows in Salesforce, you can do many things and this needs only a few clicks. You can perform various actions using worklow like updating a field, creating tasks, sending outbound messages and email alerts. A few years back, we got a requirement in a project where an email notification needs to be sent to opportunity owner and owner's manager if the opportunity stage turns to "Closed Won". So the requirement was simple, we just created a workflow rule with the specified criteria and created a workflow action to send the email alert. wait, wait, wait!! It was looking simple but while adding recipients to the email alert, we got stuck. There is a limitation associated with workflow email alert, we can add email fields as recipients if those are on the object for which we are creating workflow. In our scenario we needed to send email alert to the owner'
Read more

Incremental/delta data export using command line data loader

A few months back, we got a requirement for hourly incremental/delta export of data from Salesforce. There was a restriction that we didn't want to purchase any other licensed ETL tool, so we decided to use the command line data loader using that export can be scheduled also. Command line data loader requires SOQL to export the data, so to export the data hourly we scheduled the process using windows scheduler for every hour, but the main challenge here was to write a dynamic SOQL that would apply a filter to extract the records for those created date is greater than last 1 hour. Salesforce does not provide any SOQL datetime literal like LAST_1_Hour or LAST_N_HOUR. There are 2 methods to accomplish the requirement. First is using powershell script and the second is using SOQL itself. Method 1 - PowerShell Script In command line data loader, process-conf.xml contains the SOQL, so in case of an hourly incremental data extract SOQL will be like SELECT Id, Name FROM Contact
Read more