Searching Multiple Models

Yii 1.1 General Discussion
1

Let’s say I have the following tables in my database (also converted to Models):

Table Name: items

Attributes:

item_id (Unique, auto increment)

        name


        price

Table Name: item_attributes

Attributes:

item_attribute_id (Unique, auto increment)

        item_id (Foreign Key to items.item_id)


        name


        value

I know each individual model has a search function, however I would like to be able to search for an item and have the system search return the item if it matches a field in the "item" table/model OR the "item_attributes" table/model for that item.

I’ve searched around a bit and haven’t really found a solution. Has anyone done this?

2

Or would I have to make a custom SQL query?

3

I am having the same problem. Can anyone help?

4

I think this is what you looking for.

Searching and sorting by related model in CGridView: http://www.yiiframework.com/wiki/281/searching-and-sorting-by-related-model-in-cgridview/