Filtering with CGridView and CSqlDataProvider

Hi Guys,

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?

Many thanks,

Cass

In this post I explain how I did it

Hi Gustavo, cheers for the post, I had not seen it! Apologies for that. I will make some remarks on the other post.

No problem

Glad I could help

Cheers