-
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 5 years, 1 month ago by
Forcetalks.
-
This reply was modified 5 years, 1 month ago by
Log In to reply.
Popular Salesforce Blogs
How Salesforce Einstein Can Help You Improve Your Lead Scoring?
In a previous article, we discussed Predictive Lead Scoring and its importance for contemporary marketing. In addition, we saw how the Salesforce CRM, with its cutting-edge…
How to Ensure a Smooth & Efficient Salesforce Implementation?
Salesforce CRM is a valuable tool in a tech stack for businesses, but its implementation can be a tricky affair unless careful thought & consideration…
Integrate Xero With Salesforce
Businesses seamlessly integrate various software platforms that streamline operations, improve efficiency, and enhance the customer experience. One powerful combination of integrating Salesforce, a leading customer…
Popular Salesforce Videos
DreamTX Welcome Day 1 | Dreamforce 2020 | Salesforce
If you missed DreamTX DAY 1, then live this amazing experience here, we have covered it all for you. Let’s come together for the Dreamforce…
14 Questions Asked in 95% Salesforce Interviews
In this video, Dan Croitor provides a list of 14 questions that are typically asked in Salesforce interviews. He goes over each question in detail,…
Copy to Clipboard Functionality in Salesforce - Lightning Component Projects Series Part 2
In this video, I'm creating a lightning component Project for functionality i.e Copy to Clipboard. Watch this video and learn. If you have any doubts…
