diff options
| author | Rafael de Camargo <rafacamargo123@gmail.com> | 2019-08-25 01:49:52 -0300 |
|---|---|---|
| committer | Frédéric Guillot <fred@kanboard.net> | 2019-08-27 20:28:58 -0700 |
| commit | 51b3d811e180656f7cc3ca75e071ceaef2d5bd46 (patch) | |
| tree | b6ac7fa2d18d7d5883a126cafbcba583c09f557d /app/Filter/TaskLinkFilter.php | |
| parent | 4d0762805448d285c2e6fba12a71b71c22496e13 (diff) | |
Changes filters from in array to in subqueries
Fixes #3280
Diffstat (limited to 'app/Filter/TaskLinkFilter.php')
| -rw-r--r-- | app/Filter/TaskLinkFilter.php | 11 |
1 files changed, 2 insertions, 9 deletions
diff --git a/app/Filter/TaskLinkFilter.php b/app/Filter/TaskLinkFilter.php index 98cd597f..0fa80d5c 100644 --- a/app/Filter/TaskLinkFilter.php +++ b/app/Filter/TaskLinkFilter.php @@ -57,13 +57,7 @@ class TaskLinkFilter extends BaseFilter implements FilterInterface */ public function apply() { - $task_ids = $this->getSubQuery()->findAllByColumn('task_id'); - - if (! empty($task_ids)) { - $this->query->in(TaskModel::TABLE.'.id', $task_ids); - } else { - $this->query->eq(TaskModel::TABLE.'.id', 0); // No match - } + $this->query->inSubquery(TaskModel::TABLE.'.id', $this->getSubQuery()); } /** @@ -76,8 +70,7 @@ class TaskLinkFilter extends BaseFilter implements FilterInterface { return $this->db->table(TaskLinkModel::TABLE) ->columns( - TaskLinkModel::TABLE.'.task_id', - LinkModel::TABLE.'.label' + TaskLinkModel::TABLE.'.task_id' ) ->join(LinkModel::TABLE, 'id', 'link_id', TaskLinkModel::TABLE) ->ilike(LinkModel::TABLE.'.label', $this->value); |