Is CActiveDataProvider + CListView + FROM (select) possible?

Question

Yii

Good afternoon. I have a query like:

SELECT  * FROM (SELECT `t`.* FROM `table` `t` JOIN table2 t2 ON t2.id = t.column_id WHERE t2.column2_id = 1) as t1 GROUP BY `t1`.`id`

Is it possible to execute such a query for CActiveDataProvider and display the result via CListView?
While it turned out to be done through CSqlDataProvider, but after that CListView does not display data
Thank you.

Answer 1

The question is closed. Rewrote the query and use CActiveDataProvider

Answer 2

Try to pass the result of the query to CArrayDataProvider and display it in CListView.

Answer 3

Quite right. Use a query builder or write in pure SQL.