virtualField count example for Dominik Gajewski

gistfile1.php

<?php
    class DepartmentBook extends AppModel
    {
        public $name = "DepartmentBook";

        public $virtualFields = array(
            'kl' => 'count(*)',
        );
    }
?>


<?php
    class DepartmentsController extends AppController
    {
        public $name "Departments";

        public function index( ){
            debug( $this->DepartmentBook->find( 'all', array(
                'fields' => array( 'DepartmentBook.kl', 'DepartmentBook.department_id' ),
                'conditions' => array( 'DepartmentBook.extract_date' => null ),
                'order' => array( 'DepartmentBook.department_id' ),
                'group' => array( 'DepartmentBook.department_id' ),
            )));
        }
    }
?>