Build query at CakePHP3

Question

I am trying to get the count of Comments for each Shop, and am really stuck on this step.
Is it possible to do it, and how?

public function display()
    {


        $this->loadModel('Shops');
        $shoplist=$this->Shops->find('all')->order(['title' => 'DESC', 'id' => 'ASC'])->contain([
            'Comments' => function ($q) {
                return $q->select('id')->where(['published' => 1])->count();
            }]);;

             $this->set('shoplist', $shoplist );
    }

return $q->select(['count' => $q->func()->count('*')]; – Vladyslav Havrylenko Oct 16 '15 at 09:20 — Vladyslav Havrylenko, Oct 16 '15 at 09:20

score 0 · Accepted Answer · answered Oct 17 '15 at 11:29

0

What you need is CounterCache Behavior

http://book.cakephp.org/3.0/en/orm/behaviors/counter-cache.html

answered Oct 17 '15 at 11:29

Salines

5,674
3
25
50

Build query at CakePHP3

1 Answers1