CakePHP filtering data with conditions on its related data

Question

If I have models like:

User hasMany house hasMany belongings

and I want to select all Users and the related models, but only if the user has one or more belongings--how would I set that condition? Thanks!!

Do you mean return only users who have houses with belongings in them? — Shaz MJ, Aug 19 '11 at 10:33

score 0 · Answer 1 · answered Aug 19 '11 at 04:15

0

use counterCache, then you can set the condition in pagination: 'belonging_count >'=> 0

answered Aug 19 '11 at 04:15

Anh Pham

1 Answers1