Pagination on related records CakePHP4

Need Help
1

When baking an app, you get a view.php able to show the child records related to a parent record:

2021-08-11-12-13-54_scrot
2021-08-11-12-13-54_scrot1223×606 30.9 KB

The child records are not paginated like they are by default in the index.php when baking that template.

How to change the baked controller to get the pagination into effect?

My ‘natural’ thing to do is:

    public function view($id = null)
    {

		$group = $this->paginate($this->Groups->get($id, [
            'contain' => ['Individuals'],
        ]));

        $this->set(compact('group')); 

    }

but CakePHP makes clear that’s not the way to go (and I guess the bake command would deliver this by default?)

The cookbook tries to tell me something (https://book.cakephp.org/4/en/controllers/components/pagination.html#control-which-fields-used-for-ordering), but because my lack of knowledge, can’t implement it in the right way.

StackOverflow has a topic (paginate associated records), it’s several years old, is it THE solution with CakePHP4?

So, how can I get my related records paginated?

2

Followed the StackOverfow to query the related records separately:

    public function view($id = null)
    {
/*
		$group = $this->Groups->get($id, [
            'contain' => ['Individuals'],
        ]);

        $this->set(compact('group')); 
*/

		$group = $this->Groups->get($id);

		$this->loadModel('Individuals');
   
        $individuals = $this->paginate($this->Individuals
        ->find()
        ->where(['group_id =' => $id]));

        $this->set(compact('group','individuals')); 		

    }

After all a no-brainer indeed, the shown page is the combo of a view-template of the parent and an index-template of a child, so the underpinnings will also have to be combined. It was the category query in the StackOverflow example which made it a bit ‘overwhelming’.