Pagination Problems

Just for the record if you have already solved it.
In Ci4 that's the use of the callbacks in models. And what you need here is afterFind
So in the model you put something like...

PHP Code:

protected $afterFind = ['filterResults']; 


Then you create the method in the same model

PHP Code:

protected function filterResults($eventData)
    {
/*
$eventData = ['method', 'limit', 'offset', 'data', 'singleton']
*/

        switch ($eventData['method']) {
            case 'findAll':
                foreach ($eventData['data'] as $row) {

//modify the result here in case of findAll
                    $rows[] = $row;
                }

                return ['data' => $rows];

                break;
            case 'find':

                $row = $eventData['data'];

  // modify the result here in case of find
                return ['data' => $row];

                break;
            } 


With that the paginate still work.