-
Can we use aliasing in Salesforce?
Can we use aliasing in soql and if we can use it are there any limitations to it?
-
1 Reply
-
SOQL has very limited aliasing support. We can alias the table, e.g. SELECT a.name FROM Account a, but that's of very little use. In most contexts, we cannot alias fields.
The one exception is for queries that use aggregations, like SELECT COUNT(Id) recordcount FROM Account allows us to alias the result of the aggregation from it's default expr0 to recordCount.
-
This reply was modified 6 years, 1 month ago by
Forcetalks.
-
This reply was modified 6 years, 1 month ago by
Log In to reply.
Popular Salesforce Blogs
Install and Configure a Twilio App in Salesforce
Twilio for Salesforce Prerequisites Create a Twilio Account, if you don’t have it yet. MyDomain is configured for your Salesforce Instance. Create Twilio Account and…
How to Leverage Customer Segmentation in Salesforce for Maximum Impact
Imagine that you're organizing an event for a group of colleagues with different interests. To make it enjoyable for everyone, you could divide your guests…
Improve your Apex Code Unit | Salesforce Best Practices
In this blog, we are going to discuss the best practice of Apex. Apex code is used to write custom business logic. in any language,…
Popular Salesforce Videos
Salesforce Platform Quick Tip: How to Use Einstein Search
Want to improve your searches in Salesforce, and make them faster and more intuitive? In part one of this 2 part series, Trailblazer and Salesforce…
Salesforce & Google Analytics integration
Salesforce is one of the most popular CRMs available today. Many teams use Salesforce heavily for reporting and analysis. The ability to model the data…
Salesforce Public Groups and Queues
In this video, Bhavesh Jain demonstrates how to create Salesforce public groups and how they can be used, as well as provides an understanding of…
