It doesn’t appear this is possible.
I’d like to do a simple single-query get($id) on my entity and include associated records, but only those that meet the specified criteria.
So for example: get an article plus the very last comment posted for it and the name of the last user to edit the article… or get the article, plus only comments posted by a specific user/user type.
This may be a good time to ask: why is get() so different from all the other find methods? (i.e., ‘contain’ is an argument)… and why do I seem to detect an inconsistency of when to use ‘conditions’ vs ‘where’ or ‘fields’ vs ‘select’ in these functions… and finally… the number of utterly different ways to talk to the database with cake is huge and they are sometimes interchangeable and inter-compatible and sometimes not. Super confusing.