Salesforce Aggregate Soql Query

Maximum number of fields based on which you can sort is 32. Otherwise it will send a bad SOQL query to Salesforce. Unfortunately, the trail reports that my solution does not bring the desired result. Just as we can write a specific a SQL statement from SQL Server, it would be great to be able to write a SOQL statement from Salesforce objects. com objects. - Configure Salesforce Marketing Cloud products and features including Email Studio, Social Studio, Mobile Studio, Ad studio - Use SOQL for data manipulation - Create and optimize API calls and data structures to improve performance Automate imports, extracts and SQL Query activity using Automation Studio. I need to get Account names and asset count for each account. SOQL is an acronym for Salesforce object query language. This parser was built following to the SOQL syntax definition provided by Salesforce. Salesforce Object Query Language (SOQL) is used to search your Salesforce data for specific information. In this Salesforce Developer Training Tutorial we are going to learn about SOQL inner join and SOQL Outer Join Relationships in Salesforce. This scenario describes a two-component Job used to extract a specific set of data from an object in a Salesforce database. I came up with a lightning component that displays any PDF content. SOQL(Salesforce Object Query Language) is used to query the records from the database based on the requirement. The aggregate query needs to be redesigned so it is not hamstrung by these tiny limits. When using the SOAP API to query existing Salesforce data, you can include SOQL aggregate functions in the SELECT statements of SOQL queries. com explorer to grab data from my Salesforce account. salesforce SOQL in simple and easy steps starting from. In SOQL Query mode, you can include SOQL aggregate functions in the SELECT statements of SOQL queries. The % and _ wildcards are supported for the LIKE operator. In this Salesforce Object Query language SOQL tutorial, we are going to learn about IN operator in SOQL statements and why we use IN operator in WHERE clause. com Introduction Salesforce Object Query Language commonly known as SOQL is the language to query data from the salesforce. com Introduction. By opening the SOQL Query section you can see the raw code that will be sent to salesforce. The origin places the result from the first function of a query into the expr0 field, the result from the second function of the same query into the expr1 field, and so on. A sample SOQL is written below: Select Id, Name from Account;. The latest Tweets from Salesforce Admins (@SalesforceAdmns). SOQl queries are two types they are Static SOQL and Dynamic SOQl. How to use SOQL Query with Nested SOQL, Aggregate functions, ORDER BY, GROUP BY, HAVING, OFFSET and LIMIT? Posted by Ajomon Joseph on January 2, 2016 October 18, 2018 We can use SOQL query in different ways. You can view the SOQL query that was generated for your selection. It would be really awesome if SOQL can do that. If I open "salesforce. SOQL is a tool which helps us to retrieve a record from database in Salesforce. But I need to get Account names also. BMCServiceDesk__Incident_Service_Target__c. How can I create an aggregate SOQL query where one field is a long text area? Hi Community, I have been struggling for a week trying to create a SOQL query to fuel a Conga template that I will use as a Sales Invoice. I still think it's a bug in the Salesforce connector. com released new Apex functionality for aggregate functions in SOQL. In this module, you use the Developer Console to familiarize yourself with SOQL and DML. Basic Parent-to-Child (Aggregate) Traversal To traverse a relationship from a parent to a set of children, use a nested query. These SOQL logical operators are very easy to use to check multiple conditions in a single Salesforce Object Query language statement. Try to understand the approach from following code. v Dynamic SOQL in Apex —Apex requires that you surround SOQL and SOSL statements with square brackets in order to use them on the fly. Connecting to. SOQL(Salesforce object query language) is used to search data in Salesforce. Although performing these checks was possible in earlier releases, this clause substantially reduces the verbosity and technical complexity in query operations. Act as knowledge integrator and translator between business users and technical team members. It's an easy language to learn. Tip#3 – Aggregate functions in SOQL. Different types of operators used to filter the records retrieved vai the SOQL query. To Start using, Select your Salesforce instance By Dev Prakash and Jitendra Zaa. I am using Django & Salesforce. If you are not, there are plenty of great resources on the web to brush up with. com Introduction Salesforce Object Query Language commonly known as SOQL is the language to query data from the salesforce. Posted in Salesforce , SOQL on February 8, 2011 by sivateja. Yup - you can write SOQL queries in Data Loader! And yes, you can bypass the UI and simply type your query in the box! But there's still a better place to write SOQL, and it's all the rage these days. 3)A sub-query can use OFFSET only if the parent query has a LIMIT 1 clause. While writing Apex code, we should take care of number of code statement that are executed to avoid governor limits. Welcome to the Complete Salesforce Certified Platform Developer I Course! I have designed and built this course to be 100% aligned with the official exam Study Guide of the latest Salesforce Certified Platform Developer I release, and I will be updating it on each subsequent release if necessary. com platform. SELECT, fields, FROM and Object are required and all others are optional. Static SOQl statements. SOQL is an acronym for Salesforce object query language. Generally, you want to use Async SOQL over standard SOQL when you're dealing with large amounts of data. Write a SOQL query in Saelsforce Get the code here: select Name, phone, accountNumber, Site from Account where name = 'sForce' Please Subscribe ! Websites:. If you do not wish to remove duplicates, try using the UNION ALL operator. -Using SOQL to Query Data with BIG OBJECT. It would be really awesome if SOQL can do that. When you build a Salesforce query in the Query Builder, Toad generates a SOQL query in the Query tab. com Explorer. Happy SOQL!!!!!. com Object Query Language). There is only one CreatedDate in this case, so the grouped query returns the same results as the ungrouped one. This posting is not meant to be a comprehensive resource on the topic but rather a secondary source of information to complement what is already available by Salesforce. query method to dynamically execute a query from a string, it is far from easy to construct such a string in a structural and flexible way. You can evaluate Salesforce Object Query Language (SOQL) or Salesforce Object Search Language (SOSL) statements on-the-fly in Apex by surrounding the statement in square brackets. A SOQL query is the equivalent of a SELECT SQL statement and searches the organisation database. Dismiss the Show Table dialog box. Comparison Operators in SOQL. Tip#3 – Aggregate functions in SOQL. SOQL query in javascript example. SOQL Statements SOQL statements evaluate to a list of sObjects, a single sObject, or an Integer for count method queries. The following example demonstrates a SOQL query for loop used to mass update records. Execute dynamic query in salesforce. Detailed knowledge of Salesforce. Can we write group by clause in SOSL? 4) DML. Hi Ajit, Formula Fields cannot be used with the group by clause in SOQL query You can check whether a field is "groupable" or not using DescribeFieldResult. You can view the SOQL query that was generated for your selection. I recommend studying that material in detail. If you're using a column in the ORDER BY field, you should also include that same column in the SELECT QUERY field. Try Date_Answered__c > 2005-10-08. SOQL(Salesforce Object Query Language) is used to fetch the data from Sobject in salesforce organization. When you build a Salesforce query in the Query Builder, Toad generates a SOQL query in the Query tab. SOQL Studio is a premium query tool for the force. Different types of operators used to filter the records retrieved vai the SOQL query. What are alias name in SOQL? 28. SOQL is similar to the standard SQL language but is customized for the Lightning Platform. com has provided us developers some great materials to read about SOQL Injection. I'm a small business owner and I'm brand new to this SOQL stuff. If you are not, there are plenty of great resources on the web to brush up with. This system can ideally, quickly and easily share data when needed. View Ahmed BENSAAD’S profile on LinkedIn, the world's largest professional community. These query strings can be used in the following places:. - Opening Cases to Salesforce CRM itself (abroad) and discussing and solving errors which are caused or not caused in our end and being informed for any changes on Salesforce CRM by Salesforce Support Crew (abroad) - Retrieving the needed data on Salesforce CRM using SOQL (like SQL) queries. Salesforce knows you’re using a bind variable when you precede your Apex variable with a colon ( : ) – here’s an example:. com using SOQL (Salesforce Object Query Language) Posted by Alex Tarasevich on 7th December 2018 | Featured XL-Connector 365 has a very powerful tool allowing you to pull ANY data from your Force. However, you will need to use different method to retrieve the result of the aggregate function. A deeper look at SOQL and Relationship Queries Click here to refer basics of Relationship Query SOQL is the object oriented language for querying data in Force. com Introduction. would you please tell me how to access picklist values (not label or API name) from our Salesforce org through SOQL query. SOQL Doctrine DBAL. See the example below. SOQL query sorting is case insensitive. A community where you can learn from, where you can contribute to. Aggregate functions in salesforce include AVG(), COUNT(), MIN(), MAX(), SUM(). These SOQL logical operators are very easy to use to check multiple conditions in a single Salesforce Object Query language statement. com objects. apex class [accWithContController. pdf), Text File (. Salesforce Apex and SOQL (Salesforce Object Query Language) together give the developers powerful tools for managing Salesforce data and processes of their application. To Start using, Select your Salesforce instance By Dev Prakash and Jitendra Zaa. Salesforce Developer Network: Salesforce1 Developer Resources. BMCServiceDesk__Incident_Service_Target__c. Remember, to dive deeper into this topic, check out the hands-on training video link in the Resources section. Getting started with SOQL Jonathan Taylor Klipfolio Dashboard's Salesforce data connector leverages SOQL (Salesforce Object Query Language) to retrieve your data in the form of a JSON file so you can create Salesforce dashboards. Insights of SOQL and Relationship Queries on Force. This course will help you to pass your certification. salesforce soql subquery, Salesforce Developer Network: Salesforce1 Developer Resources. I have searched and found that one should use “Schema. Search in single sObject and it retains records. Also retrieve all fields from salesforce object without writing fields names in query. "Select * from Table_name" : You can use this query in Java,. SOQL Aggregate function limitation learned SOQL Aggregate functions have special set of limits than a normal SOQL query. com Introduction Salesforce Object Query Language commonly known as SOQL is the language to query data from the salesforce. We use cookies to make your interactions with our website more meaningful. Just as we can write a specific a SQL statement from SQL Server, it would be great to be able to write a SOQL statement from Salesforce objects. com platform. View Ahmed BENSAAD’S profile on LinkedIn, the world's largest professional community. Avoid SOQL queries and DML statements inside loops. To Start using, Select your Salesforce instance By Dev Prakash and Jitendra Zaa. I wont to fetch all the 20 values of my picklist & display in Django. These are called non-selective queries. Relationships between the objects(master-detail OR lookup) and we need to fetch all child records using SOQL. Executing SOQL Queries. What are the tools and features in Salesforce Developer Console. We’ll cover this type of. The following example demonstrates a SOQL query for loop used to mass update records. "Select * from Table_name" : You can use this query in Java,. For example, you could use the AVG() aggregate function. update fields based on soql query I would like to update a custom Account field by running a soql query for the Leads object. Aggregate functions include AVG() , COUNT() , MIN() , MAX() , SUM() , and more. SELECT, fields, FROM and Object are required and all others are optional. Salesforce内開発者コンソールでのSOQLの記述をまとめました。 コンソール(Query)の基本 まず、右上のユーザ名→開発者コンソールをクリックします。 コンソール画面で、 File→ OpenResource → selectしたいオブジェクトを選択し. Note that these two has different syntax and functionality support, do not mix it. SOQL statements cannot query aggregate relationships more than 1 level away from the root entity object. Up until the release of Salesforce API 18. com platform database. com and OWASP. would you please tell me how to access picklist values (not label or API name) from our Salesforce org through SOQL query. No more than 10 method calls per Apex invocation 2. Worked on Salesforce ERP Integration model. I have searched and found that one should use “Schema. SOQL is much simpler and more limited in functionality than SQL. background: I generate leads through a web-to-lead form that also sends the account ID of the (later) associated account (if converted). Comparison Operators in SOQL. Join us to learn how to translate SQL queries and joins into SOQL queries and joins. Modeling and Querying Data and Relationships in Salesforce Salesforce Developers. As a developer looking to extend Salesforce. new collection. This query will query all Approval process and it's Steps SOQL Aggregate function limitation learned;. Comparison operators in SOQL are used to compare a value with another value to return TRUE or FALSE. Up until the release of Salesforce API 18. A deeper look at SOQL and Relationship Queries Click here to refer basics of Relationship Query SOQL is the object oriented language for querying data in Force. I noticed the execution plans for the two queries are different - The second query uses Parallelism while the first query does not. The Appirio SOQL Query tool is an open source Visualforce SOQL query engine that allows you to run SOQL queries right from w/in your org. Mastering SOQL is the key to mastering Apex Once you start writing more complex pieces of code, you’ll soon run into governor limits. If you are not, there are plenty of great resources on the web to brush up with. ) Create relationships between objects to reduce your number of queries. Up until the release of Salesforce API 18. SOQL is a tool which helps us to retrieve a record from database in Salesforce. More efficient SOQL is a great place to start. You will need to know the table names it references and create a separate connection then join the two tables. Below is the Agenda for today:- What is SOQL? When to use SOQL? Types of SOQL Query ; Live Demo on Different of SOQL Queries. background: I generate leads through a web-to-lead form that also sends the account ID of the (later) associated account (if converted). Records are pertaining to single sObject. com account and pull data from multiple objects at the same time by modifying the SOQL query in your AWS Glue code. As a little exercise, I've created a small tool comprised of a VisualForce page/tab that allows system administrators to run ad-hoc SOQL (SOSL and aggregate queries) from within their applications and do mass update on every page of 100 records. When we say selective, we refer to SOQL that contains at least one query filter on an indexed field and that filter in turn reduces the resulting number of rows below a Salesforce-determined threshold*. Using salesforce developer console we can and edit execute SOQL and SOSL queries. You can also use aggregate functions without using a GROUP BY clause. Help building SOQL Aggregate Query with Relationship. Batchable in Salesforce, but if you want to use SOQL having aggregate functions like SUM(), MAX(), COUNT() on results grouped by "GROUP BY" clause in start execution, changing to interface Database. Only 500 records can be queried if we use Aggregate functions in our query and also we can't use query more here. Increase readability by indenting code and breaking up long lines. Salesforce does not support UPDATEs or DELETEs using SOQL, so the Easysoft driver has to convert the query into a SOQL SELECT. Top 10 Project Management Tools Software Developers Should Know Why Join Become a member Login. What I mean is you don't have to hard code values. We'll cover this type of. These SOQL logical operators are very easy to use to check multiple conditions in a single Salesforce Object Query language statement. In this module, you use the Developer Console to familiarize yourself with SOQL and DML. Look out for missing comma in SOQL, and fix the issue. You can use SOQL to read information stored in your org's database. Ho to resolve this "Error: System. The key to awakening the power of Apex lies in SOQL, Salesforce's data querying language. Similar to other database query language, SOQL do support aggregate function like COUNT(), MAX(), SUM() and etc. SOQL Statements SOQL statements evaluate to a list of sObjects, a single sObject, or an Integer for count method queries. For example, you could use the AVG() aggregate function to find the average Amount for all your opportunities. on the server side to query the database and Salesforce Lightning Design. This is a topic in itself, but you shouldn't be re-running triggers twice if it's not needed. After logging in, select queries > SOQL Query. Welcome back to another episode of "Cooking with Code" where I introduce delectable bite-sized topics related to coding in Salesforce. Let's get started, SOQL(Salesforce Object Query Language) is used to query the records from the database based on the requirement. I need to get Account names and asset count for each account. The dynamic queries are not a commonly used feature but in certain situations they come in as a life-saver. Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis. It can search a record on a given criterion only in single sObject. Sign Up ›. Queries that include aggregate functions are subject to the same governor limits as other SOQL queries for the total number of records returned. Hi I am new to Salesforce SOQL. SOQL can be embedded in Apex code and various other places in your Org to grab specific information in a programmatic way. Increase readability by indenting code and breaking up long lines. When you build a Salesforce query in the Query Builder, Toad generates a SOQL query in the Query tab. In this Salesforce Training tutorial we are going to learn about example of SOQL Syntax and its explanation. 3 Comments on Episode 4 – Basics of SOQL & Best Practices We hope you are enjoying the Path To Code series on your journey of becoming an #AwesomeDev in Salesforce! Episode 4 is scheduled for Jan 23, 2019 at 8:30 pm EST and will be presented by Amit Chaudhary. They are typically terminated by the system to to avoid the lengthy execution times. NET or PHP to retrieve all the data from a given table. salesforce SOQL in simple and easy steps starting from. Please try again later. com database to Excel using a SOQL query, click the Get Data button in your XL-Connector ribbon. Write a SOQL query in Saelsforce Get the code here: select Name, phone, accountNumber, Site from Account where name = 'sForce' Please Subscribe ! Websites:. As we all know, Apex code has limitation of Number of code statements that can be executed. Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis. Unlike in SQL, the SOQL for loops iterate over ALL the sObjects returned by a SOQL query. for (someVariables : [soql_query]) { someCode} Note that the variables above must be of the same type as the sObject that are returned by the. com development environment which includes custom objects, workflows, triggers, the Force. These queries return an AggregateResult object which can be somewhat confusing at first. “Select * from Table_name” : You can use this query in Java,. Both above result need different sets of data so this can not be combine into one query. com without any programming. Version 2 This is Version 2 of the Salesforce Lightning Lookup Component. In this Salesforce Developer Training Tutorial we are going to learn about SOQL inner join and SOQL Outer Join Relationships in Salesforce. Enter your SOQL statement in the Query pane. In your case, you have a column that is a date data type but you are using the format for a date time literal. SOQL is similar to the standard SQL language but is customized for the Lightning Platform. - By using SOQL, we can know in which object or fields the data resides. The major difference between SQL and SOQL is, SQL is used to get the data from one or more tables even if they are not related to each other whereas in SOQL is used to get data of a particular object or related object. Building a custom Salesforce dashboard using the Advanced SOQL Query Mode. The functions like SUM() and MAX() in SOQL allow to roll up and summarize the data in a query. BMCServiceDesk__Incident_Service_Target__c. Salesforce Object Query Language commonly known as SOQL is the language to query data from the salesforce. This code won't save yet, since you still have to write the SOQL query. com has provided us developers some great materials to read about SOQL Injection. Worked on Salesforce ERP Integration model. com without any programming. We have to specify the column names in the case of SOQL query. Relationship Queries in SOQL Relationship queries helps you extract data from Salesforce database with minimum possible number of queries. Also, it would be great to be able to grab the underlying SOQL statements that generate specific Salesforce reports, so that the underlying report itself doesn't have to be maintained and the. Since setting a Limit defeats the purpose of an aggregation, this makes aggregate queries useless except in the smallest of data sets. A good Salesforce developer prevents their code from hitting these limits by using SOQL effectively. There should be unit tests for your code. The format of literal changes in SOQL based on whether the column is date or date time as defined in salesforce. I'm going to accept my own reply as solution in case it helps anyone. The following example demonstrates a SOQL query for loop used to mass update records. Salesforce knows you're using a bind variable when you precede your Apex variable with a colon (:) - here's an example:. • Extraction of data using SOQL queries • Hands on experience. So you may well be running through all your query code twice unnecessarily. com platform, allowing you to run queries, edit data, and do other data related tasks, including: Build & Run SOQL (including SOQL-R) and SOSL queries against your Salesforce data. Child query cannot be used when Aggregate functions are used. Basic Parent-to-Child (Aggregate) Traversal To traverse a relationship from a parent to a set of children, use a nested query. This code won't save yet, since you still have to write the SOQL query. Name = '' AND isActive = true. Salesforce Apex and SOQL (Salesforce Object Query Language) together give the developers powerful tools for managing Salesforce data and processes of their application. This is where I stuck. 0 and later, you can use GROUP BY with aggregate functions, such as COUNT(), SUM() or MAX(). Look out for missing comma in SOQL, and fix the issue. These query strings can be used in the following places:. Hi folks, In this tutorial, You will learn what is SOQL Queries in Salesforce and Some SOQL Queries example. You can query data from Parent-Child object as well. This should. A deeper look at SOQL and Relationship Queries Click here to refer basics of Relationship Query SOQL is the object oriented language for querying data in Force. io was translating this into SOQL code. Below is the Agenda for today:- What is SOQL? When to use SOQL? Types of SOQL Query ; Live Demo on Different of SOQL Queries. Then add the WHERE condition clause used to filter data to be retrieved at the end of the generated SOQL query. Involved in various stages of Software Development Life Cycle (SDLC) in agile methodologies, including maintenance of standalone object oriented enterprise applications. if you want to Find Number Of Active Users In a Role use the Below simple SOQL query. Now one can forget about Salesforce and have a nice repository/query object integration on one's architecture without hurting that much on the usual project structure. Search in single sObject and it retains records. I wont to fetch all the 20 values of my picklist & display in Django. Salesforce Apex and SOQL (Salesforce Object Query Language) together give the developers powerful tools for managing Salesforce data and processes of their application. When composing a Salesforce query in the Editor, use SOQL. In this Salesforce Training Tutorial we are going to learn about Comparison operators in SOQL, Comparison operators with SOQL statement examples. The data model of Force. com database using SOQL & SOSL queries using Force. I have created a query but calling from API and executing following query returns me a 'Ca. It displays the results in a grid below the input field and allows for sorting and other basic features. Interview Questions on Aggregate Functions in salesforce. Member of Deloitte Lightning CoE (Center of Excellence) team. SOQL(Salesforce Object Query Language) is used to fetch the data from Sobject in salesforce organization. Salesforce Platform Developer 1 certification exam preparation to become Salesforce Developer. I have created a query but calling from API and executing following query returns me a 'Ca. What is the use of Aggregate function SOQL queries in salesforce? 29. Both above result need different sets of data so this can not be combine into one query. In database management an aggregate function is a function where the values of multiple rows are grouped together to form a single value. Suppose,we want to sum the Duration of all the Billable Jobs on a custom object Job, the query can be as follows:. com has provided us developers some great materials to read about SOQL Injection. Mastering SOQL is the key to mastering Apex Once you start writing more complex pieces of code, you’ll soon run into governor limits. Support for aggregate functions in SOQL Developer Tools We often need to bring back way more data than we need to and do extra processing on the client because we can't use aggregate functions in SOQL queries. You can use aggregate functions without using a GROUP BY clause. Don't use a query to get recordTypeIds. In this Salesforce developer tutorial, the object is Contact and it’s alias name is Acct. It can search a record on a given criterion only in single sObject. Salesforce Developer ABSYZ Inc. v Dynamic SOQL in Apex —Apex requires that you surround SOQL and SOSL statements with square brackets in order to use them on the fly. Preface: this post is part of the SOQL: A Beginner's Guide series. Learn about Apex triggers and best practices for writing triggers; You will learn about DML statements, Database Methods, Salesforce Object Search Language (SOSL), Salesforce object Query Language (SOQL). SOQL(Salesforce Object Query Language) is used to query the records from the database based on the requirement. “Select * from Table_name” : You can use this query in Java,. Salesforce Object Query Language (SOQL) is used to search your organization’s Salesforce data for specific information. SOQL uses the SELECT statement combined with filtering statements to return sets of data, which may optionally be ordered:. Create a new Query in Design View. The SOQL ANTLR 4 grammar can be seen here. A list of governor limits specific to the @future annotation: 1. Learning to query records in Salesforce using SOQL -2. Aggregate functions in salesforce include AVG(), COUNT(), MIN(), MAX(), SUM(). pdf), Text File (. In this course, Apex Academy: The Power of SOQL, you get to see this power first hand. With the new 18 version of the API in sandboxes I can finally do a high level overview of SOQL (Salesforce Object Query Language) for all of the newcomers to the Force. Salesforce developer console has a menu bar, Workspace and Logs tab which contains several items like logs, Tests, Checkpoints, Query editor, Progress and problem. salesforce help; salesforce training; salesforce support. But this feature is not available in case of SOQL query. The following example demonstrates a SOQL query for loop used to mass update records. We have to specify the column names in the case of SOQL query. SOQL(Salesforce Object Query Language) Of Salesforce: SOQL is a query language to search your organization's data for relative information. You can write and execute a SOQL query in Apex code or in the Developer Console's Query Editor. Insights of SOQL and Relationship Queries on Force. Async SOQL is implemented via the Chatter REST API. What is the use of group by clause in SOQL? 30. com objects. Salesforce Developer Network: Salesforce1 Developer Resources. Create Salesforce SOQL Queries. The rows returned from the SELECT are then bulked up into blocks of up to 200 and sent a block at a time for an UPDATE or DELETE. When you build a Salesforce query in the Query Builder, Toad generates a SOQL query in the Query tab. In Salesforce SOQL aggregate functions are same as SQL aggregate function. com account, which comes with a handful of sample records populated with many of the Salesforce. Support for aggregate functions in SOQL Developer Tools We often need to bring back way more data than we need to and do extra processing on the client because we can't use aggregate functions in SOQL queries. A sample SOQL is written below: Select Id, Name from Account;. In your case, you have a column that is a date data type but you are using the format for a date time literal. To pull data from a Force. com IDE (integrated development environment), migration tools, SOQL (Salesforce Object Query Language) and web services. You can override it with a column alias. You can use SOQL to read information stored in your org's database. com platform. Which can be used to retrieve data from Salesforce org's database. You can use SOQL to read information stored in your org’s database. It is similar to SQL, it uses Object query language but not Joins for immediate navigation of data. Hi I am new to Salesforce SOQL. Prior to this feature being available, one would have to perform a large query, loop through it and perform calculations themselves to do things like count records, sum values, get the max value, etc.