[Fmsystem-commits] [9275] property: grouping

[Sigurd Nes]

Revision: 9275
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=9275
Author:   sigurdne
Date:     2012-05-04 09:24:10 +0000 (Fri, 04 May 2012)
Log Message:
-----------
property: grouping

Modified Paths:
--------------
    trunk/property/inc/class.soproject.inc.php

Modified: trunk/property/inc/class.soproject.inc.php
===================================================================
--- trunk/property/inc/class.soproject.inc.php  2012-05-04 08:33:51 UTC (rev 
9274)
+++ trunk/property/inc/class.soproject.inc.php  2012-05-04 09:24:10 UTC (rev 
9275)
@@ -1556,7 +1556,7 @@
                        . " FROM fm_workorder"
                        . " {$this->join} fm_workorder_status ON 
fm_workorder.status  = fm_workorder_status.id"
                        . " WHERE project_id = {$project_id} AND 
(fm_workorder_status.closed IS NULL OR fm_workorder_status.closed != 1)"
-                       . " GROUP BY fm_workorder.id, fm_workorder.start_date 
ORDER BY start_date ASC";
+                       . " GROUP BY fm_workorder.id, 
fm_workorder.start_date,fm_workorder.addition ORDER BY start_date ASC";
                        $this->db->query($sql,__LINE__,__FILE__);