Using sum in CDbCriteria

I need to sum a column as I pull it out of a database. My sql query works fine and is as follows:

SELECT User.userName, sum(views) FROM Rant LEFT JOIN User ON Rant.userId = User.userId GROUP BY User.userId ORDER BY views DESC LIMIT 5;

My CDbCriteria is as follows:

		$criteria=new CDbCriteria;

		$criteria->select = 'sum(views), userName';

		$criteria->with = 'user';

		$criteria->order='views DESC';

		$criteria->group = 'user.userId';


		$dataProvider3=new CActiveDataProvider('Rant', array(



I’m getting the following error when I try to loop through the data in my view:

record "Rant" is trying to select an invalid column "sum(views)". Note, the column must exist in the table or be an expression with alias.

Try this:

$criteria->select = 'sum(views) AS viewsCount, userName';

Yep - that worked, just needed to add an alias.

How do you display the column "viewsCount" in a CGridView?

I tried with my own column with an alias “total” like $data->total , but it didn’t work

how i can find user who having views more than 5 using CDbCriteria

ie how to use sum condition in CDbCriteria?

i got a solution for it

$detailTable = Payments::model()->tableName();

$detailTableSql = "payments.amount IS NULL OR (SELECT SUM(amount) FROM $detailTable WHERE $detailTable.order_id =<";

$criteria=new CDbCriteria;

$criteria->condition = $detailTableSql;

add a property name with viewsCount in model file, such as:

public viewsCount;