-
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.
- [adinserter block='9']
-
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 10 years, 1 month ago by
Ravi.
-
This reply was modified 10 years, 1 month 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.
