diff options
| author | Frederic Guillot <fred@kanboard.net> | 2015-08-22 20:30:23 -0400 |
|---|---|---|
| committer | Frederic Guillot <fred@kanboard.net> | 2015-08-22 20:30:23 -0400 |
| commit | 89ca0908014413e17adf73de55ff1731b9729706 (patch) | |
| tree | 14bdda464046294c9f6fccd21f22aae75a50ee09 /app/Model/TaskFinder.php | |
| parent | cd9bc86fbeea01fa492606b9c19ded36bf0ab366 (diff) | |
Add milestone marker in board task
Diffstat (limited to 'app/Model/TaskFinder.php')
| -rw-r--r-- | app/Model/TaskFinder.php | 1 |
1 files changed, 1 insertions, 0 deletions
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', |