-
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 ago by Ravi.
-
This reply was modified 8 years 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
More About Salesforce Custom Objects Behavior
Utilize the accompanying points to work out how the API communicates with custom items and fields: Naming Conventions for Custom Objects Relationships Among Custom Objects…
How to Effectively Manage Ideas on Salesforce Experience Cloud
The idea-creation process is a journey with many twists and turns. Ideas can be born in a flash, then bounce around for days or weeks…
Utility Class to Get Object Metadata - A Comprehensive Guide
Introduction In Salesforce development, Utility Classes play a crucial role in centralizing and organizing commonly used code logic, making the codebase more maintainable, readable, and…
