Is there a way now to do a "group by" in the API so that we can simulate a summary report? Will this be available in the API 8.0 version if not available now?
There is not support for GROUP BY in the API Query Language through version 8.0. API Version 8.0 does add support for ORDER BY, LIMIT, count() and relationship traversal (aka joins). For more information please refer to the API Documentation:
http://www.salesforce.com/us/developer/docs/api/index.htm
Message Edited by mtbclimber on 12-16-2006 10:28 AM