When one needs to select a record in a table that do not have related records through a relation, it is generally suggested to use a subquery. Personnaly, I prefer a high level approach, and I have a method to do it with scopes.
Yii Framework Wiki
Wiki articles tagged with "relations"
Showing 1-6 of 6 items.
Cheat Sheet: Displaying Name instead of Numbers and Displaying Alphanumeric instead of numeric values
I keep a reference to some simple but painful task if you forget a common or something. I am new to Yii and this took awhile for me to figure out. Everything I read said do this or do that and not a single one worked for me. However, the following did.
Accessing data in a join table with the related models
Sometimes the right place to store application data is in a join table. For example, movie viewers either like or don’t like the movies they watched.
Searching and sorting by related model in CGridView
Created 12 years ago by Maciej Liżewski,
updated 10 years ago by Kostas Apazidis (KonApaz).
Lets say we have two models and relation between them:
1:n relations sometimes require CDbCriteria.together
There are situations in which Active Record will generate nonsense queries from what a nieve Yii user might think is reasonable code. One such situation is a CActiveDataProvider using CDbCriteria to get data from parent and 1:n child table with a condition on the child table.
Relations: BELONGS_TO versus HAS_ONE
It's very common to see new Yii users confusing the relations HAS_ONE and BELONGS_TO, and getting it wrong means you won't get proper values back. And though we'll talk about HAS_MANY as well, we're specifically omitting the MANY_MANY relation because it's a whole different animal.