title: CakePHP - multiple paginated datasets on same page from same model
body: <p>I have an admin page that pulls data from my ExpenseClaim model. I want to have 3 different paginated tables, each table displaying data based on a different condition (a status). This is what I have (which doesn't work - nothing is paginated in the view) in my controller:</p>
  
  <pre><code>// Pending
  $this-&gt;set('claims', $this-&gt;paginate('ExpenseClaim', array('ExpenseClaim.claim_status_id' =&gt; '2')));
  
  // Get approved
  $this-&gt;set('approvedClaims', $this-&gt;paginate('ExpenseClaim', array('ExpenseClaim.claim_status_id' =&gt; '3')));
  
  // Get Declined
  $this-&gt;set('declinedClaims', $this-&gt;paginate('ExpenseClaim', array('ExpenseClaim.claim_status_id' =&gt; '4')));
  </code></pre>
  
  <p>Does anyone know how I can achieve this, I've do a fair amount of searching but only found things relating to different models or hacks using jquery plugins. Surely this can be done in cake alone?</p>
  
  <p>Thanks in advance</p>