Category: VS Code

SOQL Query Builder in VS Code, the fastest way to write SOQL statements

Salesforce introduced the fastest way to write SOQL statements, the SOQL Query Builder. SOQL Query Builder is the Visual Studio Code Extension that enables you to write, execute SOQL statements write inside your project workspace. Not only that, this tool will allow you to download the query result in either CSV or JSON format.How to install SOQL Query BuilderOnce you open the Visual Studio Code, search for SOQL in Marketplace. From there install the SOQL extension from Salesforce. After installation, it is always recommended to restart VS Code. Below is the screenshot How to use SOQL Query BuilderAfter installation, all your soql files will be stored under the folder scripts -> soql. You can save your own soql commands, just make sure the extension of the file is .soql.Below is the example where I have opened account.soql file and executed the statement. As you can see, with this new tool, we have the opportunity to do everything we are doing today with workbench w.r.t. executing soql statements. Also, you can download the query result in either CSV or JSON format.Youtube VideoVideo Link:

Read More

Spring’20 Brings Improved Code Coverage Result for Apex Test Class

 Writing test classes to cover both positive, negative, and bulkified scenarios are always the best practices that each developer should follow. While writing test classes, our approach should be to cover as much as code and all the scenarios. There is a restriction from Salesforce that if there is not enough coverage (75%) for the code, then Salesforce will not allow you to deploy your code to production.So identifying the code coverage is very important. Now there are multiple ways we can get to know the code coverage like – Setup menu, Developer Console, SOQL Query, Salesforce CLI, or Salesforce extension in Visual Studio Code. With so many options there comes the difficulties. Each option presents the code coverage in a different way and more importantly, each option calculates code coverage in a different way. This always creates confusion. For example, when a developer writes the test class and executes that from CLI, it provides the code coverage, let’s say 90%, which should be good enough to deploy the code into Production. But while deployment, the code coverage came down to 50%, and thus deployment stops. The reason for this drop in code coverage is that while deploying code coverage is calculated at the org level i.e. percentage of coverage for that class across the org.To solve this problem, Salesforce comes up with the Enhanced Code Coverage option. With...

Read More

Configure Parcel in VS Code for JavaScript Development

In my previous posts, I have written down the steps which will help you to configure ESLint, Prettier, and Husky in Visual Studio Code to make your JavaScript development easy and making sure code syntax, as well as best practices, are being followed. If you haven’t seen that post, I highly recommend you go through that at – Configure ESLint and Prettier in VS Code for JavaScript DevelopmentConfigure Husky in VS Code for JavaScript DevelopmentToday I am going to talk about another important tool when you are dealing with creating packages for your JavaScripts project. It’s called Parcel.From this post, you can expect -Quick introduction of ParcelConfigure Parcel in Visual Studio CodeExamplesQuick Introduction of ParcelParcel is a web application bundler. It’s an alternative of webpack and comes with some different value propositions.The main features which come with Parcel are – Parcel makes sure to perform all the above without any configurations with speed. Pretty impressive, right. Configure Parcel in Visual Studio CodeStep 1 – Initiate npmWe can initiate npm by executing the command “npm init” from the terminal section of the Visual Studio Code. This will ask for a few questions which are very self-explanatory, but we can ignore them by just typing enter. Once the command executes, it will create the file package.json in the workspace.Step 2 – Install ParcelWe can install parcel as dev dependency by executing the command “npm install...

Read More