Containable could create multiple queries.
This is the solution I went for:
http://github.com/ionas/sna/blob/master/www/app/controllers/profiles_controller.php#L112
This could be another solution (not tested yet):
http://mark-story.com/posts/view/using-bindmodel-to-get-to-deep-relations
(interna
Here's a new tutorial that's a bit more relevant
http://foldifoldi.com/news/?p=466
On Dec 25, 9:15 am, foldiman wrote:
> Andrew,
> It sounds like you want to use a join in yourpaginationquery. If you
> have set up your model relationships, the joins may happen
> automagically. However, you c
Andrew,
It sounds like you want to use a join in your pagination query. If you
have set up your model relationships, the joins may happen
automagically. However, you can force the join using the 'joins'
parameter in the pagination query. For example:
$joins1 = array(
'table' => 'bug_relations',
'a
I would create an SQL statement using UNION to combine all the data
from multiple models and ordered by the same ORDER BY. But this means
probably that you have to use a custom query and I don't know if that
can be paginated!
Example:
(SELECT
a.id AS Result.id,
a.name AS Result.name,
a.cr
Greetings, all,
I know other people have worked on this before, but I haven't
been able to find a solution so far. So, the long and short of it is
that I've got multiple models that I want to mix into one view sorted
by the date created.
I've got a 'created' datetime field in the database alr
