xPDOQuery.groupby
Last updated Dec 22nd, 2019 | Page history | Improve this page | Report an issue
Support the team building MODX with a monthly donation.
The budget raised through OpenCollective is transparent, including payouts, and any contributor can apply to be paid for their work on MODX.
Backers
Budget
$305 per month—let's make that $500!
Learn morexPDOQuery::groupby¶
Add a GROUP BY clause to the query.
Syntax¶
API Docs: xPDOQuery::groupby()
xPDOQuery groupby (string $column, [string $direction = ''])
Example¶
Grab the different 'type's of Boxes with at least one Box of width 15.
$query = $xpdo->newQuery('Box');
$query->where(array(
'width' => 15,
));
$query->groupby('type');
$boxes = $xpdo->getCollection('Box',$query);