1 files changed, 12 insertions, 3 deletions
diff --git a/app/Model/SubtaskModel.php b/app/Model/SubtaskModel.php
index 1e652ae2..626ccbef 100644
--- a/app/Model/SubtaskModel.php
+++ b/app/Model/SubtaskModel.php
@@ -88,13 +88,22 @@ class SubtaskModel extends Base
             ->asc(self::TABLE.'.position');
     }
 
+    /**
+     * Count by assignee and task status.
+     *
+     * @param integer $userId
+     * @return integer
+     */
     public function countByAssigneeAndTaskStatus($userId)
     {
-        return $this->db->table(self::TABLE)
+        $query = $this->db->table(self::TABLE)
             ->eq('user_id', $userId)
             ->eq(TaskModel::TABLE.'.is_active', TaskModel::STATUS_OPEN)
-            ->join(Taskmodel::TABLE, 'id', 'task_id')
-            ->count();
+            ->join(Taskmodel::TABLE, 'id', 'task_id');
+
+        $this->hook->reference('model:subtask:count:query', $query);
+
+        return $query->count();
     }
 
     /**