-
Formula Field in Aggregate Salesforce Query
Can any body suggest me how can i use the formula field in a aggregate soql query because when i am using the field it is throwing error that this field can't be grouped or aggregated
like
select count(id), formula__c from Object__c group by formula__c
-
5 Replies
-
Hello Ajit,
Formula fields are not "groupable" i.e they are not usable in the GROUP BY clause of a SOQL query.
-
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.
Example:
Schema.DescribeFieldResult resultObject= Object__c.formula__c.getDescribe();
if(resultObject.groupable == true){
formula__c is groupable
}else
formula__c is not groupable-
This reply was modified 8 years, 8 months ago by Ravi.
-
This reply was modified 8 years, 8 months ago by
-
Hi Ajit
To Check whether any field is "groupable" or not,Please follow the below procedure
Schema.DescribeFieldResult fieldDescribe = ObjectName.FieldName.getDescribe();
if(fieldDescribe.groupable == true){
Then Our Field is Groupable
}
Thanks
-
Formula fields are not "groupable" - that is, they are not usable in the GROUP BY clause of a SOQL query. There is limitation like Formula fields can't use in the group by Clause.
-
Hi
Formula fields are not groupable they are not usable in the GROUP BY clause of a SOQL query.
Log In to reply.
Popular Salesforce Blogs
Twilio Integration With Salesforce Part I - How to Send A Message From Salesforce to a Phone Number
This blog is the first part of Two part blog on Integrating your Twilio Account with Salesforce. In this blog, I will be displaying how…
Retrieve picklist value of a Record Type using MetaData Service in Salesforce
Picklist values are able to see using standard UI of sObject then field name and then record type name. What if we want to see…
Driving Operational Excellence with Lightning-Powered Enterprise Apps and Salesforce Development Partners
For a business to perform optimally and grow sustainably, its core and supporting departments, including marketing, sales, services, and human resources, require digital solutions to…
