CakePHP 2: is it posible to paginate a result like that?

#1

Let’s say we have 3 models: Alpha, Beta & Gamma.

From an action in GammaController, we need to paginate the results that would be obtained with the query:

select a.user_id, MAX(b.amount) as max_amount
from alpha a
left join beta b on (b.alpha_id = a.id)
group by a.user_id
order by max_amount desc;

The best result would be allowing the user to sort the result by any column.

Is this posible using CakePHP 2? If so, how?

Thank you,

0 Likes