public function onAfterCreate() { parent::onAfterCreate(); $db = $this->criteria->getClassMap()->getDB(); $sql = $this->criteria->getSqlStatement(false); $countSQL = clone $sql; $countSQL->columns = array('count(*) as CNT'); $queryCNT = $db->getQuery($countSQL); $this->totalRecords = $queryCNT->fields('CNT'); $range = new MRange($this->pageNumber, $this->pageLength, $this->totalRecords); $sql->setRange($range); $query = $db->getQuery($sql); $cursor = new Cursor($query, $this->criteria->getClassMap(), false, $this->criteria->getManager()); $this->objArray = $cursor->getObjects(); $this->rowCount = count($this->objArray); }