Since you may not want to do this for every find call for your
model, you might want to setup a custom find type.
Then you could either add additional conditions and nested
conditions & sub-queries to the original request, or possibly
use the Model::query() call
Check out this page for some examples
On 11/2/2012 11:11 AM, Mathias R [via
i have a model which belongs to another like "model car belongs to
in table for rent-time there are two timestamps (start and end).
now i want to modify every find-statement for model car and add a
subquery like this:
select *, (select id from rent-time where start >= time() and
end <= time() and car_id = $car_id limit 0,1) as rent-time from
is it possible to modify original statement to add a subquery?
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 post to this group, send email to [hidden email] .
To unsubscribe from this group, send email to [hidden email] .
Visit this group at http://groups.google.com/group/cake-php?hl=en .
If you reply to this email, your
message will be added to the discussion below:
To start a new topic under CakePHP, email
To unsubscribe from CakePHP, click
View this message in context: http://cakephp.1045679.n5.nabble.com/add-subquery-to-every-find-state...
Sent from the CakePHP mailing list archive at Nabble.com.