I have been using CSqlDataProvider with CGridView. The SQL query works fine with sorting but I would want to use some of the columns resulting from the query to filter info.
http://www.yiiframework.com/doc/api/1.1/CSqlDataProvider does not indicate how to achieve that.
I am using a query with joins from three or four tables, so I cannot just provide a model to CGridView’s filter parameter.
Any insights that could help me sort things out?