[Erp5-report] r29147 - /erp5/trunk/products/CMFActivity/bin/watch_activities

[nobody at svn.erp5.org]

Author: luke
Date: Wed Sep 23 11:32:48 2009
New Revision: 29147

URL: http://svn.erp5.org?rev=29147&view=rev
Log:
 - order by node so activities are changing in more expectable way

Modified:
    erp5/trunk/products/CMFActivity/bin/watch_activities

Modified: erp5/trunk/products/CMFActivity/bin/watch_activities
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/bin/watch_activities?rev=29147&r1=29146&r2=29147&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/bin/watch_activities [utf8] (original)
+++ erp5/trunk/products/CMFActivity/bin/watch_activities [utf8] Wed Sep 23 11:32:48 2009
@@ -37,7 +37,7 @@
 SELECT=""
 for t in message message_queue ; do
   SELECT=$SELECT"""
-  SELECT count(path) AS $t, method_id, processing, processing_node AS node, min(priority) AS min_pri, max(priority) AS max_pri FROM $t GROUP BY method_id, processing, processing_node;
+  SELECT count(path) AS $t, method_id, processing, processing_node AS node, min(priority) AS min_pri, max(priority) AS max_pri FROM $t GROUP BY method_id, processing, processing_node ORDER BY node;
   SELECT count(path) AS $t, processing, processing_node, min(priority) AS min_pri, max(priority) AS max_pri FROM $t GROUP BY processing, processing_node;
   SELECT count(path) AS ${t}_count FROM $t;
   """