KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to do a simple query in doctrine but struggling. $query->select(array( 'app_title' => 'u.title', 'user_name' => 'u.user_name', 'first_used' => 'MIN(u.creation_time)', 'last_used' => 'MAX(u.stop_time)', 'total_usage' => 'SUM(u.stream_seconds)', )) ->from(self::USAGE_TABLE, 'u') ->orderBy('total_usage', 'DESC'); Obviously I get an error about the column name not being known because Doctrine is using it's own aliases (sclr4). However, if I try and order by the actual value; SUM(u.stream_seconds), then I get an unexpected bracket in the order by clause, I'm pretty sure SQL doesnt support this. So, I am simply trying to put data in a table and handle the sorting of the columns. This seems so simple, how do I do it? Any ideas?
Tags (comma-separated)
Save Edits
Cancel