function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

group by clause

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:

Message Edited by mtbclimber on 12-16-2006 10:28 AM