Tell us what error you had, and split out the sql onto many lines to be neater.

Source Link

How do I create a SOQL GROUP BY using custom field? ForHow do I create a SOQL GROUP BY using custom field?

For example:

SELECT id, name, Cultura__c  
FROM SC_VPM__c  
GROUP BY Cultura__c

This returns an error:

MALFORMED_QUERY.

How do I create a SOQL GROUP BY using custom field? For example

SELECT id, name, Cultura__c FROM SC_VPM__c GROUP BY Cultura__c

How do I create a SOQL GROUP BY using custom field?

For example:

SELECT id, name, Cultura__c  
FROM SC_VPM__c  
GROUP BY Cultura__c

This returns an error:

MALFORMED_QUERY.

added 3 characters in body

Source Link

edited Oct 1, 2012 at 16:51

How do I create a SOQL GROUP BY using custom field? For example

SELECT id, name, Cultura__c FROM SC_VPM__c GROUP BY Cultura__c

SELECT id, name, Cultura__c FROM SC_VPM__c GROUP BY Cultura__c

How do I create a SOQL GROUP BY using custom field? For example

SELECT id, name, Cultura__c FROM SC_VPM__c GROUP BY Cultura__c

How do I create a SOQL GROUP BY using custom field? For example

SELECT id, name, Cultura__c FROM SC_VPM__c GROUP BY Cultura__c

Source Link

asked Oct 1, 2012 at 13:55

GROUP BY Clause SOQL

How do I create a SOQL GROUP BY using custom field? For example

SELECT id, name, Cultura__c FROM SC_VPM__c GROUP BY Cultura__c

soql trigger

Return to Question