Cakephp group by count

$query = $articles->find();
$query->select([
    'count' => $query->func()->count('view_count'),
    'published_date' => 'DATE(created)'
])
->group('published_date')
->having(['count >' => 3]);

Source: book.cakephp.org

Similar codes

1 vote351 views1 answer
Add 2 hours to current time in cakephp
PHP CakePHP
0 vote303 views1 answer
Cakephp find_in_set
PHP CakePHP
-1 vote335 views1 answer
Element cakephp
PHP CakePHP
1 vote315 views1 answer
Cakephp 404 exception
PHP CakePHP
6 votes388 views1 answer
Get domain from url cakephp
PHP CakePHP
0 vote304 views1 answer
Cors header ‘access-control-allow-origin’ missing IN PARTICULAR CAKEPHP API
PHP CakePHP
0 vote322 views1 answer
Cakephp json response
PHP CakePHP
1 vote344 views1 answer
SaveAll get all id save cakephp
PHP CakePHP
0 vote320 views1 answer
CakeResque::enqueue
PHP CakePHP
0 vote363 views1 answer
How to use “find_in_set” in cakephp 3 find method
PHP CakePHP