summaryrefslogtreecommitdiff
path: root/app/Model
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2015-03-12 21:21:24 -0400
committerFrederic Guillot <fred@kanboard.net>2015-03-12 21:21:24 -0400
commit925ede9b48bef67739d26f0d0a394342f2d8edf0 (patch)
treed2ce47cb3793f8e64831ff7e04b3cddb35dcc498 /app/Model
parentac19e36b55b566f61d750e801134396fd4d3fada (diff)
parentb747b9750b697b863fcadbbbeb0ed94220e57961 (diff)
Merge and improve pull-request #704
Diffstat (limited to 'app/Model')
-rw-r--r--app/Model/TaskLink.php2
1 files changed, 2 insertions, 0 deletions
diff --git a/app/Model/TaskLink.php b/app/Model/TaskLink.php
index f8e9f99e..62391371 100644
--- a/app/Model/TaskLink.php
+++ b/app/Model/TaskLink.php
@@ -4,6 +4,7 @@ namespace Model;
use SimpleValidator\Validator;
use SimpleValidator\Validators;
+use PicoDb\Table;
/**
* TaskLink model
@@ -57,6 +58,7 @@ class TaskLink extends Base
->join(Link::TABLE, 'id', 'link_id')
->join(Task::TABLE, 'id', 'opposite_task_id')
->join(Board::TABLE, 'id', 'column_id', Task::TABLE)
+ ->orderBy(Link::TABLE.'.id ASC, '.Board::TABLE.'.position ASC, '.Task::TABLE.'.is_active DESC, '.Task::TABLE.'.id', Table::SORT_ASC)
->findAll();
}