sort is default asc, so 0 goes first

diff --git a/DataObjects/Core_project.php b/DataObjects/Core_project.php
index 832410d..8ab8cd7 100644 (file)
--- a/DataObjects/Core_project.php
+++ b/DataObjects/Core_project.php
@@ -79,7 +79,7 @@ class Pman_MTrack_DataObjects_Core_project extends Pman_Core_DataObjects_Core_pr
                         (join_status_id.name NOT IN('closed', 'on hold') OR  mtrack_ticket.status  = 0)
                         AND
                         mtrack_ticket.project_id = core_project.id
-                ),0) as no_tickets
+                ),0) as no_tickets, 
                 IF (COALESCE((
                     SELECT
                         count(mtrack_ticket.id)
@@ -93,9 +93,9 @@ class Pman_MTrack_DataObjects_Core_project extends Pman_Core_DataObjects_Core_pr
                         (join_status_id.name NOT IN('closed', 'on hold') OR  mtrack_ticket.status  = 0)
                         AND
                         mtrack_ticket.project_id = core_project.id
-                ),0) > 0, 1 , 0) as has_tickets
+                ),0) > 1, 0 , 0) as has_no_tickets
             ");
-            $this->_extra_cols = array('no_tickets','has_tickets');
+            $this->_extra_cols = array('no_tickets','has_no_tickets');
         }