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');
}
}
