Salesforce – Page 6 – javaniceday.com

sforce.apex.execute in Lightning

January 18th, 2020

You are here because your JavaScript buttons that worked in Classic doesn’t work in Lightning.

Let see how you can make it work

Straight to the point

This is your JavaScript button that works in Classic

{!requireScript("/soap/ajax/20.0/connection.js")} 
{!requireScript("/soap/ajax/20.0/apex.js")}
 
sforce.apex.execute("JSMMyExecuteClass", "myExecuteMethod", {param1:"Im param1",param2:"Im param2"}); 
window.location = 'https://google.com';

And this is your button working in Lightning

JSMMyButton.cmp

<aura:component implements="force:lightningQuickAction" controller="JSMMyExecuteClass" >
  <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>
</aura:component>

JSMMyButton.js

({
  doInit : function(component, event, helper) {
    var action = component.get("c.myExecuteMethodAura");
    action.setParams({
      "param1": 'Im param1',
      "param2": 'Im param2'
    });
    action.setCallback(this, function(response) {
    var state = response.getState();
 
    if(state == "SUCCESS" && component.isValid()){
      console.log("success") ;
      var result = response.getReturnValue();
      console.log(result);
 
      var urlRedirect = "https://www.google.com/search?q="+result;
      var urlEvent = $A.get("e.force:navigateToURL");
      urlEvent.setParams({
        "url": urlRedirect
      });
      urlEvent.fire();
    }else{
      console.error("fail:" + response.getError()[0].message); 
    }
  });
  $A.enqueueAction(action);
  }
})

JSMMyExecuteClass (Apex class)

public class JSMMyExecuteClass {
 
  public String myExecuteMethod(String param1, String param2){
    return 'ok '+param1+' - '+param2;
  }
 
  @AuraEnabled
  public static String myExecuteMethodAura(String param1, String param2){
    return new JSMMyExecuteClass().myExecuteMethod(param1, param2);
  }
}

The last step is to create a quick action that points to our component and then add it as many layouts you want.

Subscribe to this blog

Photo by lee junda on Unsplash

Migrate $User, $Profile, $Label and $Api to Lightning Components

September 9th, 2018

We can’t use $User, $Profile, $Label and $Api in Lightning. We need to implement a server-side solution.

Original JS button

alert($User.Email)

Create a Lightning component

JSMUserInfo.cmp

<aura:component implements="force:lightningQuickAction" controller="JSMUserInfoService" >
  <aura:attribute name="user" type="JSMUserInfo" />
  <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>

  Id: {!v.user.Id}
  <br/>
  First name: {!v.user.FirstName}
  <br/>
  Last name: {!v.user.LastName}
  <br/>
  Email: {!v.user.Email}

</aura:component>

JSMUserInfo.js

({
  doInit : function(component, event, helper) {
    var action = component.get("c.getUserInfo");
    action.setCallback(this, function(response) {
      var state = response.getState();
      if(state == "SUCCESS" && component.isValid()){
        console.log("success") ;
        var result = response.getReturnValue();
        console.log(result);
        console.log(result.FirstName);
        component.set("v.user", result);

   }else{
     console.error("fail:" + response.getError()[0].message); 
    }
   });
  $A.enqueueAction(action);
}
})

A wrapper class containing the user info we need

public class JSMUserInfo{
  @AuraEnabled
  public String Id {get;set;}
  @AuraEnabled
  public String FirstName {get;set;}
  @AuraEnabled
  public String LastName {get;set;}
  @AuraEnabled
  public String Email {get;set;}
}

The server-side controller that exposes the User’s info

public class JSMUserInfoService {

@AuraEnabled
public static JSMUserInfo getUserInfo(){
  try{
    JSMUserInfo info = new JSMUserInfo();
    info.Id = Userinfo.getUserId();
    info.FirstName = Userinfo.getFirstName();
    info.LastName = Userinfo.getLastName();
    info.Email = Userinfo.getUserEmail();
    return info;
  }catch(Exception e){
     throw new AuraHandledException(e.getMessage()); 
  }

  } 
}

We can use a similar approach for $Api or any other global variable

$Profile

@AuraEnabled
public static Profile getProfileInfo(){
  try{
    String profileId = UserInfo.getProfileId();
    Profile profile = [SELECT Id, Name FROM Profile WHERE Id =:profileId];
    return profile;
  }catch(Exception e){
    throw new AuraHandledException(e.getMessage()); 
  }
}

$Site

@AuraEnabled
public static JSMSiteInfo getSiteInfo(){
  try{
    JSMSiteInfo info = new JSMSiteInfo();
    info.Prefix = Site.getPathPrefix();
    info.Domain = Site.getDomain();
    info.Name = Site.getName();
    return info;
  }catch(Exception e){
    throw new AuraHandledException(e.getMessage()); 
  }
}

I would like yo hear your feedback. Did it work? Did you face some issue? Please leave your comment

Photo by Clark Young on Unsplash

Subscribe to this blog

How to convert sforce.apex.execute to Lightning

September 8th, 2018

Let’s see how to convert a Salesforce JavaScript button that uses sforce.apex.execute in to Lightning Experience.

The good news is you will reuse this code and the approach for all your similar buttons

Imagine you have this JavaScript button in your Salesforce instance. OK, probably your button is larger and more complex but the idea is the same

{!requireScript("/soap/ajax/20.0/connection.js")} 
{!requireScript("/soap/ajax/20.0/apex.js")}

sforce.apex.execute("JSMMyExecuteClass", "myExecuteMethod", {param1:"Im param1",param2:"Im param2"}); 
window.location = 'https://google.com';

In the example above we want to invoke the method myExecuteMethod that belongs to the Apex class JSMMyExecuteClass and you will pass these parameters {param1:"Im param1",param2:"Im param2"}

After that, it redirects to google.com

There’s not a direct solution (aka point and click) so we have to work a little bit

The first step is to create a Lightning component:

JSMMyButton.cmp

<aura:component implements="force:lightningQuickAction" controller="JSMMyExecuteClass" >

  <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>

</aura:component>

The controller part of my component is called JSMMyButton.js

({
  doInit : function(component, event, helper) {
    var action = component.get("c.myExecuteMethodAura");
    action.setParams({
      "param1": 'Im param1',
      "param2": 'Im param2'
    });
    action.setCallback(this, function(response) {
    var state = response.getState();

    if(state == "SUCCESS" && component.isValid()){
      console.log("success") ;
      var result = response.getReturnValue();
      console.log(result);

      var urlRedirect = "https://www.google.com/search?q="+result;
      var urlEvent = $A.get("e.force:navigateToURL");
      urlEvent.setParams({
        "url": urlRedirect
      });
      urlEvent.fire();
    }else{
      console.error("fail:" + response.getError()[0].message); 
    }
  });
  $A.enqueueAction(action);
  }
})

In JSMMyExecuteClass we need to create an equivalent method to call from our js controller:

public class JSMMyExecuteClass {

  public String myExecuteMethod(String param1, String param2){
    return 'ok '+param1+' - '+param2;
  }

  @AuraEnabled
  public static String myExecuteMethodAura(String param1, String param2){
    return new JSMMyExecuteClass().myExecuteMethod(param1, param2);
  }
}

Create a quick action that points to our component

Add the quick action to the layout(s) you want

That’s all. You can use this approach again for others button you have that require some code.

Maybe this video is interesting for you: Journey to Lightning Experience: Convert Your JavaScript Buttons

Photo by Artem Sapegin on Unsplash

Get Visualforce usage stats from VisualforceAccessMetrics

June 7th, 2018

If you want to know how frequently your Visualforce pages are accessed, you just have to run a simple query on VisualforceAccessMetrics:

SELECT ApexPageId,DailyPageViewCount,Id,MetricsDate FROM VisualforceAccessMetrics

That query will return stats from the latest 90 days

Page views are tallied the day after the page is viewed, and each VisualforceAccessMetrics object is removed after 90 days.

But BEWARE, that query could return deleted pages. To fix that, let’s tweak the query to:

SELECT Id, Markup, Name, NamespacePrefix FROM ApexPage WHERE Id IN (SELECT ApexPageId FROM VisualforceAccessMetrics)

Now the query will return only existing pages.

Photo by Kevin Ku on Unsplash

Astro image comes from SLDS

[Salesforce] A pie chart in Campaign’s record page

May 26th, 2018

Introduction

What about if we add a component with a pie chart in the Campaign object’s record page? It’s very useful to see how the campaign is going in terms of leads’ statuses. So we want to know the percentage of leads converted, not converted, contacted etc.

I will use Lightning in a Developer org that I just created to take advantage of its default data. So let’s go!

Assumption

You are familiar with a Salesforce org, Lightning and you have created some reports in the past. If you haven’t created any report yet, you can read this module in Trailhead: Reports & Dashboards for Lightning Experience

Add leads to a campaign

First of all, let’s add some leads to a campaign. You only have to add leads to a campaign, you don’t have to create any data.

Create the report

Go to Reports, New Report, expand Campaigns, select Campaign with leads and click on Create.

Drag Lead status field and group by this field

Save the report with the name you want and, importantly, in a public folder.

Run the report and add a pie chart. Don’t forget to save it.

Add the report component

Now let’s add our report to the Campaign’s record page.

Open any campaign and Edit Page to open the App Builder.

Drag the Report Chart component and set those parameters

Save the page and press Back to see the record page again with the report

Migrate sforce.connection.query to Lightning equivalent

January 14th, 2018

Are you looking for a way to migrate your existing Salesforce Apex code with sforce.connection.query to its Lightning equivalent? You’ve come to the right place!

The sforce.connection.query class is used to execute SOQL queries in Salesforce JavaScript buttons.

As you probably know, JavaScript buttons are not supported in Lightning Experience (LEX). In particular, you can’t use REQUIRESCRIPT.

In this post, the idea is to show how to migrate a particular JavaScript button that uses sforce.connection.query sentence.

Suppose our JavaScript button is like this:

{!REQUIRESCRIPT("/soap/ajax/37.0/connection.js")} 
{!REQUIRESCRIPT("/soap/ajax/37.0/apex.js")} 
var query ="SELECT Id, Name FROM Account LIMIT 10";
var queryRecords= sforce.connection.query(query);
var records = queryRecords.getArray("records"); 
//Do something with the records...

A Lightning equivalent solution requires several steps. I assume that you have some knowledge about Lightning Components development as well as Apex development.

Well, let’s go!

Create a Lightning component called MyQueryResult and Its JavaScript controller

MyQueryResult.cmp

<aura:component controller="MyQueryResultService" >
 <aura:attribute name="queryResult" type="SObject[]" />
 <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>
 
    <!-- It just displays the results. Modify It depending on your needs -->
    <aura:iteration items="{! v.queryResult}" var="item">
        {!item.Id} - {!item.Name}<br/>
     </aura:iteration>
</aura:component>

MyQueryResult.js

({
    doInit : function(component, event, helper) {
        var myQuery = 'SELECT Id, Name FROM Account LIMIT 10';
        var action = component.get("c.executeQuery");
        action.setParams({
            "theQuery": myQuery
        });
        action.setCallback(this, function(response) {
            var state = response.getState();
            if(state == "SUCCESS" && component.isValid()){
                console.log("success") ;
                var queryResult = response.getReturnValue();
                console.log(queryResult);
                component.set("v.queryResult", queryResult);
            }else{
                console.error("fail:" + response.getError()[0].message); 
            }
        });
        $A.enqueueAction(action);
    }
})

We will need also a service (an Apex class) to execute our query

MyQueryResultService

public class MyQueryResultService {
    @AuraEnabled
    public static List<sObject> executeQuery(String theQuery){
        try{
            String query = String.escapeSingleQuotes(theQuery);
            return Database.query(query);
        }catch(Exception e){
            throw new AuraHandledException('Error doing the query: '+theQuery+' Error: '+e.getMessage());
        }
    }
}

After that, we need a quick action pointing to our component.

The last step is to add our quick action to the layouts we need

Read more about this at Lightning Alternatives to JavaScript Buttons

Java client for advanced pdf conversion using a Salesforce org

August 25th, 2017

All we know renderAs=”pdf”. nThe good news is now Salesforce has an advanced pdf converter:

renderAs=”advanced_pdf”

<apex:page sidebar="false" showHeader="false" renderAs="advanced_pdf">   <html lang="en-US" >     <head>       <meta charset="UTF-8" />     </head>     <body>       <h1>Hello, world!</h1>     </body>   </html> </apex:page>

Still this functionality is a pilot what It means that you need to create a case and someone from support will activate It in your org.

“Advanced PDF renders Visualforce pages as PDF files with broader support for modern HTML standards, such as CSS3, JavaScript, and HTML5. This change applies to both Lightning Experience and Salesforce Classic.” Read more

In some projects I had to convert html to pdf. Some solutions like iText did not work well in complex html so I needed a better solution. One of them is take advantage of advanced_pdf rendering from Salesforce so with a simple web service should be easy.

This Apex class exposes a RESTful webservice that receives an html string an return a pdf as base64

@RestResource(urlMapping='/htmltopdf') global class HtmlToPdf {   @HttpPost   global static PdfResponse convertToPdf(String html) {     browser.RenderRequest request = new browser.RenderRequest();     request.setPageContent(html);     Blob blobVal = browser.Browser.renderToPdf(request);     PdfResponse resp = new PdfResponse();     resp.base64Content = EncodingUtil.base64Encode(blobVal);     return resp; }    global class PdfResponse {     String base64Content;   } }

Then all you need is this Java client to consume that web service.

Important: by default remote css, images and any other resource won’t work. I recommend you upload
all in a static resource and do references using relative path.

If you want to use remote resources you must create a Remote Setting in your org and of course pdf conversion will be slower.

See the full example in my Github account https://github.com/andrescanavesi/salesforce-pdf-converter

Salesforce client for an Apex RESTful web service

May 8th, 2017

An example about how to consume a Salesforce api rest, in particular:

/services/apexrest/

The example shows how to authenticate using username and password to get the access token and then how to do a request to this Salesforce web service:

@RestResource(urlMapping='/hellorest')
global class HelloRest {

    @HttpPost
    global static String echo(String name) {
        String echo = 'Hi, '+name;
        System.debug('Echo: '+echo);
        return echo;
    }
}

See the code from Github https://github.com/andrescanavesi/salesforce-apex-rest

Photo by Franck V. on Unsplash

Category: Salesforce

Straight to the point

Subscribe to this blog

Share this:

Original JS button

Create a Lightning component

Subscribe to this blog

Share this:

Share this:

Astro image comes from SLDS

Share this:

Introduction

Assumption

Add leads to a campaign

Create the report

Add the report component

Share this:

Share this:

Share this:

Share this: