You need to sign in to do that
Don't have an account?
Phuc Nguyen 18
Aggregate to get record count
Hello All,'
Trying to get count of records that has the same matching field value as the record being saved. Tried mapping but could never get teh correct value. Will someone assist with geving an example of using the aggregate function to ge tthe count? Example record being created has a text field Test__c and a value of dog. Need to find all of the existing records with the value dog in the Test__c field.
Thanks you for your time,
P
Trying to get count of records that has the same matching field value as the record being saved. Tried mapping but could never get teh correct value. Will someone assist with geving an example of using the aggregate function to ge tthe count? Example record being created has a text field Test__c and a value of dog. Need to find all of the existing records with the value dog in the Test__c field.
Thanks you for your time,
P
Use one of the following forms of syntax for COUNT():
- COUNT()
- COUNT(fieldName)
If you are using a GROUP BY clause, use COUNT(fieldName) instead of COUNT().Here are examples
Let me know if this helps, if it does, please close the query by marking it as solved. It may help others in the community. Thank You!