protected function _buildQueryColumns(Library\DatabaseQuerySelect $query) { $state = $this->getState(); if ($state->distinct && !empty($state->column)) { $query->distinct()->columns($state->column)->columns(array('activities_activity_id' => $state->column)); } else { parent::_buildQueryColumns($query); $query->columns(array('created_by_name' => 'users.name')); } }
protected function _buildQueryGroup(Library\DatabaseQuerySelect $query) { $state = $this->getState(); if ($state->distinct) { $query->distinct(); $query->group($state->distinct); } else { $query->group('tbl.categories_category_id'); } }