http://www.digitalbase.eu/blog A blog about webdesign, PHP, development and IT Mon, 10 May 2010 16:16:55 +0000 http://backend.userland.com/rss092 en My old post handled Propel 1.2. This is the way to do it in Propel 1.3 $c = new Criteria(); $c->add(FavoriteDatePeer::EVENTDATAPROPOSAL_ID, $this->getId()); $c->addSelectColumn("SUM(".FavoriteDatePeer::SCORE.") as rank"); $stmt = FavoriteDatePeer::doSelectStmt($c); $row = $stmt->fetch(); ... http://www.digitalbase.eu/blog/simplifying-queries-using-sum-count-etc-in-propel-13/ Earlier this week, I talked about our custom datagrid for Propel and how it was being rewritten to interact with our CriteriaBuilder (read more). Well, I'll give you another glance into our coding efforts. Goal We wanted to make an object, which would manipulate the data being shown in our grid_propel. For normal people, this means: to ... http://www.digitalbase.eu/blog/xajax-driven-criteriabuilder-for-propel-php/ To reduce the query count in your web application, you might consider using subqueries. I'll show you howto do that in propel/symfony : [code]propel - subqueries[/code] It's that easy :) http://www.digitalbase.eu/blog/symfony-propel-subquerys/ Simplifying Queries: Using sum, count, etc in Propel $c->addSelectColumn('sum('.dbTimeBlockPeer::TOTAL.') as total'); $rs = dbTimeBlockPeer::doSelectRS($c); while ($rs->next()) { $total = $rs->getInt(1); } So, simply use addSelectColumn. You have to work with the ResultSet offcourse, since you won't be able to populateObjects. In this case you can simply use '1' in getInt(column index), since we're sure only ... http://www.digitalbase.eu/blog/simplifying-queries-using-sum-count-etc-in-propel/ As you can read on Gijs' Lifelog, he started developing a custom datagrid a while ago. The idea was to create some kind of module/object, which would be used for generating datagrids fast, easy and intuitive, without too much code. Over time, it has been extended and rewritten to interact with ... http://www.digitalbase.eu/blog/custom-propel-grid-update/