Containable is "only" a kind of selective recursion. It does handle conditions on your associated models but that will only limit the data returned from that model... not from the main one. In short: it is not like a join.
For your type of query you either have to do a join or "fumble around" with the result set. If you haven't done joins in Cake before, check out the code in Nate's bakery article for some good example usage: http://bakery.cakephp.org/articles/view/quick-tip-doing-ad-hoc-joins-in-model-find /Martin On May 20, 12:18 pm, Günther Theilen <[email protected]> wrote: > Hi, > > I'm a little bit lost about how to shape my query with the containable > behaviour. > > There are two models: > A hasMany B > B belongsTo A > > B has a date-field > > Now I'd like to get one random data set out of A which has either > - no belonging entries in B > or > - only entries in B where date is more than 1 month ago > > Is this even possible with Containable or do I have to do several > queries and fumble around afterwards with PHP? > > Regards > Guenther --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
