Hi all,

In this blog, I am going to explain to you how to install Visual Studio and sync code with bitbucket. By the end of this blog, you will be able to code directly in VS code and sync code with bitbucket seamlessly.

There are some prerequisites for this blog. The prerequisites are given below.

Prerequisite

1. Install the latest version of the VS code.
2. Install the latest version of Salesforce CLI.
3. Install VS code extensions. VS Code extensions to be installed are listed below
   1. Salesforce Extension pack.
   2. Salesforce CLI integration
   3. Lightning web components.
4. Create a bitbucket account. Every account comes with 5 free user accounts.

Installing VS code :

Here I am explaining how to retrieve and deploy to an org(DEV/Sandbox/Production but not scratch org).

Step 1 :

First, open VS Code and create a project. Since we are not using scratch orgs in this blog so we need to create a project with the manifest.

To create a project with a manifest, open the command palette (press Ctrl+Shift+P on Windows or Linux, or Cmd+Shift+P on macOS) and run SFDX: Create Project with Manifest.

Step 2 :

Next, we need to authorize the org you want to develop against. So to start the login process, open the command palette again and run SFDX: Authorize an Org.

Step 3 :

You need to select your login URL and then provide your project name. Then your browser opens and you can log in to your org.

After you finish logging in, close the browser and return to the VS Code.

Step 4 :

After you authorize an org, we need to retrieve your source from it.

Right-click on the manifest, in the Visual Studio Code explorer, then select SFDX: Retrieve Source in Manifest from Org.

There are other ways of retrieving source :

• With a manifest file open in the editor, open the command palette (press Ctrl+Shift+P on Windows or Linux, or Cmd+Shift+P on macOS) and run SFDX: Retrieve Source in Manifest from Org.
• If a source file is open in the editor, right-click anywhere in the editing pane. Select SFDX: Retrieve This Source File from Org.

Deploy Source :

To deploy source to an org(to an org that’s not a scratch org), you can:

• Right-click on the manifest, in the Visual Studio Code explorer or the editor, then select SFDX: Deploy Source in Manifest to Org.
• With a manifest file open in the editor, open the command palette (press Ctrl+Shift+P on Windows or Linux, or Cmd+Shift+P on macOS) and run SFDX: Deploy Source in Manifest to Org
• In the Visual Studio Code explorer, right-click a source file or a directory. Select SFDX: Deploy Source to Org.
• In a source file that’s open in the editor, right-click anywhere in the editing pane. Select SFDX: Deploy This Source File to Org.
• With a source file open in the editor, open the command palette (press Ctrl+Shift+P on Windows or Linux, or Cmd+Shift+P on macOS) and run SFDX: Deploy This Source File to Org.

Version controlling with VS code using bitbucket

First, you need to create an account in bitbucket if you don’t have one please create an account in bitbucket.

Step 1:

We need to initialize git for your project, so open the command palette (press Ctrl+Shift+P on Windows or Linux, or Cmd+Shift+P on macOS) and run the below command

Git: Initialize Repository

Then navigate to default in the current project and navigate to default in the current project.

Step 2:

Navigate to Terminal in VS code and navigate to default in the current project.

Step 3:

We need to configure user email address, so from the terminal run

git config –global user.email “<userEmial address>”.

Step 4:

We need to configure user name, so from the terminal run                        

git config –global user.name “<username>”.

Step 5:

We need to add remote origin, this specifies the repository we need to sync with. To get the remote origin login into your Bitbucket account and navigate to your repository and click on the clone.

Select HTTPS from the drop-down.

Copy your repository URL as shown below.

Run command git remote add origin <url copied from butbucket>.

Step 6:

Now you need to authenticate to bitbucket account, run git remote show origin.

Now you need to authenticate to bitbucket account.

Step 7:

Now we need to pull the branches present in the repository, run git pull –rebase.

Step 8:

Now you need to pull from the branch you want to sync with. To do that click on 3 dots near-source control and click on the pull from and select the branch.

STEP 9:

 If there are any conflicts present then a number of conflicts will be displayed over the source control icon as shown below.

STEP 10:

 Now you need to stage the changes which you want to push to branch and if you want to stage all changes then Select All Changes as shown below. If you want to stage individual files then go to a specific file and stage that file.

Note: To stage a file is simply to prepare it finely for a commit.

STEP 11:

Now we need to commit the changes.

STEP 12:

Then you need to push to the specific branch you want to sync with.

Now you can see your commits in your bitbucket with commit id and version control is enabled for your development.

In this blog, I am going to take you through the process of how to schedule a report from apex class. While I was working on my last project I came across a scenario where I need to schedule a report from the apex. This blog takes you through the simplest way possible to achieve this requirement.

Using analytics REST API we can do the following things :

1. Create, update and retrieve the Salesforce Report and Dashboard.
2. Modify and schedule trends in Analytics report snapshot.
3. Retrieve a list of dataset versions.
4. Retrieve a list of dependencies for an application.

In order to schedule a report first, we need to understand ‘reports’ namespace.

Reports namespace contain a number of classes through which we can avail the same level of data access as in case of using Salesforce Reports and DashBoards REST API.

There are two ways of running a report through apex.

1. Synchronously
2. Asynchronously

Synchronous Way of running  reports:

If you want to run reports synchronously we have to use ReportManager class. In this, we need to use runreport() Method. The Return type of this report must be ReportResult class. This class contains results after running a report.

Check the below code for running report synchronously.

[sourcecode language=”java”]
public class ScheduleReport {

public ScheduleReport(){

list reportList=[select id, name from report where name=’DemoReport’’];

// To get the report Id.

string reportId=(string) reportList.get(0).get(‘Id’);

//To Run the report.

reports.ReportResults reportResult=reports.ReportManager.runReport(reportId, true);

system.debug(‘reportResult—&gt;’+reportResult);

}

}
[/sourcecode]

Asynchronously way of running reports:

If you want to run reports asynchronously we have to use ReportManager class similar to Synchronous way of running reports. Here you need to use runAsyncReport() method instead of runReport() method.

Advantages of running reports Asynchronously:

1. We can lower the risk of reaching the timeout limit when we run reports.
2. Salesforce API timeout limit does not apply for asynchronous runs.
3. Salesforce Reports and dashboards API can handle higher number of asynchronous run requests at a time.

Check the below code to Schedule a report Asynchronously

[sourcecode language=”java”]
public class ScheduleReport {

public ScheduleReport(){

list reportList=[select id, name from report where name=’DemoReport’’];

string reportId=(string) reportList.get(0).get(‘Id’);

Reports.ReportInstance instance = Reports.ReportManager.runAsyncReport(reportId, true);

System.debug(‘Asynchronous instance: ‘ + instance);

}

}
[/sourcecode]

Now we need to write a schedulable class to schedule our report.

Below is the code for schedule class.

[sourcecode language=”java”]
global class ScheduleReportClass implements Schedulable{

global void Execute(SchedulableContext context){

ScheduleReport sch=new ScheduleReport();

}

}
[/sourcecode]

Let us consider a scenario where I need to schedule a report every weekday at 1PM.

Below is the code for scheduling

[sourcecode language=”java”]
ScheduleReportClass sch=new ScheduleReportClass();
string cronExp=’0 0 13 ? * MON-FRI’;
system.schedule(‘schedule report’, cronExp, sch);

[/sourcecode]