/** * Prepare CakePHP paging * * @param Request $request DataTable request */ protected function preparePaging(Request $request) { self::$countBeforePaging = $this->query->count(); $this->query->limit($request->getLength()); $this->query->offset($request->getStart()); }