Return value

$this

Arguments

$group

Group fields

String comma delimited list

Array List of fields

Full documentation

Get list of clients that have new projects

$this->get('pages','project')
    ->addWhere('status','New')
    ->setGroup('client')
    ->select(Array(
       'client' => '',
       'pcs' => 'COUNT',
       'first' => 'MIN(date)',
       'last' => 'MAX(date)'
    ));