| public distinct ( array | Cake\Database\ExpressionInterface | string | boolean $on = [], boolean $overwrite = false ) | ||
| $on | array | Cake\Database\ExpressionInterface | string | boolean | Enable/disable distinct class or list of fields to be filtered on |
| $overwrite | boolean | whether to reset fields with passed list or not |
public function distinct($on = [], $overwrite = false)
{
if ($on === []) {
$on = true;
} elseif (is_string($on)) {
$on = [$on];
}
if (is_array($on)) {
$merge = [];
if (is_array($this->_parts['distinct'])) {
$merge = $this->_parts['distinct'];
}
$on = $overwrite ? array_values($on) : array_merge($merge, array_values($on));
}
$this->_parts['distinct'] = $on;
$this->_dirty();
return $this;
} /**
* Tests that it is possible to select distinct rows
*
* @return void
*/
public function testSelectDistinct()
{
$query = new Query($this->connection);
$result = $query->select(['author_id'])->from(['a' => 'articles'])->execute();
$this->assertCount(3, $result);
$result = $query->distinct()->execute();
$this->assertCount(2, $result);
$result = $query->select(['id'])->distinct(false)->execute();
$this->assertCount(3, $result);
}
