-
How do we create a SOQL query in Salesforce?
How do we create a SOQL query in Salesforce?
-
2 Replies
-
To use the Query Builder to query Salesforce data
Select Tools | Query Builder | Query Builder.
Drag tables (Salesforce objects) from the Object Explorer to the Diagram pane. Existing relationships display.
Note: You cannot create new relationships when building a Salesforce SOQL query.
If a pair of tables (objects) has more than one relationship, choose one relationship and remove the others.
To add additional existing relationships, add multiple instances of a table.
To restore a dropped relationship between tables, right-click the child table and select Restore FK.
Select the columns (Salesforce fields) you want to add to the query. For more information, see Build Queries Visually.
To use a SOQL date range function, select a date column and click in the Where field for that column. Then select a date range from the Date Range tab of the Where Condition dialog.
Click Execute SQL to run the query. -
Select Tools | Query Builder | Query Builder.
Drag tables (Salesforce objects) from the Object Explorer to the Diagram pane. Existing relationships display.
Note: You cannot create new relationships when building a Salesforce SOQL query.
If a pair of tables (objects) has more than one relationship, choose one relationship and remove the others.
To add additional existing relationships, add multiple instances of a table.
To restore a dropped relationship between tables, right-click the child table and select Restore FK.
Select the columns (Salesforce fields) you want to add to the query. For more information, see Build Queries Visually.
To use a SOQL date range function, select a date column and click in the Where field for that column. Then select a date range from the Date Range tab of the Where Condition dialog.
Click Execute SQL to run the query.
Log In to reply.
Popular Salesforce Blogs
Salesforce Marketing Cloud’s Einstein Just Got Better!
Cometh the update, cometh the improvements! With the recent June ‘21 release, Marketing Cloud has seen a couple of key improvements made within the Einstein…
How to Export Data from Salesforce to Excel and Backup Your Data On-Demand
Have you ever combatted with your data in Salesforce only to create a report and then export it to Excel? For an average user, it…
Salesforce Application Testing - Doing it the Right Way
With Salesforce applications becoming more and more complex, developing a high-performance application needs to be backed up with a robust Salesforce testing process. Hence, to…
Popular Salesforce Videos
Salesforce Pardot Basics - A Comprehensive Guide (2021)
In this short video, we will cover the basics of Salesforce Pardot Pardot by Salesforce is a demand generation and marketing management tool by Salesforce.…
Salesforce Lightning Tutorial | Build a Custom Lightning Home Page
This Salesforce Lightning Tutorial video by Edureka will help you understand what exactly is Salesforce lightning. It will also talk about some of the features…
Salesforce Data Loader | Import Relational Data
What is Data Loader and How to use it to import or export data to or from Salesforce? 00:00 What is Data Loader 01:00 How…
