xPDOQuery.having
Last updated not available | 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
$194 per month—let's make that $500!
Learn morexPDOQuery::having¶
Adds a HAVING clause to the query, used to filter grouped results after a GROUP BY. Without having(), you can group rows but cannot filter on the aggregate values.
Syntax¶
xPDOQuery having (mixed $conditions)
Example¶
$query = $xpdo->newQuery('Box');
$query->groupby('color');
$query->having(array('COUNT(*):>' => 5));
See Also¶
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
$194 per month—let's make that $500!
Learn more