From 89ca0908014413e17adf73de55ff1731b9729706 Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Sat, 22 Aug 2015 20:30:23 -0400 Subject: Add milestone marker in board task --- app/Model/TaskFinder.php | 1 + 1 file changed, 1 insertion(+) (limited to 'app/Model/TaskFinder.php') diff --git a/app/Model/TaskFinder.php b/app/Model/TaskFinder.php index b98e3bd5..15274707 100644 --- a/app/Model/TaskFinder.php +++ b/app/Model/TaskFinder.php @@ -93,6 +93,7 @@ class TaskFinder extends Base '(SELECT count(*) FROM '.Subtask::TABLE.' WHERE '.Subtask::TABLE.'.task_id=tasks.id) AS nb_subtasks', '(SELECT count(*) FROM '.Subtask::TABLE.' WHERE '.Subtask::TABLE.'.task_id=tasks.id AND status=2) AS nb_completed_subtasks', '(SELECT count(*) FROM '.TaskLink::TABLE.' WHERE '.TaskLink::TABLE.'.task_id = tasks.id) AS nb_links', + '(SELECT 1 FROM '.TaskLink::TABLE.' WHERE '.TaskLink::TABLE.'.task_id = tasks.id AND '.TaskLink::TABLE.'.link_id = 9) AS is_milestone', 'tasks.id', 'tasks.reference', 'tasks.title', -- cgit v1.2.3