SOLVED
In belongsTo table I add:
$this->hasMany('TopLogs', [
'className' => 'Logs',
'strategy' => 'select',
'conditions' => function ($exp, $query) {
$query->leftJoin(
['TmpLogs' => 'logs'],
[
'TopLogs.group_id = TmpLogs.group_id',
'TopLogs.id < TmpLogs.id'
]);
return $exp->add(['TmpLogs.id IS NULL']);
}
]);
On Wednesday, September 23, 2015 at 10:42:05 AM UTC-3, [email protected]
wrote:
>
> Hi, I have this SQL a need to transform to ORM. I I appreciate any
> approach
>
>
> LOGS
> id - group_id - data
> 1 1 'Lorem ipsum 1'
> 2 1 'Lorem ipsum 2'
> 3 2 'Lorem ipsum 3'
>
>
> SQL return the latest record in your group:
> id - group_id - data
> 2 1 'Lorem ipsum 2'
> 3 2 'Lorem ipsum 3'
>
> SELECT logs.id,logs.group_id,logs.data
> FROM logs
> LEFT JOIN logs AS latest
> ON (logs.group_id = latest.group_id AND logs.id < latest.id)
> WHERE latest.id IS NULL
> ORDER BY logs.id DESC
>
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
