From 9bc82296a93c348c376a7db472be1612f1785c3f Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Sat, 2 Jul 2016 18:53:35 -0400 Subject: Force sorting order in SQL for Postgres --- app/Model/TaskFinderModel.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'app/Model') diff --git a/app/Model/TaskFinderModel.php b/app/Model/TaskFinderModel.php index af39b924..0e8585ea 100644 --- a/app/Model/TaskFinderModel.php +++ b/app/Model/TaskFinderModel.php @@ -166,6 +166,7 @@ class TaskFinderModel extends Base ->table(TaskModel::TABLE) ->eq(TaskModel::TABLE.'.project_id', $project_id) ->eq(TaskModel::TABLE.'.is_active', $status_id) + ->asc(TaskModel::TABLE.'.id') ->findAll(); } @@ -183,7 +184,8 @@ class TaskFinderModel extends Base ->table(TaskModel::TABLE) ->eq(TaskModel::TABLE.'.project_id', $project_id) ->in(TaskModel::TABLE.'.is_active', $status) - ->findAllByColumn('id'); + ->asc(TaskModel::TABLE.'.id') + ->findAllByColumn(TaskModel::TABLE.'.id'); } /** -- cgit v1.2.3