Set conditions for pagination

Question

I'm trying to do custom paginates on CakePHP, the thing is that I want to pass custom conditions, something like this:

$conditions['People'] = $this->People->find('all',
    array(
        'order' => array('People.id DESC'),
        'limit' => 16, 
        'order' => 'People.id DESC'
    )
);

$people = $this->paginate('People',$conditions);

That's basically all the code involving pagination, but it doesn't work, it throws that it doesn't find the column People...

I just want to do paginations with custom conditions, that is, I want to set the conditions beforehand, is there a way to do that?

Answer 1

Did you take a look at the documentation?

According the documentation you should add conditions like this:

public function list_recipes() {
    $this->Paginator->settings = array(
        'conditions' => array('Recipe.title LIKE' => 'a%'),
        'limit' => 10
    );
    $data = $this->Paginator->paginate('Recipe');
    $this->set(compact('data'));
}

So guess this should work:

public function list_people() {
    $this->Paginator->settings = array('order' => array('People.id DESC'),'limit' => 16,'order' => 'People.id DESC');
    $data = $this->Paginator->paginate('People');
    $this->set(compact('data'));
}

Answer 2

here is how I am doing it in cake 2.x

first of all be sure to include paginator component and helper in your controller, like

$public $components = array(
  'Paginator'
);

$public $helpers = array(
  'Paginator'
);

then in your action

$options = array(
    'conditions' => array(
        'Post.status' => 1
    ),
    'fields' => array(
        'Post.id',
        'Post.title',
        'Post.created'
    ),
    'order' => array(
        'Post.created' => 'DESC'
    ),
    'limit' => 10
);

$this->Paginator->settings = $options;
$posts = $this->Paginator->paginate('Post');