More or less I use auto-complete field for a form. CJuiAutoComplete is a yii widget for this purposes.
The common use case is to make an ajax request and retrieve a list from the database. So in this case you have to write a controller action to return you a json encoded list.
What if I had a generic action to do this work for me?
If you show a model (with a lot of attributes) partially in a CGridView, it can be helpful when the user can take a quick look at the full record with all attributes without displaying the view
as a page and afterwards returning back to the gridview.
When using the latest stable jQuery UI themes (1.8.10) with Yii 1.1.6 (which uses 1.8.6) the widgets don't appear (they're invisible but they're there). In order to make them visible you need to change the following line:
First param in CActiveDataProvider could be a string with model name or instance of class. So, you may use CActiveRecord::cache() for cache, but you need set third param to 2, because you should cache 2 queries: counting and get data.