-
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 4 years, 2 months ago by
Forcetalks.
-
This reply was modified 4 years, 2 months ago by
Log In to reply.
Popular Salesforce Blogs
Pass Salesforce AppExchange Security with Ease
Kizzy Consulting has worked on creating solutions by integrating several applications with Salesforce in the past year. This article will definitely help you prioritize steps…
What is Single Sign On (SSO)? How does it work in Salesforce?
Single Sign On by the name it is could be easily understood that single credentials to access multiple applications. It is a session service plus…
Communication between Lightning Web Components Guide
Here is our third article in the series on LWC. In the previous two, we delved into the principles of building and using components, as…
Popular Salesforce Videos
Tour to the Dreamforce National Park!
What happened at Dreamforce? #ArtificialIntelligence was a consistent theme, a lot more about Commerce, about Customer 360, etc Missed Dreamforce? Then, take a tour of…
Case Management App on Salesforce AppExchange
Is your customer support struggling with customer satisfaction for high service cost? Don't know how to work on right priority cases? Don't worry Algoworks presents…
What are Queues in Salesforce? | A Salesforce Video Tutorial
Queue is useful for load management and it is most useful for the object like leads and cases for managing the work in a better…
